You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose datab

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

第3题：

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.

第4题：

You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema.   Which process writes the before images of the physical database blocks to the flashback database logs？（）

• A、 LGWR
• B、 DBWR
• C、 MMON
• D、 RVWR

第5题：

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

第6题：

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

第7题：

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

第8题：

Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）

• A、 V$DATABASE
• B、 V$UNDOSTAT
• C、 V$FLASHBACK_DATABASE_LOG
• D、 V$FLASHBACK_DATABASE_STAT

第9题：

第10题：

第11题：

第12题：

第13题：

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

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

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.

第16题：

The operating system filecratabin the Linux platform gets updated whenever you create a new database on the same host machine.  What kind of information is stored is stored in this file？（）

• A、OracleSIDsonly
• B、Oracle homes only
• C、Oracle install timestamp
• D、Oracle inventory pointer files
• E、Oracle database creation timestamp
• F、OracleSIDsand Oracle homes only
• G、OracleSIDs， Oracle homes and flag for auto startup

第17题：

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

第18题：

Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

• A、The database is in mount state.
• B、One of the tablespaces is offline.
• C、One of the tablespaces is read only.
• D、The database operates in ARCHIEVELOG mode.
• E、The database operates in NOARCHIEVELOG mode.

第19题：

You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）

• A、to minimize plan regression due to the use of a new optimizer version
• B、to completely avoid the use of new plans generated by a new optimizer version
• C、to prevent plan capturing when the SQL statement is executed after the database upgrade
• D、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used

第20题：

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

第21题：

第22题：

第23题：