Which two are functionalities of Oracle Real Application Testing?
A. Database Replay
B. SQL Query Sets (SQS)
C. SQL Tuning Analyzer
D. SQL Performance Analyzer (SPA)
E. Real Application Cluster Replay
What are three activities an Oracle Database Performance and Tuning solution enables a customer to perform?
A. standardize database troubleshooting and diagnostics
B. control database clouds.
C. automate database performance management
D. perform global database backup
E. outsource database operations
F. replay and test actual workloads to assure database performance and consolidatios.
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 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 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
Which is Oracle's architecture and methodology for Oracle Database High Availability (HA)?
A. High Availability High Accessibility Architecture for Oracle Database
B. Oracle Real Application Clusters
C. Maximum Availability Architecture for Oracle Database
D. Oracle Exadata
E. Oracle Database 12c
When planning Oracle Database Architecture, which option can be used to reduce the number of Oracle processes waiting in the Operating System run queue and to ensure that database CPU load is healthy?
A. Exadata
B. Oracle Job Scheduler
C. DATABASE_MAXCPUS=YES
D. Oracle Database Resource Manager
E. DB_RAC_MAXCPU=YES
F. Oracle Grid Control
Upon implementation completion, which three should be reviewed with a customer to confirm the values or benefits of a Oracle Database Performance and Tuning solution?
A. real-time and historical monitoring capabilities
B. non-intrusive metric collections
C. statspack integration and support
D. integration with Enterprise Manager
E. included scripts for querying X$ and V$ views
F. SQL script code management capabilities
Which issue can be avoided by configuring the PCTFREE parameter?
A. row chaining and setting it has been superseded by Automatic Segment Space Management
B. table fragmentation, and has been superseded by Automatic Storage Management
C. column fragmentation
D. sort operations on disk
E. keeping a reserve area for backup
