READ Free Dumps For Oracle- 1z0-060
| Question ID 20772 | Which three functions are performed by the SQL Tuning Advisor?
|
| Option A | Building and implementing SQL profiles
|
| Option B | Recommending the optimization of materialized views
|
| Option C | Checking query objects for missing and stale statistics
|
| Option D | Recommending bitmap, function-based, and B-tree indexes
|
| Option E | Recommending the restructuring of SQL queries that are using bad plans
|
| Correct Answer | A,C,E |
Explanation Explanation: The SQL Tuning Advisor takes one or more SQL statements as an input and invokes the Automatic Tuning Optimizer to perform SQL tuning on the statements. The output of the SQL Tuning Advisor is in the form of an advice or recommendations, along with a rationale for each recommendation and its expected benefit. The recommendation relates to collection of statistics on objects (C), creation of new indexes, restructuring of the SQL statement (E), or creation of a SQL profile (A). You can choose to accept the recommendation to complete the tuning of the SQL statements.
| Question ID 20773 | Examine the following command:
ALTER SYSTEM SET enable_ddl_logging=FALSE;
Which statement is true?
|
| Option A | None of the data definition language (DDL) statements are logged in the trace file.
|
| Option B | Only DDL commands that resulted in errors are logged in the alert log file.
|
| Option 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 | Only DDL commands that resulted in the creation of new database files are logged.
|
| Correct Answer | A |
Explanation Real 17 Oracle 1z0-060 Exam Explanation: ENABLE_DDL_LOGGING enables or disables the writing of a subset of data definition language (DDL) statements to a DDL alert log. The DDL log is a file that has the same format and basic behavior as the alert log, but it only contains the DDL statements issued by the database. The DDL log is created only for the RDBMS component and only if the ENABLE_DDL_LOGGING initialization parameter is set to true. When this parameter is set to false, DDL statements are not included in any log.