0

databases Online Quiz - 117

Description: databases Online Quiz - 117
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. %Found

  2. %NOTFOUND

  3. %ROWCOUNT

  4. %ISOPEN


Correct Option: A,B,C,D

How to view installed Oracle version information

  1. select banner from v$version;

  2. select # from v$version;

  3. select ver from v$version

  4. select version from v$version;


Correct Option: A
  1. No_Data_Found

  2. Too_many_rows

  3. Value_Error

  4. Zero_Error


Correct Option: A,B,C,D

Cursor_Already_Open is a valid Cursor exception?

  1. True

  2. False


Correct Option: A

Data integrity exists on ACCESS LOCK?

  1. True

  2. False


Correct Option: B
  1. Tables with already existing data

  2. Empty tables

  3. Both 1 & 2

  4. None of the above


Correct Option: B
  1. FROM clause

  2. WHERE clause

  3. Correlated sub query

  4. None of the above


Correct Option: C
  1. The query returns the rows in the query result set without producing an error.

  2. Return no rows

  3. Produces an error

  4. The query returns rows


Correct Option: A

MULTILOAD faster than FLOAD

  1. True

  2. False


Correct Option: B
  1. the fastest AMP invloved

  2. slowest AMP involved

  3. sum of all amps involved

  4. average performance of all AMPs


Correct Option: B

Which three definitions are associated with implicit cursors?

  1. %rowtype, %toomanyrows, %found

  2. %found, %notfound, %rowcount

  3. %rowtype, %rowcount, %notfound

  4. None of the above


Correct Option: B

Which command will delete all data from a table and will not write to the rollback segment?

  1. DROP

  2. DELETE

  3. TRUNCATE

  4. CASCADE


Correct Option: C
- Hide questions