CMS专题
单选题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
题目
You must use Oracle predefined names to identify raw partitions that will hold OMF structures.
You must define directories for two online redo log groups and three copies of the control file.
If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically.
You must use only OMF data files when adding new tablespaces or data files to your database in the future.
相似问题和答案
第1题：
You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.You plan to create the database using SQL statements.Which three techniques can you use to achieve this?（）
A. Use Oracle Managed Files (OMF).
B. Specify the SEED FILE_NAME_CONVERT clause.
C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.
D. Specify the DB_FILE_NAMECONVERT initialization parameter.
E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).
第2题：
The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility. What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）
- A、 The block change tracking feature must be enabled.
- B、 OMF must be configured on your database.
- C、 The database must be in ARCHIVELOG mode.
- D、 A USERID must be supplied.
正确答案:D
第3题：
You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）
A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
第4题：
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
第5题：
While planning to manage more than one database in your system， you perform the following activities： 1. Organize different categories of files into independent subdirectories. 2. Use consistent naming convention for database files. 3. Separate administrative information pertaining to each database. Which option corresponds to the type of activities performed by you？（）
- A、Oracle Managed Files
- B、Oracle Grid Architecture
- C、Optimal Flexible Architecture
- D、Oracle database architecture
正确答案:C
第6题：
You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry： ASM_DISKSTRING = /devices/* What could be the reason for this setting？（）
- A、to enable the ASM instance to identify the alert log file
- B、to enable the ASM instance to identify the server parameter file
- C、to enable the ASM instance to define the locations for Oracle Managed Files （OMF）
- D、to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory
正确答案:B
第7题：
You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）
- A、The Oracle kernel will be placed in this location.
- B、The Oracle software will be placed in this location.
- C、The server parameter file （SPFILE） will be placed in this location.
- D、The database files will be placed in this location， if not specified explicitly.
- E、The location will be considered for the base of Oracle Managed Files （OMF）.
- F、The location will be considered for the base of Optimal Flexible Architecture （OFA）.
正确答案:F
第8题：
You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?（）
A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.
B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.
C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.
D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
第9题：
You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）
- A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files.
- B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files.
- C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option.
- D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template.
- E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.
正确答案:D
第10题：
You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）
- A、Start the instance and open the database， instance recovery automatically recoverscontrol files
- B、Create a file based on the contents of the trace file and save it to the control file locations and start the database
- C、Re-create the database （The recovery of the control file is not possible because you have lost all the control files.）
- D、Start the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
- E、Start the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
正确答案:D