Database Mock Test - 2

9 Questions

Settings
Please wait...
Database Mock Test - 2

This is a simple quiz which is created for test your basic data base knowledge!


Related Topics
Questions and Answers
  • 1. 
    What does a positive value of SQL code mean?
    • A. 

      Error

    • B. 

      Successful execution

    • C. 

      No rows found

  • 2. 
    . AUTOMATIC RECOMPILATION occurs when
    • A. 

      A existing index is dropped.

    • B. 

      A new index is created.

    • C. 

      Both (A) and (B).

  • 3. 
    Collections are essentially just a means of giving a name to a logically related set of packages
    • A. 

      True

    • B. 

      False

  • 4. 
    Cartesian product ‘ is the result of a join that does not specify matching columns
    • A. 

      True

    • B. 

      False

  • 5. 
    13   Group By does not do any sorting .        
    • A. 

      True

    • B. 

      False

  • 6. 
    .    In EXIST operator when a match is found, the query ends processing for that row
    • A. 

      True

    • B. 

      False

  • 7. 
    .   GRANT SELECT ON EMPTAB TO USER  is a correct syntax
    • A. 

      True

    • B. 

      False

  • 8. 
    Performed for each row in the result table
    • A. 

      Scalar function

    • B. 

      Group by

    • C. 

      Aggregate function

  • 9. 
    .    What is single bound DBRM with optimized access path .
    • A. 

      1) PLAN

    • B. 

      2) PACKAGE

    • C. 

      3) BIND