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

• A.Optimizer statistics are collected automatically.
• B.Only timed operating system (OS) statistics and plan execution statistics are collected.
• C.Automatic Workload Repository (AWR) snapshots are not generated automatically.
• D.The Oracle server dynamically generates the necessary object-level statistics on tables as part of query
  optimization.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about checkpointing? (Choose three.)

• A.It prompts the Database Writer (DBWn) process to write checkpoint information into data file headers and the control file.
• B.It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.
• C.It reduces the time required for recovery in case of an instance failure.
• D.It ensures that all dirty buffers are written to data files during consistent shutdown.
• E.Frequent thread checkpoints can degrade database performance.

Comment: *

Name: *

Email: *

Verification: *

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
The characteristics of the non-CDB are as follows:
- Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit
- Character set: AL32UTF8
- National character set: AL16UTF16
- O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
- Version: Oracle Database 12c Release 1 64-bit
- Character Set: AL32UTF8
- National character set: AL16UTF16
- O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

• A.Transportable database
• B.Transportable tablespace
• C.Data Pump full export/import
• D.The DBMS_PDB package
• E.RMAN

Comment: *

Name: *

Email: *

Verification: *

Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

• A.Reduced logical I/O
• B.Reduced virtual memory utilization
• C.Improved parallel Execution performance
• D.Improved Serial Execution performance
• E.Reduced physical I/O
• F.Reduced CPU utilization

Comment: *

Name: *

Email: *

Verification: *

In your Oracle 12c database, you invoke SQL *Loader Express Mode command to load data:
$> sqlldr hr/hr table=employees
Which two statements are true about this command? (Choose two.)

• A.It fails because the SQL *Loader control file location is not specified.
• B.It succeeds even if the HR user does not have the CREATE DIRECTORYprivilege.
• C.It fails because the SQL *Loader data file location is not specified.
• D.It succeeds and creates the EMPLOYEEStable in the HRschema if the table does not exist.
• E.It succeeds with default settings if the EMPLOYEEStable belonging to the HRschema is already defined
  in the database.

Comment: *

Name: *

Email: *

Verification: *