Free 1Z0-063 Exam Dumps

Question 16

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

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?

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.)

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.)

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.)

Correct Answer:BCF