Oracle 1z0-417 問題集

質問 1：
A customer asked you about Database Time (DB Time). Which are two correct statements you would include in your description of it?
A. It includes login, idle, background, and Zombie session wait time.
B. It is the total time spent in database calls by all sessions in the database.
C. It is the total time spent in database calls by background sessions in the database.
D. It is the total time spent in database calls by foreground sessions in the database.
E. It includes non-idle wait time.
F. It is the overall response time.
正解：C,D

質問 2：
DBAs use scripts and a third-party tool that access Automatic Workload Repository (AWR) snapshot reports, but don't use Oracle Enterprise Manager. The IT Manager seeks to confirm what the DBAs told him - Its OK since they licensed Oracle Database Enterprise Edition and not the Standard Edition. Which is the correct response for this scenario?
A. No matter how AWR snapshot reports are accessed, Oracle Enterprise Edition Database customers needto be licensed for the Oracle Diagnostic Pack for Oracle Databases.
B. With an Oracle Database Enterprise Edition license, an Oracle customer can use any Oracle option theywant, at that location, without additional licensing.
C. With an Oracle Enterprise Edition Database license, a customer can use any Oracle option they want, atany of their worldwide locations, without additional licensing.
D. With an Oracle Database Enterprise Edition license, an Oracle customer can access AWR snapshots byusing SQL. If you use anything else, then you need an additional license.
E. No matter how AWR snapshot reports are accessed, Oracle Enterprise Edition Database customers needtobe licensed for the Advanced Analytic Pack for Oracle Databases.
正解：B

質問 3：
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. reports examining user and developer SQL programming errors
B. historical reports after the Database Diagnostic Repository (DDR) is configured
C. reports examining memory and process usage
D. reports with findings and recommendations to resolve problems
E. variety of real-time reports once the Business Intelligence option is installed
F. reports in response to critical errors
正解：A,B,F

質問 4：
To isolate performance problem in an Oracle real Application Cluster, for which two abilities would you implement Oracle Diagnostics Pack for Oracle Databases?
A. Cluster-wide performance analysis and reports with ADDM on issues that affect an entire databaseas wellas its individual instances.
B. ADDM X$ and V$ performance analysis and reports that compare the overall RAC Database to the sum ofits individual database instances.
C. ADDM recommendations inclusive of SAN and NFS mounted storage to pinpoint issues within the storagecache.
D. ADDM's ability to review SNMP trap error messages and automatically open trouble tickets.
E. Database-wide analysis of global resources by ADDM for high-load SQL, global cache interconnect traffic,and skew in instance response times.
正解：B,C

質問 5：
Which two situations help to identify that a customer as already using Oracle Diagnostics Pack for Oracle Database functions?
A. A customer says that he or she doesn't use Enterprise Manager, but you learn that the customer routinelyexecutesawrrpt.sqlfrom the SQLPlus prompt.
B. A customer has theCONTROL_MANAGEMENT_PACK_ACCESSinitialization parameter set toDIAGNOSTIC +TUNING.
C. A customer says that he or she doesn't use theEnterprise Manager, but you learn that the customer usescustomized SQL scripts that accessV$SESSIONandV$SQLviews.
D. A customer says that he or she doesn't use Enterprise Manager, but you learn that the customer has SQLscripts that access theDBA_HIST_ACTIVE_SESS_HISTORYdatabase view.
E. The customer has Enterprise Manager installed on a separate server and regularly accesses the Databasehome page of some of its Enterprise Edition databases from its console.
正解：B,D

質問 6：
Upon migration to Oracle Database 12c, a customer asked that monitoring at an individualdatabase level be disabled in favor of database performance monitoring consolidated and centralized across their enterprise.
Which are two actions you would take to meet the customer's requirements?
A. Delete the "express" directory in Oracle Home to disable Oracle Enterprise Manager Database Express.
B. Disable Oracle Enterprise Manager Database Express by setting the HTTP Port to 0.
C. Changes permissions of the "express" directory to real only by root.
D. Enable SNMP and configure MIBS on each databaseand forward database monitoring SNMP traps.
E. Using the appropriate architectureimplement Oracle Enterprise Manager.
F. For the always active Oracle Enterprise Manager Database Express process, create a script that willdisable that process upon database boot.
正解：C,F

質問 7：
When planning an Oracle Database architecture, which are three caching functionalities that would improve application response time and speed up query processing?
A. Result Cache
B. Database Smart Flash Cache
C. Mega Cache
D. Oracle In-Memory DBSTATS Cache
E. Oracle In-Memory Database Cache
正解：A,B,E

質問 8：
You are reviewing an Automatic Database Diagnostic Monitor report. What is DB Time% a percentage of?
A. total time in database calls by all processes
B. time that users wait for the database to respond
C. total CPU time
D. elapsed response time
E. total time in V$ views
正解：A