1Z0-417 Free Practice Test

Which two situations help to identify that a customer as already using Oracle Diagnostics Pack for Oracle Database functions?

1. 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.
2. B. A customer says that he or she doesn\'t use Enterprise Manager, but you learn that the customer routinelyexecutesawrrpt.sqlfrom the SQLPlus prompt.
3. C. A customer has theCONTROL_MANAGEMENT_PACK_ACCESSinitialization parameter set toDIAGNOSTIC +TUNING.
4. 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.
5. 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.

Correct Answer: CD

You are reviewing an Automatic Database Diagnostic Monitor report. What is DB Time% a percentage of?

1. A. total CPU time
2. B. elapsed response time
3. C. total time in database calls by all processes
4. D. total time in V$ views
5. E. time that users wait for the database to respond

Correct Answer: C

Which is a feature of an Oracle Database Performance and Tuning implemented solution?

1. A. a Documented Set of X$ and V$ Query Scripts
2. B. a Maximum Availability Architecture
3. C. a Documented Performance Methodology
4. D. capability to Cloud Burst
5. E. a Documented Performance Response Method

Correct Answer: B

An Oracle Database customer's VP of Development mentions that they've moved to AGILE development methodology and DevOps requires an ability to view, test, or validate performance in their own development environment. Which two do you implement?

1. A. Oracle Application Infrastructure Tester
2. B. Oracle Application Testing Suite
3. C. SQL Developer
4. D. Oracle Real Application Testing
5. E. APEX and SQL Developer
6. F. Oracle Testing Pack

Correct Answer: BD

At the IT Manager request, you are reviewing the databases that the DBA has implemented. You findSTATISTICS_LEVELconfigured asBASIC. What finding do you report back to the IT Manager?

1. A. The configuration of their databases is set up to also provide timed Operating System statistics and planexecution statistics.
2. B. The configuration of their databases is incorrect and should be set toNOT_TYPICAL.
3. C. The configuration of their databases has disabled collection of important statistics required for OracleDatabase functionality.
4. D. The configuration of their databases needs to be set toALLto enable collection of Operating System, Middleware, and storage statistics.

Correct Answer: C