1Z0-063 Exam Questions

Which three statements are true about unplugging a pluggable database (PDB)?

You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular b...

You execute the command to recover your database: Which statement is true?

You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN). Which two are prerequisites for performing this operation...

The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema own...

In CDB$ROOT of your multitenant container database (CDB), you create a common user, C##A_ADMIN. and then execute the command: Which statement is true?

Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup (OSB): 1. RMAN initiates backup and passes the database backup storage selector to...

Which three statements are true about common roles?

Which statement is true about the ALTER SESSION SET CONTAINER command to switch between containers?

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

RMAN is configured to create backupset backups for your database. You issue the command to back up the database: RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT; Which two state...

Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start?

Your database is running in ARCHIVELOG mode. You use RMAN to take image copies and you update these copies incrementally every six hours. After a regular maintenance task, when you...

Examine the statements that use flashback technologies: 1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (`2013-02-04 09:30:00', `YYYY- MM-DD HH:MI:SS'); 2. SELECT * FROM cus...

Which two statements are true about RMAN duplexed backups?

You are required to migrate your 11.2.0.3 database to an Oracle 12c database. Examine the list of steps that might be used to accomplish this task: 1. Place all user-defined tables...

You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transaction...

Your database supports an online transaction processing (OLTP) workload and it needs to be up 24 x 7. You want to perform a complete database backup by using RMAN. Identify the min...

You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user...

Which two statements are true about roles in multitenant container databases (CDBs)?

Which three conditions must be met before you Virtual Private Catalog (VPC) can be created and used by an Administrator?

Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidentally truncates an important table at 10 AM after the last bac...

You issue the RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which statement is true about the execution of the command?

Which two statements are true about encrypted backups performed by using RMAN?

Your multitenant container database (CDB) CDB1 has two pluggable databases, PDB1 and PDB2. The local net service name CDB1 connects to the root database, and the service names PDB1...

You execute the RMAN commands: RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk; RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2; RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT `/disk...

Which two operations are NOT performed by the DUPLICATE command in RMAN while duplicating a database that is open?

Your database is running in archivelog mode. Examine the parameters for your database instance: LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY' LOG_ARCHIVE_DEST_2 ='LOCATION=/...

You are performing regular backups of your production database by using a recovery catalog. You add two new tablespaces to your production database after performing a backup. They...

You use RMAN to take regular backups for your database. Examine the RMAN commands: RMAN> CROSSCHECK BACKUP; RMAN>DELETE EXPITED BACKUP; Which statement is true?

Which two are prerequisites for performing Flashback Transaction?

In your database, the user SCOTT wants to retrieve the dropped HR. EMPLOYEES table by using the command: SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP; What are three prerequisi...

Your database is running in ARCHIVELOG mode and flashback is enabled. In which scenario must you use RMAN backups for recovering tables and table partitions?

Examine the RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN>CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN >DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DAT...

Which three statements are true about Flashback Data Archive?

Which three types of backups can be performed for a database running in NOARCHIVELOG mode?