Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; What would happen?()
You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privilegesand execute the following sequence statements:What is the result of the last SET CONTAINER statement and why is it so?()
You work as a database administrator for Certkiller .com. While setting up the database for your production environment, you want to create a user according to the requirements in the exhibit. Which three options of the CREATE USER command would you use to achieve this objective?()
The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?()
You executed the following commands in an RMAN session for your database instance that has failures: RMAN> LIST FAILURE; After some time, you executed the following command in the same session: RMAN> ADVISE FAILURE; But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution ofthe last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario()
Examine the following command that is used to duplicate a database on the same host: Which two statements describe the effect after the database is duplicated successfully? ()
You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?()
Examine the following values of the initialization parameters in the database having the SID ORCL: BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What is the location of the Automatic Diagnostic Repository (ADR) home?()
You work as a database administrator for Supportcenter.cn. You want to be notified when the number of disk I/O increases by 10% of what it was yesterday. You create a baseline metric for yesterday’s disk I/O performance. How do you use the baseline metrics to achieve your objective?()
You work as a database administrator for Certkiller .com. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users? ()