Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. For which use case would you utilize SQL Performance Analyzer and optimizer pending statistics functionality?
A. to test performance after an upgrade to an Oracle Real Application Cluster
B. to test performance of an Operating System patch
C. to test effect of new Optimizer statistics
D. to test performance after a database upgrade
E. to test performance just after a database reboot
Answer: A
Q2. 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. real-time and historical monitoring capabilities
B. non-intrusive metric collections
C. statspack integration and support
D. integration with Enterprise Manager
E. included scripts for querying X$ and V$ views
F. SQL script code management capabilities
Answer: A,B,D
Q3. Identify four problems automatically diagnosed by Automatic Database Diagnostics Monitor (ADDM).
A. log file sizing
B. log buffer sizing
C. log file problematic naming
D. Mean Time to recover (MTTR) setting
E. undersized SGA or PGA
F. oversized SGA or PGA
G. Less Time to recover (LTTR) setting
Answer: D,E,F,G
Q4. What are three activities an Oracle Database Performance and Tuning solution enables a customer to perform?
A. standardize database troubleshooting and diagnostics
B. control database clouds.
C. automate database performance management
D. perform global database backup
E. outsource database operations
F. replay and test actual workloads to assure database performance and consolidatios.
Answer: C,D,E
Q5. Which three issues can be addressed with an Oracle Database Performance and Tuning solution?
A. erratic or inconsistent database performance
B. declining database responsiveness
C. unlimited I/O
D. fragmented database tables
E. database registry errors
F. database replication
Answer: C,D,F
Q6. Which are three practices that developers can use to enhance performance, scalability, and availability of Oracle Database-driven applications?
A. Implement primary and foreign keys, enforce database integrity, joins, message queuing, maintenance ofsequencesoutside of the database.
B. Use Big Data to hold everything into one big table.
C. Maintain and analyze performance statistics using AWR and ADDM.
D. Eliminate hot spots in applications, monitor, measure, and optimize SQL statement execution.
E. Perform testing with Real Application Testing.
Answer: A,C,E
Q7. A customer has database performance issues within their Oracle Real Application Cluster. What is the next step?
A. Run the V$RAC script to dump all the RAC statistics and look for what has the highest metric accumulation.
B. Use the application load testing utility to overload a copy of their application in development to flush out theissue.
C. Turnoff RAC interconnects to isolate any network issues impacting database performance problems.
D. Use a third-party RAC tool to identify the bad SQL and then rewrite it.
E. Utilize the Oracle Database Performance Method to help identify and correct issue.
Answer: E
Q8. 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. With an Oracle Enterprise Edition Database license, a customer can use any Oracle option they want, atany of their worldwide locations, without additional licensing.
B. No matter how AWR snapshot reports are accessed, Oracle Enterprise Edition Database customers needto be licensed for the Oracle Diagnostic Pack for Oracle Databases.
C. With an Oracle Database Enterprise Edition license, an Oracle customer can use any Oracle option theywant, at that location, without additional licensing.
D. No matter how AWR snapshot reports are accessed, Oracle Enterprise Edition Database customers needtobe licensed for the Advanced Analytic Pack for Oracle Databases.
E. 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.
Answer: C
Q9. As of Oracle Database 12c, which functionality to access database diagnostic and performance has been superseded by Oracle Enterprise Manager Database Express?
A. SQL Developer
B. SQL Plus
C. Database console
D. SQL Express
E. Grid Control
Answer: C
Reference: http://dbaora.com/enterprise-manager-database-express-oracle-database-12c-release-1-12-1/
Q10. Which two situations help to identify that a customer as already using Oracle Diagnostics Pack for Oracle Database functions?
A. 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. A customer says that he or she doesn't use Enterprise Manager, but you learn that the customer routinelyexecutesawrrpt.sqlfrom the SQLPlus prompt.
C. A customer has theCONTROL_MANAGEMENT_PACK_ACCESSinitialization parameter set toDIAGNOSTIC +TUNING.
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. 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.
Answer: C,D
Q11. When providing partition and index recommendations, which one would SQL Access Advisor source input from?
A. SQL Tuning Advisor
B. Automatic Workload Repository
C. Automatic Database Diagnostic Monitor
D. SQL Tuning Set
Answer: D
Q12. Instead of a database automatically publishing statistics when statistics collection ends, you want to test queries a satisfactory result before they are made available to the entire database. Which would you configure for that to occur?
A. SetOPTIMIZER_USE_PENDING_STATISTICStoTRUE.
B. SetAUTO_UPDATE_STATISTICStoFALSE.
C. Use aHOLD HINTin the SQL.
D. SetAUTOMATIC_WORKLOAD_REPOSITORY_COLLECTIONtoPAUSE.
Answer: A
Q13. Which is a true statement about Automatic Database Diagnostic Monitor (ADDM)?
A. ADDM analyzes information in RMAN.
B. Automatic Workload Repository (AWR) analyzes information stored in snapshots in tables of ADDM.
C. ADDM analyzes information stored in snapshots in tables of the Automatic Workload Repository (AWR).
D. ADDM and AWR are new features of Oracle Database 12c.
E. APEX is required to access ADDM.
Answer: D
Q14. A customer seeks capability to measure and test database performance before and after application changes. Which would you implement to meet that requirement?
A. Oracle Performance Analyzer
B. Oracle Application Performance Analyzer
C. Oracle Real Application Testing
D. Oracle SQL Developer
E. Oracle Spatial and Graph
Answer: E
Q15. 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. Disable Oracle Enterprise Manager Database Express by setting the HTTP Port to 0.
B. For the always active Oracle Enterprise Manager Database Express process, create a script that willdisable that process upon database boot.
C. Using the appropriate architectureimplement Oracle Enterprise Manager.
D. Delete the “express” directory in Oracle Home to disable Oracle Enterprise Manager Database Express.
E. Changes permissions of the “express” directory to real only by root.
F. Enable SNMP and configure MIBS on each databaseand forward database monitoring SNMP traps.
Answer: B,E
Q16. 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. Database-wide analysis of global resources by ADDM for high-load SQL, global cache interconnect traffic,and skew in instance response times.
C. ADDM X$ and V$ performance analysis and reports that compare the overall RAC Database to the sum ofits individual database instances.
D. ADDM recommendations inclusive of SAN and NFS mounted storage to pinpoint issues within the storagecache.
E. ADDM's ability to review SNMP trap error messages and automatically open trouble tickets.
Answer: C,D