1Z0-417 Online Practice Questions and Answers

Upon migration to Oracle Database 12c, a customer asked that monitoring at an individualdatabase level be disabled in favor of database performance monitoring consolidated and centralized across their enterprise.

Which are two actions you would take to meet the customer's requirements?

A. Disable Oracle Enterprise Manager Database Express by setting the HTTP Port to 0.

B. For the always active Oracle Enterprise Manager Database Express process, create a script that willdisable that process upon database boot.

C. Using the appropriate architectureimplement Oracle Enterprise Manager.

D. Delete the "express" directory in Oracle Home to disable Oracle Enterprise Manager Database Express.

E. Changes permissions of the "express" directory to real only by root.

F. Enable SNMP and configure MIBS on each databaseand forward database monitoring SNMP traps.

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

Which statement is true about implementation of an Oracle Database Performance and Tuning solution?

A. It is available for Oracle Database Standard and Enterprise Editions.

B. It is applicable for Oracle Database 12c and later versions.

C. It builds on capabilities built into Oracle databases.

D. It is recommended for Production environments, but not for Development or QA.

E. It is delivered with Oracle Engineered Systems.

Which two situations help to identify that a customer as already using Oracle Diagnostics Pack for Oracle Database functions?

A. The customer has Enterprise Manager installed on a separate server and regularly accesses the Databasehome page of some of its Enterprise Edition databases from its console.

B. A customer says that he or she doesn't use Enterprise Manager, but you learn that the customer routinelyexecutesawrrpt.sqlfrom the SQLPlus prompt.

C. A customer has theCONTROL_MANAGEMENT_PACK_ACCESSinitialization parameter set toDIAGNOSTIC +TUNING.

D. A customer says that he or she doesn't use Enterprise Manager, but you learn that the customer has SQLscripts that access theDBA_HIST_ACTIVE_SESS_HISTORYdatabase view.

E. A customer says that he or she doesn't use theEnterprise Manager, but you learn that the customer usescustomized SQL scripts that accessV$SESSIONandV$SQLviews.

When performing performance analysis of Oracle Real Application Cluster (RAC) databases, what are three Automatic Database Diagnostics Monitoring (ADDM) analysis modes that are available?

A. Database

B. Instance

C. Partial

D. Sample

E. Average

Which two statements are true about Oracle Enterprise Manager Database Express?

A. It uses internal infrastructure components, such as XDB and SQL*NET.

B. It can perform actions inside and outside the database.

C. Performance Hub and Composite Active Reports are its key functionalities.

D. It is not supported on Oracle Standard Edition or Express Edition.

E. It replaces Oracle Grid Control.

When reviewing a customer's database configuration, you find thatOPTIMIZER_USE_SQL_PLAN_BASELINESis set asTRUE. What does the Optimizer do?

A. compares plans that itdevelops with accepted plans in baselines

B. develops plans and adds them to baselines as verified

C. doesn't develop an execution plan, but uses an accepted plan from baselines

D. doesn't develop an execution plan, but uses enabled plans in the baseline

You have been asked to provide a "technology update" to a long time Oracle Database customer. During the meeting, you are asked about Oracle Enterprise ManagerDatabase Express in Oracle Database 12c.

Identify three of its capabilities you would share with the customer.

A. Once Oracle Database 12c is installed, a DBA runs the separate Oracle Enterprise Manager DatabaseExpress installer to add it into the database console.

B. The Oracle Enterprise Manager Database Express Performance HUB organizes and provides aconsolidated viewof real-time and historical performance data.

C. The Database Express Performance HUB displays Oracle RAC specific metrics.

D. Oracle Enterprise Manager Database Express can be extended by the user to also display Oracle 710gdatabases.

E. Oracle Enterprise Manager Database Express does not require any separate middle-tier componentsbecause it uses XDB and SQL*NET.

F. The Oracle enterprise Manager Database Express Performance Hub displays Oracle RAC specific metricswhen the optional RAC Pack is licensed.

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.

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