Which of the following is a correlated subquery?
Uses the result of an inner query to determine the processing of an outer query.
Uses the result of an outer query to determine the processing of an inner query.
Uses the result of an inner query to determine the processing of an inner query.
Uses the result of an outer query to determine the processing of an outer query.
How many tables may be included with a join?
1
2
3
all of the above
Which of the following is true concerning triggers?
You do not create them with SQL.
They execute against only some applications that access a database.
They have an event, condition, and action.
They cannot cascade (cause another trigger to fire).
There should be one condition within the WHERE clause for each pair of tables being joined.
TRUE
FALSE
DO not know
Both
The code to create triggers and routines is stored in only one location and is administered centrally.
BOTH
DO NOT KNOW
When LGWR process write redo log buffer to redo log files?
Log buffer is one-third full
Commit transaction
every three seconds
redo log file switch
C-EMS Oracle database is configured as NO ARCHIVELOG mode.
True
False
Which process kicks in DBWR process?
LGWR
DBWR
CKPT
ARCH
Name logical unit of storage which is combination of one of more datafiles.
Segment
Block
Tablespace
View
Rollback transaction data is stored in which data file.
System
Sysaux
Undo
Index