On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: 

$> sqlldr hr/hr@pdb table=employees 

Which two statements are true regarding the command? (Choose two.)

After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows: 

After changing the value, you notice that FULL redaction continues to redact numeric data with zero. 

What must you do to activate the new default value for numeric full redaction?

You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. 

The table does not have a primary key and is used by an OLTP application. 

Which technique will move the table and indexes while maintaining the highest level of availability to the application?

To implement Automatic Management (AMM), you set the following parameters: 

When you try to start the database instance with these parameter settings, you receive the following error message: 

SQL > startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. 

Identify the reason the instance failed to start.

You upgrade your Oracle database in a multiprocessor environment. 

As a recommended you execute the following script: 

SQL > @utlrp.sql 

Which two actions does the script perform? (Choose two.)

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. (Choose three.)

Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges? (Choose three.)

You notice a performance change in your production Oracle 12c database. 

You want to know which change caused this performance difference. 

Which method or feature should you use?