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

What is the maximum number of Nested SubQueries used in WHERE Clause?

  1. 255

  2. 256

  3. 300

  4. 225


Correct Option: A

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

What are the min.extents allocated to a rollback extent?

  1. 1

  2. 2

  3. 3

  4. 4


Correct Option: B

What is the maximum number of triggers, can apply to a single table?

  1. 11

  2. 14

  3. 10

  4. 12


Correct Option: D

Identify the OLAP function from the given options

  1. MSUM

  2. SUM

  3. AVG

  4. All of the above


Correct Option: A

This table will have duplicate rows

  1. Volatile Table

  2. Global Temporary table

  3. MultiSet Table

  4. Permanent Table


Correct Option: C

When Database A has 5GB of spool space, Database B is created as child of Database A with 3GB of spool space, then Database A will have

  1. 2GB of spool space

  2. 5GB of spool space

  3. 2GB of permanent space

  4. 3GB of spool space


Correct Option: B
  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
  1. Temporary Space

  2. Spool Space

  3. Permanent Space

  4. Any of the above


Correct Option: B

An USER cannot have these if Permanent space is not allocated to it

  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

This table will have duplicate rows

  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

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

Volatile temporary table is materialized at

  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

An USER cannot have these if Permanent space is not allocated to it

  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