You execute the command to enable tracing of the ORCL1 service:
Which two statements are true? (Choose two.)
Question 6 of 84
You are administering a database that supports multiple applications, which make dedicated connections to the database instance by using different services.
You execute the command to enable tracing of the ORCL1 service:
Which two statements are true? (Choose two.)
You execute the command to enable tracing of the ORCL1 service:
Which two statements are true? (Choose two.)
Correct Answer: A, C
Question 7 of 84
In which three situations can dynamic statistics be used? (Choose three.)
Correct Answer: B, C, D
Question 8 of 84
You want to generate statistics for new objects added to an OLTP application without affecting old statistics and the sessions that currently use them.
Which two tasks would you perform to test the new statistics? (Choose two.)
Which two tasks would you perform to test the new statistics? (Choose two.)
Correct Answer: A, B
Question 9 of 84
You plan to upgrade your production database from Oracle Database 11g to 12c. As part of the upgrade, you want to introduce new indexes and materialized views. You have already created a test system with Oracle Database 12c, having the same structure and data as the production database, along with new schema objects to be added to the production database.
You want to identify regressed SQL statements, if any, which may have been caused by schema changes and the change in the optimizer version.
Which two methods would you use to achieve this? (Choose two.)
You want to identify regressed SQL statements, if any, which may have been caused by schema changes and the change in the optimizer version.
Which two methods would you use to achieve this? (Choose two.)
Correct Answer: A, D
Question 10 of 84
You recently joined a new team administering a database.
You notice that full table scans are performing poorly compared with full table scans on the databases you administered in a previous job.
You decide that performance problems are caused by a misconfiguration of factors affecting full table scans.
Which three factors should you investigate to determine the cause of the poorly performing Full Table Scans (FTS)? (Choose three.)
You notice that full table scans are performing poorly compared with full table scans on the databases you administered in a previous job.
You decide that performance problems are caused by a misconfiguration of factors affecting full table scans.
Which three factors should you investigate to determine the cause of the poorly performing Full Table Scans (FTS)? (Choose three.)
Correct Answer: A, B, C