有一段时间，满街的女人都穿着一种高帮粗跟的皮鞋，但这鞋不美是男人们的共识，没过多久，这种皮鞋越

A. The database must be running in ARCHIVELOG mode.

B. No special setup is required, and the feature is enabled by default.

C. The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.

D. The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.

E. Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.

base. As a part of the upgrade process, you execute the following script:SQL>@utlu111i.sqlWhich 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.

A. ORACLE_BASE should be set explicitly.

B. An Oracle base should have only one Oracle home created in it.

C. Flash recovery area and data file location should be on separate disks.

D. Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.

atabase. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands？（）

A. They execute and create a virtual catalog for pre-Oracle 11g clients.

B. They produce an error because PROD1 and PROD2 databases belong to the older version.

C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.

D. They produce an error because you need to connect to the target database to execute this packaged procedure.

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.

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

A. The source database backup must be copied over the net for test database.

B. The source database must be run in ARCHIVELOG mode if the database is open.

C. The source database must be shut down cleanly if the database is in mounted state.

D. A net service name should be set up and a listener configured with the target as well as the source database.

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

base (CDB).The characteristics of the non-CDB are as follows:-Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit -Character set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bitThe characteristics of the CDB are as follows:-Version: Oracle Database 12c Release 1 64-bit -Character Set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bitWhich technique should you use to minimize down time while plugging this non-CDB into the CDB？（）

A. Transportable database

B. Transportable tablespace

C. Data Pump full export/import

D. The DBMS_PDB package

E. RMAN