1z0-062 Exam Dumps - Oracle Database 12c: Installation and Administration
An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache.
How would you guarantee that the blocks for the table never age out?
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.
What should you use to achieve this?
Which two must be installed or configured either manually or by DBCA in order to use Enterprise Manager
Database Express (EM Express)? (Choose two.)
A senior DBA asked you to execute the following command to improve performance:
SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);
You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.
What could be a reason for this recommendation?
Automatic Shared Memory Management (ASMM) is enabled for your database instance. You execute the following command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true?
In one of your databases, unified auditing is enabled and an SH.SALES table exists.
You can successfully execute these commands:
Which statement is true about SALES_POL?
Which component resides in the System Global Area (SGA) of a database instance only in shared server connections?
Which two tools can be used to configure static service information in the listener.ora file? (Choose two.)