Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. 

Currently, the database is running with peak workload. 

You want to analyze some of the most resource-intensive statements cached in the library cache. 

What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

Which two statements are true about availability audit features after migration to unified auditing? (Choose two.)

Which three statements are true about Database Resource Manager? (Choose three.)

What is the effect of setting the STATISTICS_LEVEL initialization parameter to BASIC?

Examine the parameter settings in your local ORCL database (TABLE -1) : 

Examine the parameter settings for the remote SALES database (TABLE -2): 

As the SYS user, you issue the following command on ORCL: CREATE PUBLIC DATABASE LINK sales.us.example.com USING ‘sales1’; 

The sales1 tnsnames entry points to the sales database instance. 

Which two are requirements to ensure that you can successfully connect by using this database link? (Choose two.)

Which three are activities performed by SMON? (Choose three.)

You are administering a database that supports an OLTP workload. 

The default UNDO tablespace is a fixed size tablespace with the RETENTION NOGUARATNEE clause and undo retention set to 12 minutes.

 The user SCOTT queries a large table during peak activity. 

The query runs for more than 15 minutes and then SCOTT receives the following error: 

ORA-01555: snapshot too old 

Which is possible reason for this?

Which two statements are true about SQL *Loader Express Mode in an Oracle 12c database? (Choose two.)