You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database12c. Your database supports a mixed workload. During the day, lots of insert, update, and deleteoperations are performed. At night, Extract, Transform, Load

第1题：

第2题：

SQ L*Loader is a utility that can perform which two tasks？（）

• A、Load data from a disk， tape， or named pipes.
• B、Load data into an Oracle database using DML statements.
• C、Extract， reorganize， and insert data within an Oracle database.
• D、Load data from external files into tables in an Oracle database.
• E、Load data into an Oracle database using operating system commands.
• F、Load data directly from a non-Oracle database to an Oracle database.

第3题：

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.

第4题：

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

第5题：

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets （STS） from the previous version. After changing the  OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer， you observed performance regression for a few SQL statements.  What would you do with these SQL statements？（）

• A、 Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.
• B、 Capture the plans from the previous version using STS and then load them into the stored outline.
• C、 Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）
• D、 Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

第6题：

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.

第7题：

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

第8题：

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

第9题：

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

第10题：

第11题：

第12题：

第13题：

You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? （）

• A、Clone 
• B、Copy 
• C、Template 
• D、Terminal 

第14题：

You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the 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 the SQL*Loader utility.
• D、Use the INSERT INTO...SELECT command to load the data

第15题：

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

第16题：

You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database12c. Your database supports a mixed workload. During the day, lots of insert, update, and deleteoperations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause ofperformance degradation, you want to collect basic statistics such as the level of parallelism, totaldatabase time, and the number of I/O requests for the ETL jobs. How do you accomplish this?（）

• A、Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.
• B、Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.
• C、Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.
• D、Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.

第17题：

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

第18题：

You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the 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 the SQL*Loader utility.
• D、Use the INSERT INTO...SELECT command to load the data.

第19题：

You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.  You want the RMAN to import metadata for database IDs 1423241 and 1423242， registered in RCAT10， into the recovery catalog owned by RCO11. You executed the following commands： RMAN> CONNECT CATALOG rco11/password@catdb  RMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER；   Which two statements are true regarding the tasks accomplished with these commands？（）

• A、 They import all metadata from the RCAT10 catalog.
• B、 They unregister the database from the RCAT10 catalog.
• C、 They do not register the databases registered in the RCAT10 catalog.
• D、 They register all databases registered in the RCAT10 catalog.

第20题：

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

第21题：

第22题：

第23题：

第24题：