1Z0-417 | Actual Oracle 1Z0-417 dumps

Q21. To analyze all database instances in an Oracle Real Application Cluster, in which mode would you run Automatic Database Diagnostic Monitor? 

A. INSTANCE 

B. DATABASE 

C. FULL 

D. CLUSTER 

E. PARTIAL 

F. ALL 

Answer: A 

Reference: http://docs.oracle.com/cd/E25178_01/server.1111/e16638/diag.htm 

Q22. 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 

Q23. Which two are functionalities of Oracle Real Application Testing? 

A. Database Replay 

B. SQL Query Sets (SQS) 

C. SQL Tuning Analyzer 

D. SQL Performance Analyzer (SPA) 

E. Real Application Cluster Replay 

Answer: A,E 

Q24. Which are three use cases in which SQL Performance Analyzer can be used? 

A. find and flashback explain plan anomalies 

B. simulate Exadata on existing hardware 

C. forecast impact of a system change on aSQL workload 

D. compare performance of SQL statements before and after a change 

E. debug SQL code syntax before and after a change 

F. JSQL Heap Memory overflow testing 

Answer: B,C,E 

Q25. Which are two characteristics of “invisible” index functionality that would help tune a database having thousands of legacy indexes? 

A. An invisible index is ignored by the optimizer. 

B. After an index becomes invisible, it is no longer maintained during insertsand updates. 

C. I/O bottlenecks are easy to spot when invisible indexes are used. 

D. An index only needs to be rebuilt for it to be visible again. 

E. The session or system parameter needs to be changed toOPTIMIZER_USE_INVISIBLE_INDEXEStoTRUEfor an invisible index to become visible to the Optimizer. 

Answer: A,E 

Q26. Which option would you use to validate performance when migrating an Oracle Database from HPUX Itanium to Oracle Linux 6 architecture? 

A. Oracle Diagnostic Pack for Database 

B. Real Application Testing 

C. Oracle Migration Pack for Databases 

D. Oracle Migration Performance Advisor 

E. SQL Performance Testing Suite 

Answer: C 

Q27. 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. variety of real-time reports once the Business Intelligence option is installed 

B. reports in response to critical errors 

C. reports with findings and recommendations to resolve problems 

D. reports examining memory and process usage 

E. historical reports after the Database Diagnostic Repository (DDR) is configured 

F. reports examining user and developer SQL programming errors 

Answer: B,E,F 

Q28. Which two statements are true about Oracle Enterprise Manager Database Express? 

A. It uses internal infrastructure components, such as XDB and SQL*NET. 

B. It can perform actions inside and outside the database. 

C. Performance Hub and Composite Active Reports are its key functionalities. 

D. It is not supported on Oracle Standard Edition or Express Edition. 

E. It replaces Oracle Grid Control. 

Answer: A,C 

Reference: http://www.oracle.com/technetwork/database/manageability/emx-intro-1965965.html 

Q29. Which is Oracle's architecture and methodology for Oracle Database High Availability (HA)? 

A. High Availability High Accessibility Architecture for Oracle Database 

B. Oracle Real Application Clusters 

C. Maximum Availability Architecture for Oracle Database 

D. Oracle Exadata 

E. Oracle Database 12c 

Answer: B 

Explanation: 

Oracle Real Application Clusters (Oracle RAC) is a clustered version of Oracle Database based on a comprehensive high-availability Reference: http://www.oracle.com/us/products/database/options/real-application-clusters/overview/index.html 

Q30. Which statement about Oracle Enterprise Manager Database Expressis correct? 

A. Oracle Enterprise Manager Database Control must be configured first. 

B. The listener needs to be running for it to be accessed. 

C. A Oracle Enterprise Manager Database Express WebLogic Server must be configured first. 

D. Oracle Internet Application Server needs to be installed to use it. 

E. Oracle Enterprise Manager Database Express can be used only from a command-line. 

Answer: A 

Reference: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/2day_dba/gettingstart ed/ gettingstarted.htm