Which three can be performed on a Data Pump type external table? (Choose three.)

• A. partitioning the table
• B. creating a view on the table
• C. creating a public synonym for the table
• D. creating an invisible index on the table
• E. performing a CREATE TABLE AS SELECT (CTAS) to populate the table
• F. updating the table using an UPDATE statement

Which three statements are true about SQL plan directives?

• A. They instruct the optimizer to create only column group statistics.
• B. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.
• C. They are tied to a specific statement or SQL ID.
• D. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.
• E. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.
• F. They are used to gather only missing statistics.

Which three statements are true concerning unplugging a pluggable database (PDB)?

• A. The unplugged PDB can be plugged into another CDB.
• B. The PDB data files are automatically removed from disk.
• C. The unplugged PDB can be plugged into the same multitenant container database (CDB)
• D. The PDB must be open in read only mode.
• E. The PDB must be dosed.
• F. The unplugged PDB becomes a non-CDB.

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.

• A. Undersized shared pool
• B. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter
• C. Missing or stale histogram statistics
• D. Oversized buffer cache
• E. High clustering factor for the indexes

You must configure Oracle Data Redaction for the EMP table to satisfy the following requirements:
- RANDOM redaction on the SAL and COMM columns
- PARTIAL redaction on the HIREDATE column
- FULL redaction on the MGR column
What would you define to implement this?

• A. one redaction policy on the table, which specifies the redaction types for all table columns that must be redacted
• B. several redaction policies, with one redaction policy for each table column that must be redacted
• C. several redaction policies, with one redaction policy foe each data type defined for the table must be redacted
• D. several redaction policies, with each redaction policy specifying the redaction for table columns of that redaction type