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

第1题：

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?（）

• A、It must be executed from the Oracle Database 11g environment.
• B、It must be executed only after the SYSAUX tablespace has been created.
• C、It must be executed from the environment of the database that is being upgraded.
• D、It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
• E、It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

第2题：

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.

第3题：

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

第4题：

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.

第5题：

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.

第6题：

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

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set.   How will you migrate your database from UTF8 to AL16UTF16？（）  

• A、 by using the RMAN utility
• B、 by using the export/import utility
• C、 by using the ALTER DATABASE command
• D、 by enabling the change tracking feature

第14题：

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.

第15题：

While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）

• A、configure the database to run in ARCHIVELOG mode
• B、configure the Flash Recovery Area to enable automatic database backup
• C、schedule the database backup using DBMS_JOB package after creating the database
• D、schedule the database backup using Recovery Manager （RMAN）commands after creating the database
• E、schedule the database backup using Database Configuration Assistant （DBCA）while creating the database

第16题：

You are working as a Database Administrator. Despite having a password in the data dictionary as change_on_install， you always log on to the database MYNEWDB using operating system authentication. Your organization is planning to recruit two junior-level DBAs. You decide to enable remote authentication in your database so that the new DBAs can log on to the database from their workstations to carry out administrative tasks.   To allow the new DBAs to perform the administrative tasks， you create a password file on the database server using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4   After creating the password file， you remove the operating system authentication and change the value of the  REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE. You also create a net service name as MYNEWDB that allows the new DBAs to connect to the database server from their workstations using this net service name. Which command must you use to connect to the database to start it？（）  

• A、 CONNECT / AS SYSDBA
• B、 CONNECT sys/admin AS SYSDBA
• C、 CONNECT sys/admin@mynewdb AS SYSDBA
• D、 CONNECT sys/change_on_install AS SYSDBA

第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

第18题：

You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（） 

• A、Create the database by using a single data file and a single log file.
• B、Create the database by using a single data file and multiple log files.
• C、Create the database by using a single log file and multiple filegroups.
• D、Create the database by using a single log file and a filegroup that has multiple data files.

第19题：

第20题：

第21题：

第22题：

第23题：