READ Free Dumps For Oracle- 1z0-060
| Question ID 2101 | Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp. |
| Option A | A. Add a new temp file to the temporary tablespace and drop the temp file that that produced the error. |
| Option B | B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database. |
| Option C | C. Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online. |
| Option D | D. Shutdown the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS. |
| Option E | E. Shut down the database instance and then restart the CDB and PDBs. |
| Correct Answer | A,E |
| Question ID 2102 | Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:
|
| Option A | A. All the triggers for the table are disabled without changing any of the column names or column types in the table. |
| Option B | B. The primary key constraint on the EMPLOYEES table is disabled during redefinition. |
| Option C | C. VPD policies are copied from the original table to the new table during online redefinition. |
| Option D | D. You must copy the VPD policies manually from the original table to the new table during online redefinition. |
| Correct Answer | A,C |
