QUESTION NO: 1
You have been asked to assess if using column store compression (previously known as hybrid columnar compression or HCC) would help improve the performance of queries on some large tables.
Which three aspects should you consider before you choose this compression method? (Choose three.)
You have been asked to assess if using column store compression (previously known as hybrid columnar compression or HCC) would help improve the performance of queries on some large tables.
Which three aspects should you consider before you choose this compression method? (Choose three.)
Correct Answer: A,B,E
Vote an answer
QUESTION NO: 2
Your database supports an OLTP workload during the day and batch processing at night. You want to monitor performance metrics to detect any degradation of performance in both types of workloads over a time period of 30 days.
Examine this list of possible steps:
1. Create a fixed baseline.
2. Create a baseline template.
3. Create a new moving window baseline.
4. Increase the retention period default value to 30 days.
5. Increase the size of the existing moving window baseline to 30 days.
6. Create warning and critical alerts for the relevant metrics.
7. Enable adaptive thresholds to detect the workload patterns and specify a high-significance-level threshold type.
8. Enable adaptive thresholds to detect the workload patterns and set different threshold values as a percentage of the maximum value.
Which option represents the required steps in the correct order? (Choose the best answer.)
Your database supports an OLTP workload during the day and batch processing at night. You want to monitor performance metrics to detect any degradation of performance in both types of workloads over a time period of 30 days.
Examine this list of possible steps:
1. Create a fixed baseline.
2. Create a baseline template.
3. Create a new moving window baseline.
4. Increase the retention period default value to 30 days.
5. Increase the size of the existing moving window baseline to 30 days.
6. Create warning and critical alerts for the relevant metrics.
7. Enable adaptive thresholds to detect the workload patterns and specify a high-significance-level threshold type.
8. Enable adaptive thresholds to detect the workload patterns and set different threshold values as a percentage of the maximum value.
Which option represents the required steps in the correct order? (Choose the best answer.)
Correct Answer: B
Vote an answer
QUESTION NO: 3
Examine an extract from a PGA Memory Advisory for your database:
Which two inferences are correct? (Choose two.)
Examine an extract from a PGA Memory Advisory for your database:
Which two inferences are correct? (Choose two.)
Correct Answer: C,D
Vote an answer
QUESTION NO: 4
Your database supports an online transaction processing (OLTP) workload. The database uses ASM storage. One of the ASM disks goes offline because of hardware failure. When the disk is replaced and then added back to the diskgroup, database performance is affected by rebalance operations.
Which two actions would you recommend to lower the impact of rebalance operations on the performance of the database? (Choose two.)
Your database supports an online transaction processing (OLTP) workload. The database uses ASM storage. One of the ASM disks goes offline because of hardware failure. When the disk is replaced and then added back to the diskgroup, database performance is affected by rebalance operations.
Which two actions would you recommend to lower the impact of rebalance operations on the performance of the database? (Choose two.)
Correct Answer: B,C
Vote an answer
QUESTION NO: 5
To diagnose the performance degradation of your production database, you execute these queries:
Segment space management is manual for some of the tablespaces.
What can be the reason for the performance degradation?
To diagnose the performance degradation of your production database, you execute these queries:
Segment space management is manual for some of the tablespaces.
What can be the reason for the performance degradation?
Correct Answer: C
Vote an answer
QUESTION NO: 6
You upgrade your database from Oracle Database 11g to 12c. You capture execution plans for a resource-intensive SQL workload before the upgrade. After the upgrade, you load the plans into the SQL Management Base.
Examine the parameters set for the instance:
Which two statements are true?
You upgrade your database from Oracle Database 11g to 12c. You capture execution plans for a resource-intensive SQL workload before the upgrade. After the upgrade, you load the plans into the SQL Management Base.
Examine the parameters set for the instance:
Which two statements are true?
Correct Answer: A,C
Vote an answer
QUESTION NO: 7
Examine the parameters set for your database instance:
To investigate the slow response time of queries on the TRANS table, you gather table and execute the query:
The table is stored in a tablespace with Automatic Segment Space Management (ASSM), and some rows of the TRANS table are migrated and chained.
Which two actions would you recommend to improve query response time?
Examine the parameters set for your database instance:
To investigate the slow response time of queries on the TRANS table, you gather table and execute the query:
The table is stored in a tablespace with Automatic Segment Space Management (ASSM), and some rows of the TRANS table are migrated and chained.
Which two actions would you recommend to improve query response time?
Correct Answer: A,B
Vote an answer
QUESTION NO: 8
As part of an application upgrade, new objects are being added to an application schem a. You want to check the effect of the new schema objects on the performance of the SQL workload generated by the application.
How would you accomplish this?
As part of an application upgrade, new objects are being added to an application schem a. You want to check the effect of the new schema objects on the performance of the SQL workload generated by the application.
How would you accomplish this?
Correct Answer: D
Vote an answer
QUESTION NO: 9
Which three methods can you use to create a pre-change SQL trial to capture performance data by using SQL Performance Analyzer? (Choose three.)
Which three methods can you use to create a pre-change SQL trial to capture performance data by using SQL Performance Analyzer? (Choose three.)
Correct Answer: A,B,E
Vote an answer