최신Oracle Database 19c Performance and Tuning Management - 1Z0-084무료샘플문제
문제1
Examine these commands, which execute successfully:
Which statement is true?
Examine these commands, which execute successfully:
Which statement is true?
정답: A
설명: (ExamPassdump 회원만 볼 수 있음)
문제2
Which three types of statistics are captured by statspack with snap level 6?
Which three types of statistics are captured by statspack with snap level 6?
정답: A,C,E
설명: (ExamPassdump 회원만 볼 수 있음)
문제3
You manage a 19c database with default optimizer settings.
This statement is used extensively as subquery in the application queries:
SELECT city_id FROM sh2.sales WHERE city_id=:Bl
You notice the performance of these queries is often poor and, therefore, execute:
SELECT city_id,COUNT(*) FROM sh2.sales GROUP BY city_id;
Examine the results:
There is no index on the CITY_ID column.
Which two options improve the performance?
You manage a 19c database with default optimizer settings.
This statement is used extensively as subquery in the application queries:
SELECT city_id FROM sh2.sales WHERE city_id=:Bl
You notice the performance of these queries is often poor and, therefore, execute:
SELECT city_id,COUNT(*) FROM sh2.sales GROUP BY city_id;
Examine the results:
There is no index on the CITY_ID column.
Which two options improve the performance?
정답: B,E
설명: (ExamPassdump 회원만 볼 수 있음)
문제4
The CURS0R_SHARING and OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameters are set to default. The top five wait events in an awr report are due to a large number of hard parses because of several almost identical SQL statements.
Which two actions could reduce the number of hard parses?
The CURS0R_SHARING and OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameters are set to default. The top five wait events in an awr report are due to a large number of hard parses because of several almost identical SQL statements.
Which two actions could reduce the number of hard parses?
정답: C,D
설명: (ExamPassdump 회원만 볼 수 있음)
문제5
Which two statements are true about the use and monitoring of Buffer Cache Hit ratios and their value in tuning Database I/O performance?
Which two statements are true about the use and monitoring of Buffer Cache Hit ratios and their value in tuning Database I/O performance?
정답: A,E
문제6
You want to reduce the amount of db file scattered read that is generated in the database. You execute the SQL Tuning Advisor against the relevant workload. Which two can be part of the expected result?
You want to reduce the amount of db file scattered read that is generated in the database. You execute the SQL Tuning Advisor against the relevant workload. Which two can be part of the expected result?
정답: A,B
설명: (ExamPassdump 회원만 볼 수 있음)