MCQ Tutorial - Data Base->Oracle

1.) SNAPSHOT is used for?

Options are:

A.) Synonym

B.) System server

C.) Table space

D.) Dynamic data replication

2.) We can create SNAPSHOTLOG for

Options are:

A.) For both Simple and Complex snapshots

B.) For Simple snapshots

C.) For neither Simple nor Complex snapshots

D.) For Complex snapshots

3.) ENQUEUE resources parameter information is derived from

Options are:

A.) DB__BLOCK_SIZE

B.) Processes or DDL_LOCKS and DML_LOCKS

C.) DML_LOCKS

D.) LOG_BUFFER

4.) LGWR process writes information into

Options are:

A.) All Redolog, Control & Database files

B.) Database files

C.) Redolog files

D.) Control files

5.) Databases overall structure is maintained in a file called

Options are:

A.) Redolog file

B.) Control file

C.) All Control, Redolog and Data base file

D.) Data base file