READ Free Dumps For Oracle- 1z0-060
| Question ID 2121 | Which three functions are performed by the SQL Tuning Advisor? |
| Option A | A. Building and implementing SQL profiles |
| Option B | B. Recommending the optimization of materialized views |
| Option C | C. Checking query objects for missing and stale statistics |
| Option D | D. Recommending bitmap, function-based, and B-tree indexes |
| Option E | E. Recommending the restructuring of SQL queries that are using bad plans |
| Correct Answer | A,C,E |
| Question ID 2122 | Examine the following command: |
| Option A | A. None of the data definition language (DDL) statements are logged in the trace file. |
| Option B | B. Only DDL commands that resulted in errors are logged in the alert log file. |
| Option C | C. A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file. |
| Option D | D. Only DDL commands that resulted in the creation of new database files are logged. |
| Correct Answer | A |