Tag: databases

Questions Related to databases

Which of the following is a correlated subquery?
technology 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.

Show answer
Correct Option: B

How many tables may be included with a join?
technology databases

  1. 1

  2. 2

  3. 3

  4. all of the above

Show answer
Correct Option: D

Which of the following is true concerning triggers?
technology databases

  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).

Show answer
Correct Option: C

There should be one condition within the WHERE clause for each pair of tables being joined.
technology databases

  1. TRUE

  2. FALSE

  3. DO not know

  4. Both

Show answer
Correct Option: A

The code to create triggers and routines is stored in only one location and is administered centrally.

technology databases

  1. TRUE

  2. FALSE

  3. BOTH

  4. DO NOT KNOW

Show answer
Correct Option: A

When LGWR process write redo log buffer to redo log files?

technology databases

  1. Log buffer is one-third full

  2. Commit transaction

  3. every three seconds

  4. redo log file switch

Show answer
Correct Option: A,B,C

C-EMS Oracle database is configured as NO ARCHIVELOG mode.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which process kicks in DBWR process?
technology databases

  1. LGWR

  2. DBWR

  3. CKPT

  4. ARCH

Show answer
Correct Option: C

Name logical unit of storage which is combination of one of more datafiles.
technology databases

  1. Segment

  2. Block

  3. Tablespace

  4. View

Show answer
Correct Option: C

Rollback transaction data is stored in which data file.

technology databases

  1. System

  2. Sysaux

  3. Undo

  4. Index

Show answer
Correct Option: C