Tag: databases

Questions Related to databases

  1. Uses the result of an inner query to determine the processing of an outer query.

  2. Uses the result of an outer query to determine the processing of an inner query.

  3. Uses the result of an inner query to determine the processing of an inner query.

  4. Uses the result of an outer query to determine the processing of an outer query.


Correct Option: B
  1. You do not create them with SQL.

  2. They execute against only some applications that access a database.

  3. They have an event, condition, and action.

  4. They cannot cascade (cause another trigger to fire).


Correct Option: C
  1. Log buffer is one-third full

  2. Commit transaction

  3. every three seconds

  4. redo log file switch


Correct Option: A,B,C

Rollback transaction data is stored in which data file.

  1. System

  2. Sysaux

  3. Undo

  4. Index


Correct Option: C