Which two statements are true about hot patching as compared to conventional patching? (Choose two.)
You upgrade your Oracle database in a multiprocessor environment. As a recommended best practice, you execute the following script:SQL > @utlrp.sql -Which two actions does the script perform? (Choose two.)
Which statement is true concerning dropping a pluggable database (PDB)?
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.
Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges?
Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)
