MOUNT mode
RESTRICTED mode
OPEN mode
NOMOUNT mode
第1题:
by using the DBMS_REPAIR package
by using the DBVERIFY utility
by using Block Media Recovery
by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command
第2题:
Start the database in the MOUNT stage.
Back up the control file to trace.
Set the DBID
Issue the RECOVER DATABASE command.
第3题:
It would return information regarding only the last committed transaction.
It would return only the active transactions in all the undo segments in the database.
It would return only the committed transactions in all the undo segments in the database.
It would return both active and committed transactions in all the undo segments in the database.
It would return information regarding the transactions that began and were committed in the last 30 minutes.
第4题:
MMAN
PMON
MMON
MMNL
第5题:
The command will be executed successfully.
The command will fail because RESOURCE_CONSUMER_GROUP is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
The command will fail because LOGGING_LEVEL is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
The command will fail because LOG_HISTORY is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
The command will fail because 1200 is an invalid value for the LOG_HISTORY parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
第6题:
LOGGING_OFF
LOGGING_RUNS
LOGGING_FULL
LOGGING_NULL
第7题:
take the backup of the flash recovery area less frequently
increase the value of the UNDO_RETENTION initialization parameter
change the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTO
change the backup retention policy to retain the backups for a smaller period of time
increase the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameter
increase the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter
第8题:
recovery catalog
Oracle Enterprise Manager Repository
Automatic Workload Repository (AWR)
Oracle 10g Enterprise Manager Grid Control
Automatic Database Diagnostic Monitor (ADDM)
第9题:
2, 7, 3, 5, 1, 6, 4
2, 1, 7, 6, 3, 5, 4
7, 1, 3, 2, 6, 5, 4
7, 2, 3, 1, 4, 6, 5
第10题:
BMR lowers the mean time to recover (MTTR).
BMR supports point-in-time recovery of individual data blocks.
BMR enables you to use incremental backups for block recovery.
BMR enables recovery even when the database is not mounted or open.
BMR enables you to use proxy backups to perform block media recovery.
BMR enables increased availability of data during recovery because the data file requires a recovery can remain online.