최신Oracle Database Performance and Tuning Essentials 2015 - 1z1-417무료샘플문제
문제1
When providing partition and index recommendations, which one would SQL Access Advisor source input from?
When providing partition and index recommendations, which one would SQL Access Advisor source input from?
정답: A
문제2
Which are three practices that developers can use to enhance performance, scalability, and availability of Oracle Database-driven applications?
Which are three practices that developers can use to enhance performance, scalability, and availability of Oracle Database-driven applications?
정답: B,C,D
문제3
Which are two kinds of statistics collected and processed by the Automatic Workload Repository (AWR) you would utilize when tuning an Oracle Database instance?
Which are two kinds of statistics collected and processed by the Automatic Workload Repository (AWR) you would utilize when tuning an Oracle Database instance?
정답: A,E
설명: (ITDumpsKR 회원만 볼 수 있음)
문제4
Which is used to preserve SQL execution plans of existing statements when moving from one version of the database to another?
Which is used to preserve SQL execution plans of existing statements when moving from one version of the database to another?
정답: C
설명: (ITDumpsKR 회원만 볼 수 있음)
문제5
What are two reasons for which the Diagnostics and Tuning packs are essential to ongoing maintenance of an Oracle Database?
What are two reasons for which the Diagnostics and Tuning packs are essential to ongoing maintenance of an Oracle Database?
정답: C,E
문제6
You need to limit the resources available to each Pluggable Database (PDB) within a Container Database (CDB). Utilizing Resource Manager, which are three options that can be managed by a resource plan?
You need to limit the resources available to each Pluggable Database (PDB) within a Container Database (CDB). Utilizing Resource Manager, which are three options that can be managed by a resource plan?
정답: B,C,G
문제7
Which option is recommended when gathering Optimizer system statistics on a regular basis to ensure optimal performance?
Which option is recommended when gathering Optimizer system statistics on a regular basis to ensure optimal performance?
정답: A
설명: (ITDumpsKR 회원만 볼 수 있음)
문제8
Oracle databases come with a built-in health monitor to run diagnostic checks on components of the database. Which three capabilities can be used to automate reporting?
Oracle databases come with a built-in health monitor to run diagnostic checks on components of the database. Which three capabilities can be used to automate reporting?
정답: A,C,D
문제9
Upon implementation completion, which three should be reviewed with a customer to confirm the values or benefits of a Oracle Database Performance and Tuning solution?
Upon implementation completion, which three should be reviewed with a customer to confirm the values or benefits of a Oracle Database Performance and Tuning solution?
정답: A,C,E