| | | | MCQ Tutorial - Data Base->Oracle | | | | 1.) SNAPSHOT is used for? | | Options are: | | A.) Synonym
| | B.) System server
| | C.) Table space
| | D.) Dynamic data replication
| | Correct Option: D | | | | | | | 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
| | Correct Option: B | | | | | | | 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
| | Correct Option: B | | | | | | | 4.) LGWR process writes information into | | Options are: | | A.) All Redolog, Control & Database files
| | B.) Database files
| | C.) Redolog files
| | D.) Control files
| | Correct Option: C | | | | | | | 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
| | Correct Option: B | | | | | | | | | | | |