Upgrade Oracle DBA 11g or 12c to 12c R2: 1Z0-074

Identify two types of files that are generated by the Pre-Upgrade Information tool as part of the database upgrade prerequisite checks? (Choose two.)

A. expdp scripts to export database objects belonging to the SYS schema

B. a log file containing a list of pre-upgrade patches to be applied

C. RMAN database backup scripts

D. a log file with tool recommendations and requirements

E. pre- and post-upgrade fixup scripts

You plan to use Information Lifecycle Management (ILM) for the ORDERS table.

Which is true about Heat Map statistics when HEAT_MAP is ON?

A. They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSTEM tablespace.

B. They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSAUX tablespace.

C. They are collected for all segments and are stored in the SYSAUX tablespace.

D. They are collected for all segments and are stored in the SYSTEM tablespace.

E. They are collected only for the ORDERS table if it has an associated ADO policy.

You log in to the ORCL database as SYSTEM and successfully execute these two blocks of code:

The SCOTT user has the SELECT privilege on HR.EMP.

Which statement is true about queries by non-DBA users with the SELECT privilege on HR.EMP?

A. All their queries display blanks for LAST_NAME and the true contents of the SALARY column.

B. Only SCOTT'S queries display the true contents of the SALARY column and blanks for LAST_NAME.

C. All their queries display blanks for LAST_NAME and zeroes for SALARY.

D. Only SCOTT'S queries display the true contents of the SALARY and LAST_NAME columns.

E. Only SCOTT'S queries display zero for SALARY and the true contents of the LAST_NAME column.