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

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

相似考题

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.You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）A、 You must use automatic undo management in the database.B、 You must configure OMF in your database.C、 You must configure ASM for storing the datafiles.D、 You must multiplex the online redo log file.

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

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

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

  • 第1题：

    You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）

    • A、 You must enable the block change tracking feature.
    • B、 You must have enable the flashback feature.
    • C、 You must use the OMF in your database.
    • D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

    正确答案:D

  • 第2题：

    You are using Oracle Database 10g. You performed an  incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？（）

    • A、This operation resets the SCN for the database.
    • B、This operation creates a new incarnation of the database.
    • C、This operation moves all the redo log files to a different location.
    • D、This operation deletes the old redo log files and creates new redo log files.
    • E、This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

    正确答案:B,E

  • 第3题：

    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

    正确答案:D

  • 第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题：

    You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）

    • A、Oracle Flashback uses undo information to construct consistent data. 
    • B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. 
    • C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. 
    • D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session. 

    正确答案:A,B

  • 第6题：

    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）

    • A、The backup status will be marked expired in RMAN recovery catalog.
    • B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
    • C、The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl
    • D、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.
    • E、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.

    正确答案:C

  • 第7题：

    单选题
    You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non/x7fASM 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
    解析： 暂无解析

  • 第8题：

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

    C

    ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE

    D

    ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING


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

  • 第9题：

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


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

  • 第10题：

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

  • 第11题：

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

  • 第12题：

    多选题
    You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）
    A

    Oracle Flashback uses undo information to construct consistent data.

    B

    You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.

    C

    You can only use Oracle Flashback view of the data if the required records are still in the online redo log files.

    D

    Oracle Flashback lists the DML that was executed during the period you identify when initiating your session.


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

  • 第13题：

    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 will you use to enable the block change tracking feature？（）

    • A、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING；
    • B、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；
    • C、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE ；
    • D、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ；

    正确答案:D

  • 第14题：

    You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）

    • A、 The log sequence is reset to 0.
    • B、 All the online redo logs are deleted.
    • C、 All the archived redo logs from a previous incarnation become useless.
    • D、 The full database backup taken from a previous incarnation can be used in future.
    • E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

    正确答案:D

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    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

  • 第18题：

    Your database is in NOARCHIVELOG mode. The database has three online redo log groups， and each group contains three online redo log members. The online redo log members are stored across three hard disks， E， F， and G， respectively. Hard disk G crashed while the LGWR background process was writing redo information to the online redo log files. What effect will this crash have on the database？（）

    • A、 The database will operate normally without generating any redo.
    • B、 The database will hang， and you must shut down and restart the instance.
    • C、 The database will crash， and you must recover the database from the point of failure.
    • D、 The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.

    正确答案:D

  • 第19题：

    单选题
    You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）
    A

     You must use automatic undo management in the database.

    B

     You must configure OMF in your database.

    C

     You must configure ASM for storing the datafiles.

    D

     You must multiplex the online redo log file.


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

  • 第20题：

    单选题
    Your database is in NOARCHIVELOG mode. The database has three online redo log groups， and each group contains three online redo log members. The online redo log members are stored across three hard disks， E， F， and G， respectively. Hard disk G crashed while the LGWR background process was writing redo information to the online redo log files. What effect will this crash have on the database？（）
    A

     The database will operate normally without generating any redo.

    B

     The database will hang， and you must shut down and restart the instance.

    C

     The database will crash， and you must recover the database from the point of failure.

    D

     The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.


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

  • 第21题：

    单选题
    You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files？（）
    A

     Oracle Enterprise Manager

    B

     The V$LOG view

    C

     The V$LOGFILE view

    D

     The V$FLASHBACK_DATABASE_LOGS view


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

  • 第22题：

    单选题
    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）
    A

    The backup status will be marked expired in RMAN recovery catalog.

    B

    The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.

    C

    The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl

    D

    The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.

    E

    The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.


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

  • 第23题：

    单选题
    You disabled the Flashback Database feature by using the following command：  SQL> ALTER DATABASE FLASHBACK OFF;  What would be the effect of this command on the existing flashback logs？（）
    A

    Flashback logs are not deleted.

    B

    Flashback logs are deleted automatically.

    C

    Flashback logs are deleted only if you are using Recovery Manager （RMAN）.

    D

    Flashback logs are deleted only if you are using Oracle Managed Files （OMF）.

    E

    Flashback logs are deleted only if you are using Automatic Storage Management （ASM）.


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

  • 第24题：

    单选题
    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
    解析： 暂无解析

相关内容