Tag: databases

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.

1

2

3

all of the above

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

TRUE

FALSE

DO not know

Both

TRUE

FALSE

BOTH

DO NOT KNOW

Log buffer is one-third full

Commit transaction

every three seconds

redo log file switch

True

False

LGWR

DBWR

CKPT

ARCH

Segment

Block

Tablespace

View

System

Sysaux

Undo

Index