多选题What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?（）AEffectively implements role separationBEnables you to take advantage of Oracle Managed Files.CAutomatically r

第1题：

You work as a database administrator for Supportcenter.cn. 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

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

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

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

第5题：

You plan to use static database registration for a new listener when you create it. What could be the two reasons for this？（）

• A、More than one database is to be registered with the listener.
• B、The users will connect the database by using the host naming method.
• C、The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.
• D、The database that is to be registered with the listener is configured in shared server mode.
• E、The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

第6题：

Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）

• A、When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.
• B、When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
• C、When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
• D、When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

第7题：

You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）

• A、 by using the Flashback Database feature
• B、 by using RMAN incomplete recovery
• C、 by performing a user-managed incomplete recovery
• D、 by dropping and re-creating the index tablespace

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Integration between （） multidata sources and （） is defined as the Grid Link for RAC.

• A、Oracle WebLogic Server; Oracle Database
• B、Oracle WebLogic Server clusters; Oracle Database
• C、Oracle WebLogic Server clusters; Oracle Database RAC
• D、Oracle OC4J; Oracle Database RAC
• E、Oracle WebLogic Server; Oracle OC4J

第14题：

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

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

第16题：

Which two statements are true regarding hot patching？（）

• A、 It requires relinking of the Oracle binary.
• B、 It does not require database instance shutdown.
• C、 It can detect conflicts between two online patches.
• D、 It is available for installing all patches on all platforms. 
• E、 It works only in a single database instance environment.

第17题：

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.

第18题：

What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?（）

• A、Effectively implements role separation
• B、Enables you to take advantage of Oracle Managed Files.
• C、Automatically registers the database with Oracle Restart.
• D、Helps you to easily upgrade the database from a prior release.
• E、Enables the Installation of Grid Infrastructure files on block or raw devices.

第19题：

You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer （OUI） prompts you to enter the path of the inventory directory and also prompts you to specify an operating systemgroup name.  Which statement is true in this case（）

• A、The ORACLE_BASE parameter is not set.
• B、The installation is being performed by the root user.
• C、The operating system group that will be specified should have root user as its member.
• D、The installation is being performed without the "Create Starter Database" option selected.
• E、The operating system group that will be specified must have permission to write to the inventory directory

第20题：

第21题：

第22题：

第23题：

第24题：