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…

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…

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last…

Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.) A. An SPFILE is a binary file B. An SPFILE cannot reside on a client C. An SPFILE cannot contain static parameters D. An SPFILE can store…

You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue? (Choose two.) A. Disable automatic checkpoint tuning B. Check the size of the redo log file size and increase the…

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) A. The database automatically determines the extent-sizing…

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 A. Large Pool B. Redo Log Buffer C. Database Buffer Cache D.…

In which of the scenario will the DBA perform recovery? (Choose all that apply.) A. The alert log file is corrupted B. A tablespace is accidentally dropped C. One of the redo log members is corrupted D. A database user…

You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file. View the Exhibit and check the commands…

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…