1Z0-417 | Improve Oracle 1Z0-417 dumps
Q1. A customer asked you about Database Time (DB Time). Which are two correct statements you would include in your description of it?
A. It is the total time spent in database calls by all sessions in the database.
B. It is the total time spent in database calls by foreground sessions in the database.
C. It is the total time spent in database calls by background sessions in the database.
D. It includes non-idle wait time.
E. It is the overall response time.
F. It includes login, idle, background, and Zombie session wait time.
Answer: B,C
Q2. 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
Q3. When implementing an Oracle Database Performance and Tuning solution, which are three product technologies recommended for use as your base configuration?
A. SQL Tuning Pack for Oracle Database
B. Oracle Tuning Pack for Oracle Database
C. Oracle Performance Pack for Oracle Database
D. Oracle Diagnostics Pack for Oracle Database
E. Oracle Real Application Testing
F. Oracle SQL Developer
G. STATSPACK
Answer: B,D,E
Reference: http://www.oracle.com/partners/en/most-popular-resources/db-performance-tuning-study-guide2138991.pdf (See page #03, Application product technology subject areas include).
Q4. In which two formats does Automatic Workload Repository (AWR) provide statistics?
A. Persistent
B. Temporary
C. Unlimited
D. Basic
E. Full
Answer: A,B
Reference: https://talebzadehmich.wordpress.com/2012/05/05/automated-workload-repositpry-awrperformance-monitoring-tool-basics/
Q5. Which three are controllable by a resource plan, when you are using the Oracle Database 12c Multitenant option?
A. CPU
B. concurrent sessions
C. SGA
D. network I/O
E. ability to use parallel server processes
F. use of SGA memory and ability to allocate PGA
Answer: A,B,E
Explanation: Section: (none) Explanation
Q6. Which is a capability that Active Session History (ASH) reports enable you to perform?
A. Compare database performance between two periods of time, and resolve performance degradation thatmay happen from one time period to another.
B. Analyze transient performance problems with the database that are short-lived and do not appear in theADDM analysis.
C. Optimize the performance of data access paths by creating the proper set of materialized views,materialized view logs, and indexes for a given workload.
D. Analyze transient performance problems that have happened in the database since it has been started.
Answer: A
Q7. 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
Q8. 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
Q9. Which issue can be avoided by configuring the PCTFREE parameter?
A. row chaining and setting it has been superseded by Automatic Segment Space Management
B. table fragmentation, and has been superseded by Automatic Storage Management
C. column fragmentation
D. sort operations on disk
E. keeping a reserve area for backup
Answer: A
Q10. 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?
A. memory
B. CPU
C. Parallel Execution Servers
D. shares of systemresources
E. number of users
F. number of tables or indexes
G. number of indexes
Answer: B,C,D