DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Help: some plsql question

  1. #1
    Join Date
    Jan 2001
    Posts
    11
    Which statement about multiple column subqueries is true?
    A a pairwise comparison produces a cross product
    B a nonpairwise comparison produces a cross product
    C in a pairwise subquery, the values returned from the subquery are compared individually to the values in the outer query
    D in a nopairwise subquery, the values returned from the subquery are compared as a group to the values in the outer query

    which statement is valid about projection?
    a) projection allows you to choose rows
    b) projection allows you to choose columns
    c) projection allows you to join tables
    d) projection allows you to add colums to a table

    19. which operator can not be used in nonequel join.
    a. in.
    b. like.
    c. equal operator *
    d. between...and..

    49. which statement about implicit cursor is true?
    a. implicit cursor are declared implicitly only for dml statement.
    b. implicit cursor are dclared implicitly for dml statement and all select statement. *
    c. programer need to close all the implicit cursor befor the end of pl/sql program.

    45. which situation about implict cusor is true
    a. all dml

    b. all dml and select statements

    i choice: b

  2. #2
    Join Date
    Dec 2000
    Posts
    4

    PL?SQL question

    Hi xuqingyu,

    If you remember more exam questions on PL/SQL(DBA Track), plus in case you have some brain dump could you please send them to me at the mail id: Oracledba@atozasia.com

    regards


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width