A. It fails because connection to the AUXILIARY instance must be as SYSDBA.

B. Itsucceeds only if the target database is greater than 400M.

C. It fails because no parallel channels are allocated for the auxiliary database.

D. It succeeds.

E. No catalogued backup of the TARGET is used to duplicate the database.

A. It replaces secure application roles.

B. It encrypts only data on the client.

C. Master encryption keys are managed by Oracle Database Vault.

D. It uses a single master key for a database.

E. It stores the current and all past master keys in the keystore.

F. It can encrypt data at the column level.

A. defining foreign keys for all tables to speed up joins

B. using check constraints to speed up updates

C. the physical data model

D. defining primary keys for all tables to speed up all queries

E. the configuration of storage arrays

A. The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

B. SPFILE backups can be created while connected to an application root PDB.

C. The BACKUP DATABASE PLUS ARCHIVELOG command will back up archive logs when RMAN is connected to a PDB.

D. The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.

E. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.

A. They contain a PDB manifest file and all the data files in compressed form for a PDB.

B. They contain a PDB manifest file and all the data files in uncompressed form for a PDB.

C. They contain all the data files only in uncompressed form for a PDB.

D. DBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive.

E. They contain all the data files only in compressed form for a PDB.

F. They must be created using the DBMS_PDB package.

A. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots

B. by using Active Session History (ASH) data and performing hang analysis

C. by running ADDM in diagnostic mode

D. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis

A. Space is always reclaimed automatically when the retention period for Flashback logs is lowered.

B. Space might be reclaimed automatically when the retention period for Flashback logs is lowered.

C. Space might be reclaimed proactively before space pressure occurs.

D. Space is only reclaimed when there is space pressure in the Fast Recovery Area. (FRA)

E. Space is always reclaimed proactively before space pressure occurs.

A. They can only be written to disk.

B. They can be used as a level 0 incremental backup.

C. They can be used as a level 1 incremental backup.

D. They are the only backup option available for databases in NOARCHIVELOG mode.

E. They can be encrypted using Transparent Data Encryption (TDE).

A. user-defined PL/SQL packages

B. redo logs

C. all data dictionary metadata

D. undo tablespaces

E. control files

F. mandatory Oracle-supplied PL/SQL packages

G. temporary tablespaces

A. Decreasing PCTFREE

B. Using Automatic Segment Space Management (ASSM)

C. Decreasing PCTUSED

D. Increasing the number of DBWN process

E. Increasing db_buffer_cache based on t he V$DB_CACHE_ADVICE recommendation