Question 116

In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.
How would you accomplish this?
  • Question 117

    In your multitenant container database (CDB) that contains pluggable databases (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:

    How can you prevent users having the EXECUTEprivilege on the CREATE_TESTprocedure from inserting values into tables on which they do not have any privileges?
  • Question 118

    Examine the following command:

    Which three statements are true about using an invisible column in the PRODUCTStable?
  • Question 119

    You are administering a database stored in Automatic Storage Management (ASM). You use RMANto back up the database and the MD_BACKUPcommand to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
    In which three ways can you re-create the lost disk group and restore the data?
  • Question 120

    You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.
    Identify three possible reasons for this.