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

第1题：

our 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

第2题：

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 optioncorresponds 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

第3题：

第4题：

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.

第5题：

You are working on a new Oracle Database 11g server， where only the software is installed and nodatabase is created. You plan to create a database on this server using the Database Configuration Assistant （DBCA）.  Some of the requirements set for your database creation task are：  1：Configure the database to operate in shared server mode.  2：Disable automatic maintenance tasks such as optimizer statistics collection.  3：Configure a naming method to help the remote user connect to the database instance.  4：Use Automatic Storage Management （ASM） for storing the database files.  5：Configure daily database backup to flash recovery area.  6：Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database（）

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

第6题：

n your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）

• A、 Oracle Migration Assistant
• B、 Recovery Manager （RMAN）
• C、 Oracle Data Pump Export and Import
• D、 conventional Oracle Export and Import
• E、 operating system utilities to copy the files to the ASM instance

第7题：

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.

第8题：

You are working on a new Oracle Database 11g server， where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant （DBCA）.Some of the requirements set for your database creation task are： 1.Configure the database to operate in shared server mode. 2.Disable automatic maintenance tasks such as optimizer statistics collection. 3.Configure a naming method to help the remote user connect to the database instance. 4.Use Automatic Storage Management （ASM） for storing the database files. 5.Configure daily database backup to flash recovery area. 6.Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database（）

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

第9题：

In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）

• A、Oracle Migration Assistant
• B、Recovery Manager （RMAN）
• C、Oracle Data Pump Export and Import
• D、conventional Oracle Export and Import
• E、operating system utilities to copy the files to the ASM instance

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