Which task is performed by a background process in a database instance?

Which task is performed by a background process in a database instance? Question: Which task is performed by a background process in a database instance? Options: Connecting between a client process and a dispatcher Executing PL/SQL code Creating dedicated server connections Copying online redo log files to offline storage Correct Answer The Correct Answer for … Read more

Which statement is true regarding the DEFAULT profile?

Which statement is true regarding the DEFAULT profile? Question: Which statement is true regarding the DEFAULT profile? Options: The values assigned to the resource limits and password parameters in the default profile can be altered. A different DEFAULT profile can be created before each user in a database. It can be dropped and recreated. it … Read more

Which method or feature should you use?

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.Which method or feature should you use? Question: Which method or feature should you use? Options: Compare Period ADDM report AWR Compare Period report Active Session History (ASH) report Taking a new snapshot and comparing … Read more

Which statement is true about using the Export/lmport method for migrating data when upgrading to Oracle Database 12c?

Which statement is true about using the Export/lmport method for migrating data when upgrading to Oracle Database 12c? Question: Which statement is true about using the Export/lmport method for migrating data when upgrading to Oracle Database 12c? Options: It automatically restarts a Data Pump Export or Import job after a failure is connected and the … Read more

When does a database checkpoint occur?

When does a database checkpoint occur? Question: When does a database checkpoint occur? Options: When there is an online redo log switch. When a user session terminates abnormally. When a server process terminates abnormally. When the SHUTDOWN ABORT command is issued Correct Answer The Correct Answer for this Question is When there is an online … Read more

Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?

Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column? Question: Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column? Options: The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace. The … Read more

Which statement is true?

Examine the current value for the following parameters in your database instance:SGA_MAX_SIZE = 1024M SGA_TARGET = 700MDB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200MYou issue the following command to increase the value of DB_8K_CACHE_SIZE:SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;Which statement is true?*The SGA_TARGET parameter can be dynamically increased up to the value specified for the SGA_MAX_SIZE parameter, and … Read more

What happens to the sessions that are presently connected to the database Instance?

Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command:1snrctl > STOPWhat happens to the sessions that are presently connected to the database Instance?The listener is used when the connection is established. The immediate impact of stopping the listener will be that no new session … Read more

When is the UNDO_RETENTIGIl parameter value ignored by a transaction?

When is the UNDO_RETENTIGIl parameter value ignored by a transaction?References: https://docs.oracle.com/cd/B19306_01 /server.102/bl4231/undo.htm(undo retention) Question: When is the UNDO_RETENTIGIl parameter value ignored by a transaction? Options: when there are multiple undo tablespaces available in a database when the data file of the undo tablespace is autoextensible when the undo tablespace is of a fixed size and … Read more