1Z0-417 | All About Precise 1Z0-417 pdf
Q31. 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 7-10gdatabases.
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.
Answer: A,E,F
Q32. 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: E
Reference: http://docs.oracle.com/html/E25494_01/dbrm008.htm
Q33. When planning an Oracle Database architecture, which are three caching functionalities that would improve application response time and speed up query processing?
A. Result Cache
B. Mega Cache
C. Oracle In-Memory Database Cache
D. Database Smart Flash Cache
E. Oracle In-Memory DBSTATS Cache
Answer: A,C,D
Q34. SQL Access Advisor takes database workload as input and recommends adding various access structures. Which three does it consider the impact of adding when it generates recommendations?
A. Materialized views
B. Indexes
C. Partitions
D. Tablespaces
E. V$ performance views
F. Hints
Answer: B,D,E
Q35. Which option do customers need to license in order to implement SQL Performance Analyzer and Database Replay functionalities?
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 SQL Tuning Pack for Oracle Database
Answer: D
Reference: https://docs.oracle.com/cd/B19306_01/license.102/b14199/options.htm
Q36. 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.
Answer: A
Q37. A customer not familiar with Active Session History (ASH) asked you what it was used for. Which are two statements you can use to accurately describe (ASH) capabilities?
A. It enables you to conduct performance analysis of long-running sessions.
B. It enables you to conduct performance analysis of transient issues.
C. In memory, active sessions are sampled every second.
D. It accesses database kernel structures indirectly via the buffer cache.
E. It enables you to look at all database sessions since the database was created.
Answer: A,C
Reference: http://docs.oracle.com/cd/B19306_01/server.102/b28051/tdppt_method.htm#TDPPT015
Q38. 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
Answer: A,B,C
Q39. 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: C
Reference: https://docs.oracle.com/cd/E11882_01/server.112/e41481/dbr_capture.htm#RATUG115
Q40. Starting with Oracle Database 11gR2, which are two additional partitioning capabilities that aid Oracle Database Performance and Tuning?
A. Hash Partitioning
B. Reference Partitioning
C. Composite Partitioning
D. Interval Partitioning
E. Disk Partitioning
Answer: C,D