최신Oracle Database 19c Performance and Tuning Management - 1z1-084무료샘플문제
문제1
You need to collect and aggregate statistics for the ACCTG service and PAYROLL module, and execute:
Where do you find the output of this command?
You need to collect and aggregate statistics for the ACCTG service and PAYROLL module, and execute:
Where do you find the output of this command?
정답: C
설명: (KoreaDumps 회원만 볼 수 있음)
문제2
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?
정답: A,D
설명: (KoreaDumps 회원만 볼 수 있음)
문제3
Examine this statement and output:
Which two situations can trigger this error?
Examine this statement and output:
Which two situations can trigger this error?
정답: B,C
설명: (KoreaDumps 회원만 볼 수 있음)
문제4
A database instance is suffering poor I/O performance on two frequently accessed large tables.
No Big Table caching occurs in the database.
Examine these parameter settings:
Which are two actions either one of which will allow Big Table caching to occur?
A database instance is suffering poor I/O performance on two frequently accessed large tables.
No Big Table caching occurs in the database.
Examine these parameter settings:
Which are two actions either one of which will allow Big Table caching to occur?
정답: E,F
설명: (KoreaDumps 회원만 볼 수 있음)
문제5
You are informed that the RMAN session that is performing the database duplication is much slower than usual. You want to know the approximate time when the rman operation will be completed.
Which view has this information?
You are informed that the RMAN session that is performing the database duplication is much slower than usual. You want to know the approximate time when the rman operation will be completed.
Which view has this information?
정답: D
설명: (KoreaDumps 회원만 볼 수 있음)
문제6
Which three statements are true about server-generated alerts?
Which three statements are true about server-generated alerts?
정답: A,B,C
설명: (KoreaDumps 회원만 볼 수 있음)