Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 221:

  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 prerequisites for this command to succeed? (Choose three.)

  A. Undo retention guarantee must be enabled.

  B. No other table with the same name should exist in the HR schema.

  C. SCOTT should have the FLASHBACK ANY TABLE privilege.

  D. SCOTT should have the SELECT privilege on the HR schema and its recycle bin.

  E. No duplicates of the HR.EMPLOYEES table should exist in the recycle bin of the HR schema.

  F. The recycle bin should be enabled.

  Correct Answer: BCF

• Question 222:

  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?

  A. when recovering a table to a point in time

  B. when recovering a table that has been logically corrupted

  C. when recovering dropped tables that are present in the recyclebin

  D. when recovering the data of a table to the desired point in time, which is more recent than the oldest available undo

  E. when recovering data that was lost after a DDL operation modified the structure of a table

  Correct Answer: A

• Question 223:

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

  A. creating a control file for the duplicate database

  B. restoring target data files to the duplicate database

  C. performing complete recovery by using all available backups

  D. generating a new, unique database identifier (DBID) for the duplicate database

  E. copying online redo log files from the target database to the duplicate database

  Correct Answer: CE

• Question 224:

  Which three factors influences the optimizer's choice of an execution plan? (Choose three.)

  A. Cardinality estimates

  B. The OPTIMIZER_MODE initialization parameter

  C. Fixed baselines

  D. Type of connection used to connect to database instance

  E. Object statistics in the data dictionary

  Correct Answer: ABE

• Question 225:

  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 must be included in future backups.

  Which action should you perform?

  A. Synchronize the recovery catalog with the target database control file.

  B. Create a new database incarnation record.

  C. Add the tablespaces in the recovery catalog by using the CATALOG command.

  D. Synchronize all the physical data files with the logical records in the recovery catalog by using the CROSSCHECK command.

  Correct Answer: A

• Question 226:

  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?

  A. All backups and archived redo log files that are not required for the recovery are deleted and the repository is updated.

  B. All metadata, for backups and archived redo log files that are recorded in the repository but do not exist on disk or media, is deleted.

  C. All backups that have exceeded the age set by the RMAN retention policy are deleted.

  D. All metadata pertaining to backups and archived redo log files that have exceeded the age set by the RMAN retention policy are deleted from the repository.

  Correct Answer: B

• Question 227:

  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 backup. After that, a few important transactions are performed on the database.

  Which two best methods for recovering the truncated table data? (Choose two.)

  A. Table Point-in-Time Recovery

  B. Database Point-in-Time Recovery

  C. Tablespace Point-in-Time Recovery

  D. Flashback Database

  E. Flashback Transaction Backout

  Correct Answer: BD

  Reference https://blogs.oracle.com/sql/how-to-recover-data-without-a-backup

• Question 228:

  You issue the RMAN command:

  RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;

  Which statement is true about the execution of the command?

  A. The resulting backupset has backup pieces that cannot exceed 300 MB.

  B. RMAN uses multiplexing to perform the backup.

  C. RMAN always performs this type of backup in parallel.

  D. The backup succeeds only if the USERS tablespace is locally managed.

  E. The backup set size is limited to 300 MB.

  Correct Answer: A

• Question 229:

  Which two statements are true about encrypted backups performed by using RMAN? (Choose two.)

  A. Transparent encryption of backups uses an encryption wallet.

  B. A database uses the same encryption key for every encrypted backup.

  C. A password encryption of backups uses the password while creating and restoring backups.

  D. Image copy backups can be created by using password encryption.

  E. Encrypted backups can only be written to disk.

  Correct Answer: AC

• Question 230:

  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 and PDB2 connect to the pluggable databases (PDBs), PDB1 and PDB2, respectively.

  Examine the commands to change the value of the PDB modifiable initialization parameter:

  

  Which statement is true about the OPTIMIZER_USE_SQL_PLAN_BASELINES parameter?

  A. It gives an error because it cannot be set for the root database.

  B. It is set to TRUE for the root database and the pluggable database PDBs, because values can be set for this parameter at the PDB level in a PDB.

  C. It is set to TRUE for the root database and all the PDBs, because the value set at the root level has higher precedence.

  D. It is set to TRUE for the root database and all the PDBS, but is effective only when the CDB is restarted and the PDBs are reopened.

  Correct Answer: B