Identify two types of files that are generated by the Pre-Upgrade Information tool as part of the database upgrade prerequisite checks? (Choose two.)

A. expdp scripts to export database objects belonging to the SYS schema

B. a log file containing a list of pre-upgrade patches to be applied

C. RMAN database backup scripts

D. a log file with tool recommendations and requirements

E. pre- and post-upgrade fixup scripts

In your database, DEFERRED_SEGMENT_CREATION is set to TRUE. You successfully execute this command:

Which statement is true about the space allocated to the SALES_2016 table?

A. Two subpartitions are allocated to the q1_2016 partition when the first row is inserted into q1_2016.

B. A single subpartition is allocated to the q1_2016 partition when the first row is inserted into q1_2016.

C. Separate segments are allocated to the q1_2016 partition and each of its subpartitions when the first row is inserted into q1_2016.

D. A segment is allocated to the q1_2016 partition but not its subpartitions at table creation.

E. A single segment is allocated to the q1_2016 partition and its subpartitions at table creation.

Which two statements are true about a PDB lockdown profile? (Choose two.)

A. It is created by a local user with the SYSDBA privilege in each PDB where it needs to be applied.

B. It is created by a common user with the SYSDBA privilege in CDB$ROOT.

C. It is created by a common user with the SYSDBA privilege in each PDB where it needs to be applied.

D. It is enabled by default on creation.

E. It is enabled by using the PDB_LOCKDOWN parameter in each PDBs where it needs to be applied.

F. It is enabled in PDBs only after the CDB to which the PDBs belong is restarted.

In your CDB1 container database, the DB_CREATE_FILE_DEST parameter is set to `/u01/app/oracle/

oradata'.

CDB1 has an application container called REGIONS_APP.

There are no seeds for REGIONS_APP and there are no other application containers.

You plan to execute this command.

CREATE PLUGGABLE DATABASE AS SEED ADMIN USER seed_adm IDENTIFIED BY admin_123;

What must you do for the command to execute successfully?

A. Set the current container to REGIONS_APP

B. Set the current container to CDB1

C. Add the FILE_NAME_CONVERT clause to the command

D. Add the CREATE_FILE_DEST clause to the command

E. Set the PDB_FILE_NAME_CONVERT parameter to `/u01/app/oracle/oradata'

In which three situations would you recommend DB Replay to be used? (Choose three.)

A. to check the impact of schema changes such as adding new indexes or materialized views

B. to check the impact of database migration to the cloud

C. to check the impact of changing the storage system or the network

D. to check the impact of partitioning a table

E. to check the impact of new optimizer statistics

F. to check the impact of upgrading and patching databases

U1.T1 is in a tablespace TBS_UNCMP which has no default compression and U1.T2 is in a tablespace,

TBS_CMP with default compression for query low.

You execute commands:

Which three statements are true? (Choose three.)

A. The primary key constraints on T1 are dropped

B. T1 is in the TBS_UNCMP tablespace

C. T1 is in the TBS_CMP tablespace

D. T1 is in compressed format

E. T1 is in uncompressed format

F. All indexes on T1 remain valid

In your CDB, DEPTCDB, local undo is enabled. You successfully execute this command: FLASHBACK PLUGGABLE DATABASE hrpdb to SCN 424366;

Which action must you perform next?

A. Open HRPDB

B. Take a backup of DEPTCDB

C. Take a backup of HRPDB

D. Open HRPDB with RESETLOGS

E. Open DEPTCDB with RESETLOGS

F. Open DEPTPDB

Your CDB is in ARCHIVELOG mode and has an application container with a container PDB. A backup

exists for the CDB. When you connect to the container PDB and try to execute a query, you get an error

that a SYSTEM data file is missing in the container PDB. You want to use the RMAN RESTORE

DATABASE and RECOVER DATABASE commands to perform the recovery.

Examine these actions:

Connect to CDB$ROOT and execute SHUTDOWN ABORT and STARTUP MOUNT.

Connect to the application container and execute SHUTDOWN ABORT.

Connect to the application container and execute ALTER PLUGGABLE DATABASE CLOSE ABORT.

Which option correctly lists the actions that you must execute before performing the recovery?

A. 1 and 3

B. 1 and 2

C. only 2 D. only 3

A multi-tenant container database (CDB) contains three PDBs.

Which three are prerequisites for performing a cross-platform transport of any of the PDBs? (Choose three.)

A. The CDB should be in MOUNT state.

B. The source and target platforms must have the same endianness.

C. The COMPATIBLE parameter must be set to 12.2 or greater in the CDB.

D. The source PDBs must be closed for a cross-platform PDB backup.

E. Flashback database must be enabled for the CDB.

F. The CDB must use Automatic Memory Management.

Which three statements are true about the SQL Performance Analyzer? (Choose three.)

A. It recommends the use of SQL Tuning Advisor for regressed SQL statements.

B. It recommends the creation of indexes for regressed SQL statements.

C. It compares and analyzes execution plans for the SQL statements in a SQL Tuning Set (STS).

D. It always executes triggers that are fired recursively in FULLDML mode.

E. It generates execution plans for each SQL statement in an STS.