多选题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 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.

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

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

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

更多“多选题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”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

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

    • 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

  • 第5题：

    Which two statements about the background process of the database writer are true（）

    • A、It is possible to have multiple database writers in an Oracle instance.
    • B、It writes dirty buffers， if any， to data files whenever a checkpoint occurs.
    • C、It writes dirty buffers， if any， to data files whenever a transaction commits.
    • D、It writes dirty buffers， if any， to data files before the log writer （LGWR） writes

    正确答案:A,B

  • 第6题：

    Which two statements are correct about database transportation? （）

    • A、The source and target platforms must be the same
    • B、Redo logs, control files and temp files are also transported
    • C、The transported database must have the same database identifier (DBID) as the source database and cannot be changed
    • D、The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
    • E、Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

    正确答案:D,E

  • 第7题：

    多选题
    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）.


    正确答案： D,C
    解析： 暂无解析

  • 第8题：

    多选题
    Which two statements about the background process of the database writer are true（）
    A

    It is possible to have multiple database writers in an Oracle instance.

    B

    It writes dirty buffers， if any， to data files whenever a checkpoint occurs.

    C

    It writes dirty buffers， if any， to data files whenever a transaction commits.

    D

    It writes dirty buffers， if any， to data files before the log writer （LGWR） writes


    正确答案： A,D
    解析： 暂无解析

  • 第9题：

    多选题
    Which two statements are true about checkpointing（）
    A

    The checkpoint frequency decreases with the smaller redo log file size.

    B

    It ensures that all committed data is written to the data files during normal shutdown.

    C

    The frequent full checkpoint in a database can cause the overall degradation of the database performance.

    D

    It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.


    正确答案： B,D
    解析： 暂无解析

  • 第10题：

    单选题
    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）.


    正确答案： E
    解析： 暂无解析

  • 第11题：

    多选题
    To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file? （）(Choose two.)
    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.


    正确答案： A,B
    解析： 暂无解析

  • 第12题：

    多选题
    Which two statements correctly describe the relation between a data file and the logical database structures（）
    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


    正确答案： B,C
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）

    • A、 One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.
    • B、 One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.
    • C、 One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.
    • D、 One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.

    正确答案:C

  • 第17题：

    View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）

    • A、The tablespace has two data files.
    • B、An error is reported and tablespace creation fails.
    • C、Data files are created with names generated by the instance.
    • D、The tablespace can be extended without specifying the data file.
    • E、Data files belonging to the USERS tablespace cannot be renamed.

    正确答案:C,D

  • 第18题：

    多选题
    Which two statements are correct about database transportation? （）
    A

    The source and target platforms must be the same

    B

    Redo logs, control files and temp files are also transported

    C

    The transported database must have the same database identifier (DBID) as the source database and cannot be changed

    D

    The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported

    E

    Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format


    正确答案： C,A
    解析： 暂无解析

  • 第19题：

    多选题
    Which two statements are correct about database transportation?（） (Choose two.)
    A

    The source and target platforms must be the same

    B

    Redo logs, control files and temp files are also transported

    C

    The transported database must have the same database identifier (DBID) as the source database and cannot be changed

    D

    The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported

    E

    Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format


    正确答案： A,D
    解析： 暂无解析

  • 第20题：

    多选题
    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.


    正确答案： D,E
    解析： 暂无解析

  • 第21题：

    多选题
    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).


    正确答案： C,D
    解析： 暂无解析

  • 第22题：

    多选题
    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,A
    解析： 暂无解析

  • 第23题：

    多选题
    View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）
    A

    The tablespace has two data files.

    B

    An error is reported and tablespace creation fails.

    C

    Data files are created with names generated by the instance.

    D

    The tablespace can be extended without specifying the data file.

    E

    Data files belonging to the USERS tablespace cannot be renamed.


    正确答案： B,D
    解析： 暂无解析

  • 第24题：

    多选题
    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.


    正确答案： D,C
    解析： 暂无解析

相关内容