You notice that the performance of the database has degraded because of frequent
checkpoints. Which two actions resolve the issue? (Choose two.)
Identify the memory component from which memory may be allocated for: Session memory
for the shared serverBuffers for I/O slavesOracle Database Recovery Manager (RMAN)
backup and restore operations
You executed the following command to create a tablespace called SALES_DATA: SQL>
CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE
MANAGEMENT AUTO; Which two statements are true about the SALES_DATA
tablespace? (Choose two.)
In which of the scenario will the DBA perform recovery? (Choose all that apply.)
You want to enable archiving on your database. Presently, the database is running in
NOARCHIVELOG mode. Given below are the steps to accomplish the task in random order:
1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3.
Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST
initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the
correct sequence of steps for accomplishing the task
Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET=0 LOG_CHECKPOINT_INTERVAL=0 Which two will be
the implications of these values in your database? (Choose two.)
In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.
What is the impact of this setting?
You have recently collected statistics on certain objects of a schema in your database. But
you observe suboptimal execution plans for the queries on these objects after two days of
statistics collection. The optimizer statistics retention period is set to its default value. Which
action would help to use the previous set of statistics on the objects?