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?
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?

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?

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?
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.
Identify three possible reasons for this.