ORACLE10gDBA1z0-042认证考题及答案2
6.Your database performance has degraded due to frequent checkpointing. What would you do in this scenario?A: make redo log files smaller
B: increase the size of the checkpoint file
C: make the changes as per the advice given by MTTR Advisor
D: make the changes as per the advice given by Checkpoint Advisor
Correct Answers: C
7.You want to perform a backup of your database to tape. Which backup format can you use?
A: backup set only
B: image copy only
C: only user-managed backup
D: both image copy and backup set
E: only incremental image copy backup
Correct Answers: A
8.In the middle of a transaction, a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario? (Choose two.)
A:Event Viewer gives more details on the failure.
B:The alert log file gives detailed information about the failure.
C:PMON rolls back the transaction and releases the locks.
D:SMON rolls back the transaction and releases the locks.
E:The transaction is rolled back by the next session that refers to any of the blocks updated by the failed transaction.
F:Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.
Correct Answers: C, F
9.Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true? (Choose two.)
A:The destination must be global only.
B:A maximum of five destinations can be assigned.
C:A maximum of ten different destinations can be assigned.
D:All the destinations are determined by the server automatically.
E:The destination may be local or remote for a Standby Database.
F:The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.
Correct Answers: C, E
10.You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?
A: The backup status will be marked expired in RMAN recovery catalog.
B: The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
C: The backup will be deleted physically from the OS and the backup information is removed from the recovery catalog.
D: The backup status will be marked deleted and you must delete the backup file manually from the operating system (OS).
E: The backup status will be marked deleted and you must delete the backup file manually from OS, if you are not using Oracle Managed Files
(OMF).
Correct Answers: C
页:
[1]