0

databases Online Quiz - 102

Description: databases Online Quiz - 102
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Where would you look for errors from the database engine?

  1. Database Log

  2. Alert Log

  3. Error Log

  4. Session Log


Correct Option: B
  1. Volatile Table

  2. Global Temporary table

  3. MultiSet Table

  4. Permanent Table


Correct Option: C
  1. Secondary Index

  2. First unique column in the table

  3. Primary key

  4. First non-unique coulmn in the table


Correct Option: C
  1. Permanent Table

  2. Set Table

  3. Multiset Table

  4. Volatile Table


Correct Option: D

This temporary table will not be dropped once the session is signed off

  1. Volatile Temporary Table

  2. Global Temporary table

  3. MultiSet Table

  4. Permanent Table


Correct Option: B
  1. Temporary Space

  2. Spool Space

  3. Permanent Space

  4. Any of the above


Correct Option: B

Intermediate results of the user query is materialized at

  1. Temporary Space

  2. Spool Space

  3. Permanent Space

  4. Any of the above


Correct Option: B
  1. Permanent Table and Stored Procedure

  2. Permanent View and Stored Procedure

  3. Macros and Stored Procedure

  4. None of the above


Correct Option: A
  1. Volatile Table

  2. Global Temporary table

  3. MultiSet Table

  4. Permanent Table


Correct Option: C
  1. Secondary Index

  2. First unique column in the table

  3. Primary key

  4. First non-unique coulmn in the table


Correct Option: C
  1. Volatile Temporary Table

  2. Global Temporary table

  3. MultiSet Table

  4. Permanent Table


Correct Option: B
  1. Temporary Space

  2. Spool Space

  3. Permanent Space

  4. Any of the above


Correct Option: B
  1. Temporary Space

  2. Spool Space

  3. Permanent Space

  4. Any of the above


Correct Option: B
  1. Permanent Table and Stored Procedure

  2. Permanent View and Stored Procedure

  3. Macros and Stored Procedure

  4. None of the above


Correct Option: A
- Hide questions