Oracle 1Z0-417 Online Practice Questions and Exam Preparation

Oracle 1Z0-417 Online Questions & Answers

• Question 1:

  When planning Oracle Database Architecture, which option can be used to reduce the number of Oracle processes waiting in the Operating System run queue and to ensure that database CPU load is healthy?

  A. Exadata
  B. Oracle Job Scheduler
  C. DATABASE_MAXCPUS=YES
  D. Oracle Database Resource Manager
  E. DB_RAC_MAXCPU=YES
  F. Oracle Grid Control
  D. Oracle Database Resource Manager

• Question 2:

  DBAs use scripts and a third-party tool that access Automatic Workload Repository (AWR) snapshot reports, but don't use Oracle Enterprise Manager. The IT Manager seeks to confirm what the DBAs told him - Its OK since they licensed Oracle Database Enterprise Edition and not the Standard Edition. Which is the correct response for this scenario?

  A. With an Oracle Enterprise Edition Database license, a customer can use any Oracle option they want, atany of their worldwide locations, without additional licensing.
  B. No matter how AWR snapshot reports are accessed, Oracle Enterprise Edition Database customers needto be licensed for the Oracle Diagnostic Pack for Oracle Databases.
  C. With an Oracle Database Enterprise Edition license, an Oracle customer can use any Oracle option theywant, at that location, without additional licensing.
  D. No matter how AWR snapshot reports are accessed, Oracle Enterprise Edition Database customers needtobe licensed for the Advanced Analytic Pack for Oracle Databases.
  E. With an Oracle Database Enterprise Edition license, an Oracle customer can access AWR snapshots byusing SQL. If you use anything else, then you need an additional license.
  C. With an Oracle Database Enterprise Edition license, an Oracle customer can use any Oracle option theywant, at that location, without additional licensing.

• Question 3:

  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
  C. Oracle Migration Pack for Databases

• Question 4:

  Starting with Oracle Database 11gR2, which are two additional partitioning capabilities that aid Oracle Database Performance and Tuning?

  A. Hash Partitioning
  B. Reference Partitioning
  C. Composite Partitioning
  D. Interval Partitioning
  E. Disk Partitioning
  C. Composite Partitioning
  D. Interval Partitioning

• Question 5:

  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 6:

  Which two would automatically create an entry inV$SQL_MONITOR?

  A. a parallelized SQL statement
  B. any SQL statement run
  C. any DML statement
  D. a statement that consumes at least 1 second of CPU or I/O time.
  E. a statement that consumes at least 5 second of CPU or I/O time.
  F. any DDL statement
  C. any DML statement
  F. any DDL statement

• Question 7:

  Instead of a database automatically publishing statistics when statistics collection ends, you want to test queries a satisfactory result before they are made available to the entire database. Which would you configure for that to occur?

  A. SetOPTIMIZER_USE_PENDING_STATISTICStoTRUE.
  B. SetAUTO_UPDATE_STATISTICStoFALSE.
  C. Use aHOLD HINTin the SQL.
  D. SetAUTOMATIC_WORKLOAD_REPOSITORY_COLLECTIONtoPAUSE.
  A. SetOPTIMIZER_USE_PENDING_STATISTICStoTRUE.

• Question 8:

  Reviewing Automatic Workload Repository (AWR) reports for CPU and I/O exceptions, the time model displays SQL execution elapsed time as a major component of DB Time. Which two are next steps to diagnose the problem further?

  A. Review Operating System processes for any zombies.
  B. Review SQL statistics from the Automatic Workload Repository (AWR).
  C. Run a STATSPACK report.
  D. Review Automatic Database Diagnostic (ADDM) recommendations.
  E. Review all system configuration parameters.
  C. Run a STATSPACK report.
  D. Review Automatic Database Diagnostic (ADDM) recommendations.

• Question 9:

  You need to load SQL statements from a time period of optimal performance to compare against a time period that performance was reported as poor. Which functionality would you use to accomplish that task?

  A. Optimizer Statistics Comparator
  B. Dynamic Baseline Advisor
  C. Automatic Workload Repository Baselines
  D. SQL Tuning Sets
  E. Database Replay
  D. SQL Tuning Sets

• Question 10:

  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
  B. simulate Exadata on existing hardware
  C. forecast impact of a system change on aSQL workload
  E. debug SQL code syntax before and after a change