READ Free Dumps For Oracle- 1z0-060
| Question ID 2125 | Identify two valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB). |
| Option A | A. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED. |
| Option B | B. Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED. |
| Option C | C. Use the DBMS_PDB package to clone an existing PDB. |
| Option D | D. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB. |
| Option E | E. Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11.2.0.3.0) non-CDB database into an existing CDB. |
| Correct Answer | A,D |
| Question ID 2126 | Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache. |
| Option A | A. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS. |
| Option B | B. Run the Automatic Workload Repository Monitor (ADDM). |
| Option C | C. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS. |
| Option D | D. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS. |
| Correct Answer | D |