This certification validates practical skills in enterprise business systems, with emphasis on configuring processes, managing information, and supporting business outcomes. It is intended for professionals who implement or operate enterprise business systems.
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:
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?