1Z0-031
单选题You have implemented OMF for redo log management. Which of the following choices reflects a log filename that might be employed when OMF is enabled?（）A log01.log B logORCL01.log C 1_2.logALTER ROLLBACK SEGMENT D ora_1_asdf1234.log
题目
log01.log
logORCL01.log
1_2.logALTER ROLLBACK SEGMENT
ora_1_asdf1234.log
相似问题和答案
第1题：
A. OMF cannot be used in a database that already has data files created with user-specified directions.
B. The file system directions that are specified by OMF parameters are created automatically.
C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.
D. OMF automatically creates unique file names for table spaces and control files.
E. OMF may affect the location of the redo log files and archived log files.
第2题：
You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）
- A、Writes buffers to disk
- B、Writes current redo log number to datafile headers
- C、Writes redo log information to disk
- D、Reads information into memory for users
正确答案:B
第3题：
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;Which action should you perform immediately after using this command?（）
A. You should perform a log switch
B. You should make a backup of the database
C. You should switch the database to the NONARCHIVELOG mode
D. You should shut down the database instance and perform a complete database recovery
第4题：
You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）
- A、ALTER DATABASE
- B、ALTER SYSTEM
- C、ALTER USER
- D、ALTER REDO LOG
正确答案:B
第5题：
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）
- A、archival
- B、log writer
- C、database writer
- D、system monitor
- E、process monitor
- F、change tracking writer
正确答案:A,B,C
第6题：
Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:/REDO01.LOG' You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?（）
- A、ALTER DATABASE DROP LOGFILE GROUP 1;
- B、ALTER DATABASE CLEAR LOGFILE GROUP 1;
- C、ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
- D、ALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG
正确答案:C
第7题：
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file： ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3； Which action should you perform immediately after using this command？（）
- A、 You should perform a log switch
- B、 You should make a backup of the database
- C、 You should switch the database to the NONARCHIVELOG mode
- D、 You should shut down the database instance and perform a complete database recovery
正确答案:B
第8题：
Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains oneredo member. When you attempt to start the database, you receive the following errors:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: ‘D:\REDO01.LOG‘You discover that the online redo log file of the current redo group is corrupted.Which statement should you use to resolve this issue?（）
A. ALTER DATABASE DROP LOGFILE GROUP 1;
B. ALTER DATABASE CLEAR LOGFILE GROUP 1;
C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
D. ALTER DATABASE DROP LOGFILE MEMBER ‘D:\REDO01.LOG
第9题：
If you create your database using Oracle Managed Files （OMF）， what is true？（）
- A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures.
- B、You must define directories for two online redo log groups and three copies of the control file.
- C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically.
- D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.
正确答案:D
第10题：
Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member. When you attempt to start the database， you receive the following errors：（）
- A、 ALTER DATABASE DROP LOGFILE GROUP 1
- B、 ALTER DATABASE CLEAR LOGFILE GROUP 1
- C、 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
- D、 ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’
正确答案:C