Oracle Oracle Certifications 1Z0-417 Questions & Answers

• Question 21:

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

  A. a Documented Set of X$ and V$ Query Scripts

  B. a Maximum Availability Architecture

  C. a Documented Performance Methodology

  D. capability to Cloud Burst

  E. a Documented Performance Response Method

  Correct Answer: B

• Question 22:

  Which option do customers need to license in order to implement SQL Performance Analyzer and Database Replay functionalities?

  A. Oracle Database Diagnostics Pack for Oracle Database

  B. Oracle Database Replay and Testing Suite

  C. Oracle SQL Developer

  D. Oracle Real Application Testing

  E. Oracle SQL Tuning Pack for Oracle Database

  Correct Answer: D

• Question 23:

  Which option would you use to capture workloads from one or more systems concurrently and then play them back?

  A. Automatic Workload Repository

  B. Enterprise Manager Cloud Control

  C. Consolidated Database Replay

  D. Consolidation Planner

  E. Workload Consolidator and Playback

  Correct Answer: C

• Question 24:

  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.

  Correct Answer: A

• Question 25:

  Which functionality should be used to recommend materialized views and view logs, indexes, SQL profiles,and partitions for a specific workload use?

  A. SQL Performance Analyzer

  B. Top SQL

  C. SQL Tuning Advisor

  D. SQL Access Advisor

  E. Workload Advisor

  Correct Answer: D

• Question 26:

  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

  Correct Answer: CDF

• Question 27:

  Which are two strategies to maintain performance and improve a table segment's compression ratio when you are using Advanced Row Compression on a table segment?

  A. Use smaller database block size.

  B. Use larger database block size.

  C. Use direct-path inserts wherepossible.

  D. IncreasePCTFREEon the table segment.

  E. Increase the size of the tablespace.

  Correct Answer: AE

• Question 28:

  Which product technology can assist an Application Developer to capture a full production workload and replay on a test system database?

  A. Oracle Database Diagnostics Pack for Oracle Database

  B. Oracle Database Replay and Testing Suite

  C. Oracle SQL Developer

  D. Oracle Real Application Testing

  E. Oracle Real Tuning Pack for Oracle Database

  Correct Answer: D

• Question 29:

  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

  Correct Answer: BCD

• Question 30:

  In an Active Session History report, which response is correct?

  A. 60 minutes of ASH data can be held in memory, so only 1 hour can be reported.

  B. 60 minutes of ASH data can be held in memory, but more than 1 hour can be reported.

  C. ASH data is available 24 hoursbecause AWR snapshots refresh every night.

  D. As ASH data is flushed every 60 seconds, you need to set up a snapshot withDBA_JOBSfor what you want to keep.

  Correct Answer: A