Which two actions resolve the issue?

You notice that the performance of the database has degraded because of frequentcheckpoints. Which two actions resolve the issue? (Choose two.) A. Check the size of the redo log file size and increase the size if it is small B. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor C. Decrease […]

Read More

Which two statements are true about the SALES_DATA tablespace?

You executed the following command to create a tablespace called SALES_DATA: SQL>CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACEMANAGEMENT AUTO; Which two statements are true about the SALES_DATAtablespace? (Choose two.) A. The database automatically determines the extent-sizing policy for thetablespace. B. The segments are automatically shrunk when the contents are removed from them. C. The […]

Read More

which of the scenario will the DBA perform recovery?

In which of the scenario will the DBA perform recovery? (Choose all that apply.) A. A database user terminates the session abnormally B. The hard disk on which the data files is stored is corrupted C. The alert log file is corrupted D. A tablespace is accidentally dropped E. One of the redo log members […]

Read More

Which is the correct sequence of steps for accomplishing the task

You want to enable archiving on your database. Presently, the database is running inNOARCHIVELOG 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_DESTinitialization parameter to $ORACLE_HOME/dest_1. 5. Open […]

Read More

What is the location of the alert_orcl.log file?

You want to check the details of few errors that users have reported. You search for thealert log file and execute few commands to find the location of the alert log file. View theExhibit and check the commands executed. What is the location of the alert_orcl.log file?See the Exhibit: A. ORACEL_HOME/rdbms B. ORACLE_BASE/diag/rdbms/orcl/orcl/trace C. ORACLE_BASE/diag/rdbms/orcl/alert […]

Read More

Which statements are true regarding the USERS tablespace?

Which statements are true regarding the USERS tablespace? (Choose all that apply.) Seethe Exhibit: A. A bitmap is used to record free extents B. Free extents information is managed within the tablespace C. Free extents information is managed in the SYSAUX tablespace D. The data dictionary tables are updated when extents are allocated or deallocated […]

Read More

Which two will be the implications of these values in your database?

Examine the values for the following initialization parameters:FAST_START_MTTR_TARGET=0 LOG_CHECKPOINT_INTERVAL=0 Which two will bethe implications of these values in your database? (Choose two.) A. Automatic checkpoint tuning will be disabled B. The MTTR advisor will be disabled C. The SGA advisor will be disabled D. Checkpoint information will not be written to the alert log file […]

Read More

What is the impact of this setting?

In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.What is the impact of this setting? A. Optimizer statistics are collected automatically. B. Only timed operating system (OS) statistics and plan execution statistics are collected. C. The snapshots for the Automatic Workload Repository (AWR) are not generated automatically. D. Snapshots cannot be collected […]

Read More

Which action would help to use the previous set of statistics on the objects?

You have recently collected statistics on certain objects of a schema in your database. Butyou observe suboptimal execution plans for the queries on these objects after two days ofstatistics collection. The optimizer statistics retention period is set to its default value. Whichaction would help to use the previous set of statistics on the objects? A. […]

Read More