aiotestking uk

1Z0-417 Exam Questions - Online Test


1Z0-417 Premium VCE File

Learn More 100% Pass Guarantee - Dumps Verified - Instant Download
150 Lectures, 20 Hours

Q1. Which statement about Oracle Enterprise Manager Database Expressis correct? 

A. Oracle Enterprise Manager Database Control must be configured first. 

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

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

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

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

Answer:

Reference: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/2day_dba/gettingstart ed/ gettingstarted.htm 

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

Answer:

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

A. XA transactions 

B. Oracle Call Interface (OCI) based object navigations 

C. SQL-based object access 

D. Flashback queries 

E. Database Resident Connection Pooling (DRCP) 

Answer:

Reference: https://docs.oracle.com/cd/E11882_01/server.112/e41481/dbr_capture.htm#RATUG115 

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

A. SQL Tuning Pack for Oracle Database 

B. Oracle Tuning Pack for Oracle Database 

C. Oracle Performance Pack for Oracle Database 

D. Oracle Diagnostics Pack for Oracle Database 

E. Oracle Real Application Testing 

F. Oracle SQL Developer 

G. STATSPACK 

Answer: B,D,E 

Reference: http://www.oracle.com/partners/en/most-popular-resources/db-performance-tuning-study-guide2138991.pdf (See page #03, Application product technology subject areas include). 

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

Answer:

Q6. At the IT Manager request, you are reviewing the databases that the DBA has implemented. You findSTATISTICS_LEVELconfigured asBASIC. What finding do you report back to the IT Manager? 

A. The configuration of their databases is set up to also provide timed Operating System statistics and planexecution statistics. 

B. The configuration of their databases is incorrect and should be set toNOT_TYPICAL. 

C. The configuration of their databases has disabled collection of important statistics required for OracleDatabase functionality. 

D. The configuration of their databases needs to be set toALLto enable collection of Operating System, Middleware, and storage statistics. 

Answer:

Q7. A customer seeks capability to measure and test database performance before and after application changes. Which would you implement to meet that requirement? 

A. Oracle Performance Analyzer 

B. Oracle Application Performance Analyzer 

C. Oracle Real Application Testing 

D. Oracle SQL Developer 

E. Oracle Spatial and Graph 

Answer:

Q8. When managing multiple database instances on a single server, which initialization parameter limits the number of CPU's that an instance can use simultaneously? 

A. CPU_NUM 

B. NUM_CPU 

C. MAX_CPU 

D. LIMIT_CPU 

E. CPU_COUNT 

Answer:

Reference: http://docs.oracle.com/html/E25494_01/dbrm008.htm 

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

Answer: B,C,D 

Q10. Oracle databases come with a built-in health monitor to run diagnostic checks on components of the database. Which three capabilities can be used to automate reporting? 

A. variety of real-time reports once the Business Intelligence option is installed 

B. reports in response to critical errors 

C. reports with findings and recommendations to resolve problems 

D. reports examining memory and process usage 

E. historical reports after the Database Diagnostic Repository (DDR) is configured 

F. reports examining user and developer SQL programming errors 

Answer: B,E,F