违法和不良信息举报 联系客服
免费注册 登录

多选题Which two statements are true about Oracle Managed Files (OMF)?（）AOMF cannot be used in a database that already has data files created with user-specified directions.BThe file system directions that are specified by OMF parameters are created automatic

题目
多选题
Which two statements are true about Oracle Managed Files (OMF)?（）
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.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Which two statements correctly describe the relation between a data file and the logical databasestructures（）

  • A、An extent cannot spread across data files.
  • B、A segment cannot spread across data files.
  • C、A data file can belong to only one tablespace.
  • D、A data file can have only one segment created in it.
  • E、A data block can spread across multiple data files as it can consist of multiple operating system （OS） blocks.

正确答案:A,C

第2题：

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

第3题：

Which two statements are true about Oracle Managed Files (OMF)?()

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.


参考答案：B, D

第4题：

Which two statements about Automatic Storage Management （ASM） are true？（）

  • A、ASM provides mirroring on file by file basis.
  • B、ASM provides automatic load balancing across all ASM disks.
  • C、ASM supports the Oracle database and operating system files.
  • D、ASM can be used to store trace files， alert log files， and the server parameter file （SPFILE）.

正确答案:A,B

第5题：

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).

正确答案:A,B,C

第6题：

To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?（）

  • A、Multiple change tracking files can be created for a database.
  • B、The change tracking file must be created after the first level 0 backup.
  • C、RMAN does not support backup and recovery of the change tracking file.
  • D、The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

正确答案:C,D

第7题：

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

第8题：

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).


参考答案：A, B, C

第9题：

You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？ （）

  • A、 RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
  • B、 RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF
  • C、 RMAN would relocate all the database files to an ASM disk group.
  • D、 RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.

正确答案:C

第10题：

You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager（RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？（）

  • A、RMAN would relocate all the database files to an ASM disk group.
  • B、RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.
  • C、RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
  • D、RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF

正确答案:A

更多相关问题
相关内容