Get Certified for Mnc Companies
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...
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...
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...
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...
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....
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:...
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...
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...
The HR user owns the BONUSES table HR grants privileges to the user TOM by using the command:SQL> GRANT SELECT ON bonuses TO tom WITH GRANT OPTION;TOM then executes this command to grant privileges...
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...
