In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）A、the V$LOG viewB、the V$DBFILE viewC、the V$LOGFILE viewD、the V$INSTANCE_RECOVERY viewE、Oracle Enterprise Manager Database Control
In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）
- A、the V$LOG view
- B、the V$DBFILE view
- C、the V$LOGFILE view
- D、the V$INSTANCE_RECOVERY view
- E、Oracle Enterprise Manager Database Control
相关考题：
Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）A、The database is in mount state.B、One of the tablespaces is offline.C、One of the tablespaces is read only.D、The database operates in ARCHIEVELOG mode. E、The database operates in NOARCHIEVELOG mode.
Which statements are true regarding SecureFile LOBs？（） A、 The amount of undo retained is user controlled.B、 SecureFile LOBs can be used only for nonpartitioned tables.C、 Fragmentation is minimized by using variable-sized chunks dynamically.D、 SecureFile encryption allows for random reads and writes of the encrypted data.E、 It automatically detects duplicate LOB data and conserves space by storing only one copy.
Which two statements are true regarding the WebLogic domain?（）A、A WebLogic domain can have more than one Administration server.B、A WebLogic domain has at least one WebLogic server.C、A WebLogic domain can have at the most one cluster. D、A WebLogic domain can cross multiple physical machines. E、Each WebLogic domain is associated with a different Node Manager.
Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?（）A、Start the server with the – innodb_recover_options option set to FORCEB、Start the server with the – innodb_force_recovery option set to a non-zero valueC、Start the server as usual, and then execute the REPAIR TABLE commandD、Start the server as usual, and then execute the CHECK TABLE command
It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）A、cannot be used in RMANB、by starting up the database againC、by using the CATALOG command of RMAND、by using the RECOVER CATALOG command in RMANE、by re-creating the target control file to rebuild the RMAN repository
On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30am. Which option must you use to check whether a flashback operation can recover the database to the specified time?（）A、Check the alert log fileB、Query the V$FLASHBACK_DATABASE_LOG viewC、Query the V$RECOVERY_FILE_DEST_SIZE viewD、Query the V$FLASHBACK_DATABASE_STAT viewE、Check the value assigned for the UNDO_RETENTION parameter
当对数据库进程调整时，要求除DBA用户外的其它用户都不能访问数据库，这时可以用以下哪种数据库启动方式（）A、STARTUP NOMOUNTB、STARTUP MOUNTC、STARTUP RESTRICTD、STARTUP DBAE、STARTUP FORCE
Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?（）A、One runs faster than the otherB、A conventional path data load bypasses most of the Oracle RDBMS, whereas a direct path load is a high-speed version of the SQL INSERTC、A direct path data load bypasses most of the Oracle RDBMS, whereas a conventional path load is a high-speed version of the SQL INSERTD、The conventional path runs when the CONVENTIONAL command-line parameter is set to TRUE
The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following globalization elements？（） A、 Date formatB、 Decimal characterC、 Group separatorD、 First day of the monthE、 None of the aboveF、 All of the above