Free Oracle 1z0-417 Exam Dumps Questions & Answers

Which background process performs Automatic Workload Repository (AWR) tasks such as writing when a metric violates its threshold value, taking snapshots, and capturing statistics for recently modified SQL objects?

• A.  LGWR
• B.  DBWR
• C.  MMON
• D.  MMNL
• E.  CKPT

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.  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.
• E.  No matter how AWR snapshot reports are accessed, Oracle Enterprise Edition Database customers needtobe licensed for the Advanced Analytic Pack for Oracle Databases.

For which use case would you utilize SQL Performance Analyzer and optimizer pending statistics functionality?

• A.  to test performance after a database upgrade
• B.  to test performance after an upgrade to an Oracle Real Application Cluster
• C.  to test effect of new Optimizer statistics
• D.  to test performance of an Operating System patch
• E.  to test performance just after a database reboot

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

• A.  It is recommended for Production environments, but not for Development or QA.
• B.  It is applicable for Oracle Database 12c and later versions.
• C.  It is available for Oracle Database Standard and Enterprise Editions.
• D.  It is delivered with Oracle Engineered Systems.
• E.  It builds on capabilities built into Oracle databases.

Which three are controllable by a resource plan, when you are using the Oracle Database 12c Multitenant option?

• A.  CPU
• B.  network I/O
• C.  use of SGA memory and ability to allocate PGA
• D.  concurrent sessions
• E.  ability to use parallel server processes
• F.  SGA