Helping Hand Questions for 1z0-062

Oracle Database 12c: Installation and Administration Questions and Answers

Question 49

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

The DEGREE_OF_PARALLELISM parameter is set to AUTO.

You cannot have multiple SQL *Loader data files.

If no data file is specified, it assumes the data file to be .dat in the current directory and uses it.

You can have multiple bad files created when loading in parallel.

You can selectively load rows into a table based on a filter.

Question 50

Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

An AWR snapshot shows the SQL statements that are producing the highest load on the system, based on criteria such as elapsed time and CPU time.

AWR data is stored in memory and in a database.

All AWR tables belong to the SYSTEM schema.

The manageability monitor (MMON) process gathers statistics and creates an AWR snapshot that is used by the self-tuning components in a database.

An AWR snapshot contains system-wide tracing and logging information.

Question 51

To enable faster incremental backups, you enabled block change tracking for the database.

Which two statements are true about the block change tracking file? (Choose two.)

Multiple change tracking files can be created for a database.

The change tracking file must be created after the first level 0 backup.

RMAN does not support backup and recovery of the change tracking file.

The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

Question 52

Which two statements are true about using SQL*Loader? (Choose two.)

It can load data from external files by using the direct path only.

It can load data into multiple tables using the same load statement.

It can load data into only one table at a time.

It can generate unique sequential key values in specified columns.

It can load data from external files by using the conventional path only.