Skip to main content

1Z0-417 Real Exam Questions

Oracle Database

82 questions available · Page 1 of 9

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

Which one is a type of user session and client request supported by Database Replay?

  1. A

    XA transactions

  2. B

    Oracle Call Interface (OCI) based object navigations

  3. C

    SQL-based object access

  4. D

    Flashback queries

  5. E

    Database Resident Connection Pooling (DRCP)

Show answer and explanation

Correct answer: C

Question 2 Single choice

Which is Oracle's architecture and methodology for Oracle Database High Availability (HA)?

  1. A

    High Availability High Accessibility Architecture for Oracle Database

  2. B

    Oracle Real Application Clusters

  3. C

    Maximum Availability Architecture for Oracle Database

  4. D

    Oracle Exadata

  5. E

    Oracle Database 12c

Show answer and explanation

Correct answer: B

Question 3 Multiple choice

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?

  1. A

    Review Operating System processes for any zombies.

  2. B

    Review SQL statistics from the Automatic Workload Repository (AWR).

  3. C

    Run a STATSPACK report.

  4. D

    Review Automatic Database Diagnostic (ADDM) recommendations.

  5. E

    Review all system configuration parameters.

Show answer and explanation

Correct answers: C, D

Question 4 Single choice

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?

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

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

  3. C

    With an Oracle Database Enterprise Edition license, an Oracle customer can use any Oracle option theywant, at that location, without additional licensing.

  4. D

    No matter how AWR snapshot reports are accessed, Oracle Enterprise Edition Database customers needtobe licensed for the Advanced Analytic Pack for Oracle Databases.

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

Show answer and explanation

Correct answer: C

Question 5 Single choice

Which statement about Oracle Enterprise Manager Database Expressis correct?

  1. A

    Oracle Enterprise Manager Database Control must be configured first.

  2. B

    The listener needs to be running for it to be accessed.

  3. C

    A Oracle Enterprise Manager Database Express WebLogic Server must be configured first.

  4. D

    Oracle Internet Application Server needs to be installed to use it.

  5. E

    Oracle Enterprise Manager Database Express can be used only from a command-line.

Show answer and explanation

Correct answer: A

Question 6 Single choice

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

  1. A

    Oracle Database Diagnostics Pack for Oracle Database

  2. B

    Oracle Database Replay and Testing Suite

  3. C

    Oracle SQL Developer

  4. D

    Oracle Real Application Testing

  5. E

    Oracle SQL Tuning Pack for Oracle Database

Show answer and explanation

Correct answer: D

Question 7 Multiple choice

Which two are functionalities of Oracle Real Application Testing?

  1. A

    Database Replay

  2. B

    SQL Query Sets (SQS)

  3. C

    SQL Tuning Analyzer

  4. D

    SQL Performance Analyzer (SPA)

  5. E

    Real Application Cluster Replay

Show answer and explanation

Correct answers: A, E

Question 8 Single choice

Which issue can be avoided by configuring the PCTFREE parameter?

  1. A

    row chaining and setting it has been superseded by Automatic Segment Space Management

  2. B

    table fragmentation, and has been superseded by Automatic Storage Management

  3. C

    column fragmentation

  4. D

    sort operations on disk

  5. E

    keeping a reserve area for backup

Show answer and explanation

Correct answer: A

Question 9 Single choice

Which action can beperformed by using Oracle Enterprise Manager Database Express Performance Hub?

  1. A

    View health status and performance of an Oracle Database instance via Database Control.

  2. B

    Launch and view STATSPACK reports.

  3. C

    View real-time and historical Oracle Database performance information.

  4. D

    View only real-time Oracle Database performance information.

  5. E

    View only historical Oracle Database performance information.

  6. F

    Consolidate ADDM, AWR, and ASH repositories within an enterprise and enable centralized performancereporting.

Show answer and explanation

Correct answer: C

Question 10 Multiple choice

When implementing an Oracle Database Performance and Tuning solution, which are three product technologies recommended for use as your base configuration?

  1. A

    SQL Tuning Pack for Oracle Database

  2. B

    Oracle Tuning Pack for Oracle Database

  3. C

    Oracle Performance Pack for Oracle Database

  4. D

    Oracle Diagnostics Pack for Oracle Database

  5. E

    Oracle Real Application Testing

  6. F

    Oracle SQL Developer

  7. G

    STATSPACK

Show answer and explanation

Correct answers: B, D, E