You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that

题目

You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）

  • A、The ASM compatibility attribute controls the format of the disk group metadata.
  • B、RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
  • C、The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
  • D、The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.
  • E、The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.
相似考题

1.Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()A. Oracle Net ManagerB. Listener Control utilityC. Database Configuration AssistantD. Oracle Net Configuration Assistant

2.Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?()A. By default, EM express is available for a database after database creation.B. You can use EM express to manage multiple databases running on the same server.C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.D. You cannot start up or shut down a database Instance by using EM express.E. You can create and configure pluggable databases by using EM express.

3.You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.Which method or feature should you use?()A. Compare Period ADDM reportB. AWR Compare Period reportC. Active Session History (ASH) reportD. Taking a new snapshot and comparing it with a preserved snapshot

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

参考答案和解析
正确答案:A,B,D
更多“You support Oracle Database 12c”相关问题

  • 第1题：

    You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.Which three storage options support the use of HCC?（）

    A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.

    B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array

    C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files

    D. Database files stored in ZFS and accessed using conventional NFS mounts.

    E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature

    F. Database files stored in any file system and accessed using the Oracle Direct NFS feature

    G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays


    参考答案：A, E, G

  • 第2题：

    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

  • 第3题：

    As soon as you discover that you have lost an online redo log， if the database is still functioning， what should be your first action？（）  

    • A、 Shut down the database
    • B、 Clear the online redo log
    • C、 Back up the database
    • D、 Checkpoint the database
    • E、 Call Oracle support

    正确答案:D

  • 第4题：

    You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage options support the use of HCC?（）

    • A、ASM disk groups with ASM disks consisting of Exadata Grid Disks.
    • B、ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
    • C、ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
    • D、Database files stored in ZFS and accessed using conventional NFS mounts.
    • E、Database files stored in ZFS and accessed using the Oracle Direct NFS feature
    • F、Database files stored in any file system and accessed using the Oracle Direct NFS feature
    • G、ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

    正确答案:A,E,G

  • 第5题：

    You plan to configure the new Oracle Database 11g installation by performing these tasks： - Use Automatic Storage Management （ASM） as the storage option.  - Use Oracle Enterprise Manager Database Control to manage the database.  - Provide the same password for SYS， SYSTEM， SYSMAN， and DBSNMP accounts during theinstallation. - Configure the database to send email notifications.  Some tools available to you for installation are：  1：Oracle Universal Installer （OUI）  2：Database Configuration Assistant （DBCA）  3：Database Upgrade Assistant （DBUA）  4：Oracle Net Configuration Assistant  Which tools would you use for this installation（）

    • A、2
    • B、3
    • C、1 and 2
    • D、3 and 4
    • E、1，2，and 4

    正确答案:E

  • 第6题：

    In a new installation of Oracle Database 11g， you perform these activities：  1：Organize software and data on different subdirectories to avoid poor performance.  2：Use consistent naming conventions for database files.  3：Separate administrative information pertaining to the database in different directories.  Which option corresponds to the type of activities you performed（）

    • A、Oracle Managed Files
    • B、Oracle Grid Architecture
    • C、Optimal Flexible Architecture
    • D、Oracle database architecture
    • E、Automatic Storage Management

    正确答案:C

  • 第7题：

    单选题
    You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）
    A

    SYSTEM 

    B

    OUTLN 

    C

    INTERNAL 

    D

    SYS


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

  • 第8题：

    单选题
    Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（）
    A

     Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.

    B

     Oracle will automatically take the datafile out of hot backup mode and then open the database.

    C

     Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.

    D

     The database will open with the file in hot backup mode. You can restart the backup at any time.

    E

     The datafile in hot backup mode will be corrupted and you will have to recover it.


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

  • 第9题：

    单选题
    Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.  Which tool or utility would you use to start the listener？（）
    A

     Oracle Net Manager

    B

     Listener Control utility

    C

     Database Configuration Assistant

    D

     Oracle Net Configuration Assistant


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

  • 第10题：

    多选题
    You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）
    A

    The ASM compatibility attribute controls the format of the disk group metadata.

    B

    RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.

    C

    The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.

    D

    The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.

    E

    The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.


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

  • 第11题：

    单选题
    You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 12c Releases 1 64-bit -Character set: WE8ISO8859P15 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Character set: AL32UTF8 -O/S: Oracle Linux 6 64-bit Which technique should you use to minimize down time while plugging this non-CDB into the CDB?（）
    A

    Transportable database

    B

    Transportable tablespace

    C

    Data Pump full export / import

    D

    The DBMS_PDB package

    E

    RMAN


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

  • 第12题：

    单选题
    As soon as you discover that you have lost an online redo log， if the database is still functioning， what should be your first action？（）
    A

     Shut down the database

    B

     Clear the online redo log

    C

     Back up the database

    D

     Checkpoint the database

    E

     Call Oracle support


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

  • 第13题：

    You work as a database administrator for Certkiller .com. You want to administer your database servers，which are running on different host machines，using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）

    • A、Application Server Control
    • B、Oracle Management Service
    • C、Oracle Enterprise Manager Repository
    • D、Oracle Enterprise Manager Database Control

    正确答案:C,D

  • 第14题：

    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

  • 第15题：

    In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）

    • A、the V$LOG view
    • B、the V$DBFILE view
    • C、the V$LOGFILE view
    • D、the V$INSTANCE_RECOVERY view
    • E、Oracle Enterprise Manager Database Control

    正确答案:D,E

  • 第16题：

    When you create a backup control file， where is the resulting file written to？（）  

    • A、 The database user dump destination directory
    • B、 The database diagnostic destination directory
    • C、 To $ORACLE_HOME/rdbms
    • D、 To $ORACLE_HOME/admin
    • E、 To the directory and filename you specify in the command

    正确答案:E

  • 第17题：

    Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.  Which tool or utility would you use to start the listener？（）

    • A、 Oracle Net Manager
    • B、 Listener Control utility
    • C、 Database Configuration Assistant
    • D、 Oracle Net Configuration Assistant

    正确答案:B

  • 第18题：

    Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g？（） 

    • A、 Generate reports on data failure such as data file failures.
    • B、 You can track the Service Request （SR） and implement repairs.
    • C、 You can package and upload diagnostic data to Oracle Support.
    • D、 You can manually run health checks to gather diagnostic data for a problem.

    正确答案:B,C,D

  • 第19题：

    单选题
    You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）
    A

    Compare Period ADDM report

    B

    AWR Compare Period report

    C

    Active Session History (ASH) report

    D

    Taking a new snapshot and comparing it with a preserved snapshot


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

  • 第20题：

    多选题
    You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage options support the use of HCC?（）
    A

    ASM disk groups with ASM disks consisting of Exadata Grid Disks.

    B

    ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array

    C

    ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files

    D

    Database files stored in ZFS and accessed using conventional NFS mounts.

    E

    Database files stored in ZFS and accessed using the Oracle Direct NFS feature

    F

    Database files stored in any file system and accessed using the Oracle Direct NFS feature

    G

    ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays


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

  • 第21题：

    单选题
    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：   RMAN> CONNECT TARGET sys/sys@APPPROD RMAN> CONNECT AUXILIARY sys/sys@DUPDB RMAN> DUPLICATE TARGET DATABASE TO dupdb  FROM ACTIVE DATABASE PASSWORD FILE SPILE  NOFILENAMECHECK；   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.


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

  • 第22题：

    单选题
    You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）
    A

    When the instance is started 

    B

    When the database is mounted 

    C

    When the database is opened 

    D

    When the database is closed


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

  • 第23题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）
    A

    use the external table population

    B

    use the Oracle Data Pump export and import utility

    C

    use the conventional path data load of SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


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

相关内容