Tag «Exam 1z0-042 (v.1)»

What action would you take to achieve this?

You want to monitor and control the resource usage by sessions. You want to be warnedautomatically when more than 100 sessions are opened with your database. What action wouldyou take to achieve this? A.Set the warning threshold for the Current Logons Count metric. B.Set the limits in the profiles used by users. C.Use the Database …

Which statement regarding the contents of the V$PARAMETER view is true?

Which statement regarding the contents of the V$PARAMETER view is true? A.displays only the list of default values B.displays the current contents of the server parameter file C.displays the currently in effect parameter values D.displays the list of all the parameter files of a database E.displays only the list of all advanced parameters F.displays only …

Which command would you execute to proceed further?

Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, andarchiving has stopped. All the redo logs are filled and database activity is halted. Database writerhas written everything to disk. Which command would you execute to proceed further? A.ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2; B.RECOVER LOGFILE BLOCK …