The source and target platforms must be the same
Redo logs, control files and temp files are also transported
The transported database must have the same database identifier (DBID) as the source database and cannot be changed
The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format
单选题 You executed the following PL/SQL block successfully: The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis.（）
with the CPU Usage finding if it is less than 90
without the CPU Usage finding if it is less than 90
with the CPU Usage finding for snapshots below 90
with the CPU Usage finding for snapshots not between 150 and 162
单选题 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? （）
to minimize plan regression due to the use of a new optimizer version
to completely avoid the use of new plans generated by a new optimizer version
to prevent plan capturing when the SQL statement is executed after the database upgrade
to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
多选题 Which two initialization parameters would you set to enable Automatic Shared Memory Management?（）
set SHARED_POOL_SIZE to zero
set STATISTICS_LEVEL to BASIC
set SGA_TARGET to a non-zero value
set DB_CACHE_SIZE to a non-zero value
set STATISTICS_LEVEL to TYPICAL or ALL
Only one window can be open at any given time
Consumer groups are associated with windows
Windows work with job classes to control resource allocation
The database service name must be provided during windows creation
Windows can automatically start job or change resource allocation among jobs for various time periods.
单选题 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?（）
It must be executed from the Oracle Database 11g environment.
It must be executed only after the SYSAUX tablespace has been created.
It must be executed from the environment of the database that is being upgraded.
It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
The data file is checked for physical corruption and backed up if found clean.
The backup of data file 5 is performed and the interactive messages during the backup are suppressed.
The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.
The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
Resource consumer group
Building the SQL profile
Recommending optimization of materialized views
Checking query objects for missing and stale statistics
Recommending bitmap, function-based, and B-tree indexes
Recommending restructuring SQL queries that are using bad plans
单选题 While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）
It updates the existing SQL profiles with current statistics
It makes the statistics information available to GATHER_STATS_JOB
It initiates the statistics collection process by running GATHER_STATS_JOB
It logs a warning message in the alert log so that the DBA can perform statistics collection manually