Which three statements are true about the SQL*Loader utility? (Choose three.)

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?

Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.
You execute this command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true?

The CATDB12Cdatabase contains an Oracle Database 12c catalog schema owned by the RC12Cuser.
The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user.
A database with DBID=1423241is registered in the CATDB11catalog. Both the recovery catalog databases are open.
In the CATDB12cdatabase, you execute the commands:

What is the outcome of the import?

Your database is running in archivelog mode and a nightly backup of the database, along with an
autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the
control files are lost.
Examine the steps to restore the SPFILE and the control file to mount the database:
1. Set DBID of the target database in RMAN.
2. Start the database instance by using the startup force nomount command in RMAN.
3. Restore the control files from the backup.
4. Mount the database.
5. Restore the SPFILE from the autobackup.
6. Create a PFILE from the recovered SPFILE.
7. Restart the instance in nomount state.
Identify the required steps in the correct order.