Free 1Z0-063 Exam Dumps

Question 16

- (Exam Topic 1)
Which two statements are true about dropping a pluggable database (PDB)? (Choose two.)

A. A PDB must be in mount state or it must be unplugged.
B. The data files associated with a PDB are automatically removed from disk.
C. A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.
D. A PDB must be in closed state.
E. The backups associated with a PDB are removed.
F. A PDB must have been opened at least once after creation.

Correct Answer:AD

Question 17

- (Exam Topic 1)
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

A. statistics recommendations
B. SQL profile recommendations
C. SQL statement restructure recommendations
D. creation of materialized views to improve query performance

Correct Answer:B

Question 18

- (Exam Topic 2)
You regularly take backups of your database using RMAN with a recovery catalog. Your database is currently open and the temp01.dbf temp file belonging to the TEMP tablespace is corrupted.
Identify two methods to recover the temp file with the least disruption to database availability. (Choose two.)

A. Drop the TEMP tablespace, and then re-create it with new temp files.
B. Restart the database instance to create the temp file automatically.
C. Take the TEMP tablespace offline, drop the missing temp file, and then create a new temp file.
D. Add a new temp file to the TEMP tablespace with a new name, and then drop the temp file that is corrupted.

Correct Answer:BC
Temp files are a special class of data files that are associated only with temporary tablespaces.
B: After restore and recovery of a whole database, when the database is open, missing temporary tablespaces that were recorded in the control file are re-created with their previous creation size, AUTOEXTEND, and MAXSIZE attributes. Only temporary tablespaces that are missing are re-created. If a temp file exists at the location recorded in the RMAN repository but has an invalid header, then RMAN does not re-create the temp file.
If the temp files were created as Oracle-managed files, then they are re-created in the current DB_CREATE_FILE_DEST location. Otherwise, they are re-created at their previous locations.
C: If a data file becomes missing or corrupted. You must take it offline before you can open the database.
References: https://docs.oracle.com/database/121/ADMIN/dfiles.htm https://docs.oracle.com/database/121/BRADV/rcmcomre.htm

Question 19

- (Exam Topic 1)
Identify two scenarios in which the RMAN CROSSCHECK command can be used. (Choose two.)

A. when checking for backups that are not required as per the retention policy
B. when updating the RMAN repository if any of the archived redo log files have been deleted without using RMAN to do the deletes
C. when updating outdated information about backups that disappeared from disk or media or became corrupted and inaccessible
D. when synchronizing backups, which were not performed by using RMAN, with the RMAN repository
E. when listing backups that are required for recovery operations

Correct Answer:BE

Question 20

- (Exam Topic 2)
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 recyclebin.
E. No duplicates of the HR.EMPLOYEES table should exist in the recyclebin of the HR schema.
F. The recycle bin should be enabled.

Correct Answer:BCF