Oracle 1Z0-417 Online Practice Questions and Exam Preparation

Oracle 1Z0-417 Online Questions & Answers

• Question 1:

  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
  A. row chaining and setting it has been superseded by Automatic Segment Space Management

• Question 2:

  DBAs are spending an enormous amount of time trying to identify and fix SQL statements they are suspect have regressed as a result of system changes not documented by the Operations Team. What would you implement to resolve this problem?

  A. Complete Oracle Enterprise Manager suite
  B. SQL Performance Analyzer which helps predict and prevent SQL execution performance problems causedby environment changes
  C. SQL Plan Manager which uses system histograms to extrapolate future SQL execution performance
  D. Oracle Database Backup and Recovery
  E. Oracle SQL Developer, which helps develop and test the SQL prior to putting it into production
  B. SQL Performance Analyzer which helps predict and prevent SQL execution performance problems causedby environment changes

• Question 3:

  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
  A. CPU
  B. concurrent sessions
  E. ability to use parallel server processes

• Question 4:

  What are three reasons an implementation of an Oracle Database Performance and Tuning solution is superior to that of scripts or third-party tools?

  A. It is a part of the database, which means no added installations, configurations, extra user accounts,privilege granting, etc.
  B. It eliminates the need to reverify compatibility, upgrade third-party tools, or rewrite scripts after a patch ordatabase upgrade.
  C. It has the largest library of custom scripts and procedures and includes an assembly builder to maintainthem and add more.
  D. Results come from the Oracle Database Optimizer and not rules or heuristics trying to predict what theoptimizer may do.
  E. It is the most inexpensive tool in the market.
  B. It eliminates the need to reverify compatibility, upgrade third-party tools, or rewrite scripts after a patch ordatabase upgrade.
  D. Results come from the Oracle Database Optimizer and not rules or heuristics trying to predict what theoptimizer may do.
  E. It is the most inexpensive tool in the market.

• Question 5:

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

• Question 6:

  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
  D. SQL Tuning Set

• Question 7:

  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?

  A. Oracle Application Infrastructure Tester
  B. Oracle Application Testing Suite
  C. SQL Developer
  D. Oracle Real Application Testing
  E. APEX and SQL Developer
  F. Oracle Testing Pack
  B. Oracle Application Testing Suite
  D. Oracle Real Application Testing

• Question 8:

  Which one would SQL Access Advisor use as input to provide a recommendation on a partition or index?

  A. SQL Tuning Advisor
  B. Automatic Workload Repository
  C. Automatic Diagnostic Monitor
  D. SQL Tuning SetE. SQL Error
  A. SQL Tuning Advisor

• Question 9:

  Which option is recommended when gathering Optimizer system statistics on a regular basis to ensure optimal performance?

  A. lock out user sessions and gather system statistics overnight
  B. gather system statistics after a performance issue has been reported
  C. gather system statistics for several hours when there is no workload
  D. gather system statistics for several hours during normal workload periods
  E. shut down any running applications prior to collection
  D. gather system statistics for several hours during normal workload periods

• Question 10:

  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.
  D. ADDM and AWR are new features of Oracle Database 12c.