1Z0-417 Online Practice Questions and Answers

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.

As of Oracle Database 12c, which functionality to access database diagnostic and performance has been superseded by Oracle Enterprise Manager Database Express?

A. SQL Developer

B. SQL Plus

C. Database console

D. SQL Express

E. Grid Control

When preparing a new database installation, you want to ensure automatic collection of timed statistics. Which three configuration parameters are applicable?

A. STATISTICS_LEVEL parameter set to TYPICAL

B. STATISTICS_LEVELparameter set to All

C. TIMED_STATISTICSparameter set to true

D. ALL_TIMED_STATISTICSparameter set to TRUE

E. AUTO_STATSparameter set to TRUE

F. STATISTICS_LEVELparameter set to BASIC.

Which are two kinds of statistics collected and processed by the Automatic Workload Repository (AWR) you would utilize when tuning an Oracle Database instance?

A. Wait Event statistics

B. Session and System statistics

C. User privileges statistics

D. Standby Database throughput statistics

E. Interconnect statistics

What two statements are true when you are using SQL Tuning Advisor and create a SQL Profile to improve performance of a SQL statement issued by a packaged application?

A. You need to regularly run SQL Tuning Advisor to verify if the SQL Profile can be replaced with a better one.

B. After a SQL Profile is created, it will then run efficiently for the life of the database.

C. The SQL Profile rewrites the SQL Statement issued by theapplication so it appears to the Optimizer as aperfectly written SQL statement.

D. You can have only one SQL Profile active at one time for a single SQL statement.

E. You need Oracle Database 12c or later to use SQL Profiles.

F. SQL Profiles can be used for non-Oracle databases like Microsoft SQL Server, if the Tuning Pack islicensed.

To use Automatic Database Diagnostic Management capability on a database using a SQL script, command line, database views, or from a GUI, which option needs to be licensed?

A. Oracle Diagnostics Pack for Oracle Databases

B. Oracle Tuning Pack for Oracle Databases

C. Oracle Diagnostics and Tuning Pack for Oracle Databases

D. Oracle ADDM Pack

E. Nothing else needs to be licensed.

A customer asked you about Database Time (DB Time). Which are two correct statements you would include in your description of it?

A. It is the total time spent in database calls by all sessions in the database.

B. It is the total time spent in database calls by foreground sessions in the database.

C. It is the total time spent in database calls by background sessions in the database.

D. It includes non-idle wait time.

E. It is the overall response time.

F. It includes login, idle, background, and Zombie session wait time.

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

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

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.