1Z0-063 Online Practice Questions and Answers

Which two statements are true about making RMAN image copies of a database? (Choose two.)

A. They can only be written to disk.

B. They can be made only when the database is running in NOARCHIVELOG mode.

C. They can be made only when the database is in MOUNT state.

D. They consist of all used and unused blocks in the data files.

E. They can be made only when the database is running in ARCHIVELOG mode.

The CATDB12C database contains an Oracle Database 12c catalog schema owned by the RC12C user. The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user.

A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open.

In the CATDB12c database, you execute the commands:

What is the outcome of the import?

A. It fails because the target database and recovery catalog database are of different versions.

B. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed.

C. It succeeds but the database is not automatically registered in the RC12c catalog.

D. It fails because RMAN is not connected to the target database with DBID=1423241.

You create a new database by using the CREATE DATABASE command in SQL *Plus, with the ENABLE PLUGGABLE DATABASE clause specified.

Which statement is true about the database that is created?

A. It is created as a container database (CDB) with CDB$ROOT, PDB$SEED, and a pluggable database (PDB).

B. It is created as a non-CDB that becomes a CDB after the first PDB is plugged in.

C. It is created as a PDB that must be plugged into an existing CDB.

D. It is created as a CDB with the CDB$ROOT and PDB$SEED databases.

You are administering a multitenant container database (CDB) that has no startup triggers and contains three pluggable databases (PDBs).

You execute the command to start up the CDB: SQL> STARTUP

Which statement is true?

A. CDB$ROOT, PDB$SEED, and the PDBs are opened in read-only mode.

B. CDB$ROOT and PDB$SEED are opened in read-only mode, but the PDBs are in closed mode.

C. CDB$ROOT is opened in read/write mode, but PDB$SEED and the PDBs are in closed mode.

D. CDB$ROOT is opened in read/write mode, PDB$SEED in read-only mode, and the PDBs in MOUNT state.

E. CDB$ROOT, PDB$SEED, and the PDBs are opened in read/write mode.

Which two statements are true about RMAN duplexed backups? (Choose two.)

A. It is only supported for backups to tape via the media management interface.

B. It is not supported for image copies.

C. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.

D. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.

E. Duplex backups can contain only data files and control files.

One of your databases is in ARRCHIVELOG mode.

You back up the database by using RMAN with a recovery catalog.

One data file and all the control files are corrupt due to corruption in the storage array.

Examine this list of possible actions to recover the database:

1.

Restore the control files by using the RESTORE CONTROLFILE command.

2.

Mount the database.

3.

Restore the data files by using the RESTORE DATABASE command.

4.

Open the database with the RESETLOGS option.

5.

Recover the data files by using the RECOVER USING BACKUP CONTROLFILE command.

6.

Start the target database instance in NOMOUNT state.

7.

Connect to the target database and the recovery catalog database instance.

8.

Restore the SPFILE by using the RESTORE SPFILE command

9.

Restore the corrupt data file.

10.

Recover the restored data file.

Identify the minimum required steps in the correct order.

A. 7, 6, 1, 8, 2, 3, 5, 4

B. 7, 6, 1, 2, 3, 5, 4

C. 7, 2, 1, 3, 5, 4

D. 7, 6, 1, 2, 9, 10, 4

E. 7, 6, 1, 2, 3, 10, 4

Which two are benefits of unified auditing in full mode? (Choose two.)

A. The audit trail is in a single format.

B. All audit data is written to both the traditional locations and to the unified location.

C. The audit trail is read-only.

D. Pre 12c audit data is written to the traditional locations and new 12c audit data is written to the unified location.

E. The audit trail uses less space.

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your

database server that is running on Oracle Linux.

You have set the db_smart_flash_file parameter:

DB_FLASH_CACHE_FILE= ` /dev/f lash_device_1`,` /dev/f lash_device_2`

How should the D3_flash_cache_size be configured to use both devices?

A. Set DB_FLASH_CACHE_SIZE=64G.

B. Set D3_FLASH_CACHE_SIZE=64G, 64G.

C. Set D3_FLASK_CACKE_SI2E=128G.

D. db_flash_cache_SI2E is automatically configured by the instance at startup.

Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted.

Examine the steps to recover the online redo log group and move it to a new location.

1.

Restore the corrupted redo log group.

2.

Restore the database from the most recent database backup.

3.

Perform an incomplete recovery.

4.

Relocate the member of the damaged online redo log group to a new location.

5.

Open the database with the resetlogs option.

6.

Issue a checkpoint and clear the log.

Identify the required steps in the correct order.

A. 1, 3, 4, 5

B. 6, 3, 4, 5

C. 2, 3, 4, 5

D. 6, 4, 3, 5

You want to move your existing recovery catalog to another database.

Examine the steps:

1) Export the catalog data by using the Data Pump Export utility in the source database.

2) Create a recovery catalog user and grant the necessary privileges in the target database.

3) Create a recovery catalog by using the CREATE CATALOG command.

4) Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target

database.

5) Import the source recovery catalog schema by using the RMAN IMPORT CATALOG command.

6) Connect to the destination database.

7) Connect as CATALOG to the destination recovery catalog schema.

Identify the option with the correct sequence for moving the recovery catalog.

A. 1, 6, 4

B. 2, 3, 7, 5

C. 1, 2, 6, 4

D. 1, 2, 3, 6, 5

You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.

Which three storage options support the use of HCC? (Choose three.)

A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.

B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array

C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files

D. Database files stored in ZFS and accessed using conventional NFS mounts.

E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature

F. Database files stored in any file system and accessed using the Oracle Direct NFS feature

G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Examine the RMAN commands executed in your database:

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;

RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET;

RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

You issue the command:

RMAN> BACKUP DATABASE;

Which two statements are true about the command? (Choose two.)

A. It performs a log switch.

B. It creates compressed backup sets by using binary compression by default.

C. It backs up only the used blocks in data files.

D. It backs up data files, the control file, and the server parameter file.

E. It creates a backup of only the control file whenever the database undergoes a structural change.

Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

A. The PDB is closed and the temp file is re-created automatically when the PDB is opened.

B. The PDB is closed and requires media recovery at the PDB level.

C. The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.

D. The PDB does not close and starts by using the default temporary tablespace defined for the CD.

Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.

What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

A. SQL Performance Analyzer

B. SQL Access Advisor

C. SQL Tuning Advisor

D. Automatic Workload Repository (AWR) report

E. Automatic Database Diagnostic Monitor (ADDM)

Examine the command used to perform an incremental level-0 backup:

RMAN> BACKUP INCREMENTAL LEVEL0 DATABASE;

To enable block change tracking, after the incremental level 0 backup, you issue the command:

SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE'/mydir/rman_change_track.f';

To perform an incremental level-1 cumulative backup, you issue the command:

RMAN> BACKUP INCREMENTAL LEVEL1 CUMULATIVE DATABASE;

Which two statements are true in the preceding situation? (Choose two.)

A. The block change tracking data is used only from the next incremental backup.

B. The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.

C. The incremental level 1 backup does not use change tracking data for accomplishing the backup.

D. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.

E. The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.