Oracle Upgrade to Oracle Database 12c : 1Z1-060

Which three statements are true about Flashback Database?

• A. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
• B. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
• C. Flashback Database uses a restored control file to recover a database.
• D. Flashback Database can recover a database to the state that it was in before a reset logs operation.
• E. Flashback logs are written sequentially, and are archived.
• F. Flashback Database can recover a data file that was dropped during the span of time of the flashback.

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

• A. The snapshots collected by AWR are used by the self-tuning components in the database
• B. All AWR tables belong to the SYSTEM schema.
• C. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
• D. AWR contains systemwide tracing and logging information.
• E. The AWR data is stored in memory and in the database.

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).
Examine the query and its output:

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKMprivilege to the password file?

• A. Re-create the password file in the Oracle Database 12c format.
• B. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to Yes.
• C. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
• D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
• E. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

You notice that the elapsed time for an important database scheduler Job is unacceptably long.
The job belongs to a scheduler job class and window.
Which two actions would reduce the job's elapsed time?

• A. Moving the job to an existing higher priority scheduler window with the same schedule and duration
• B. Increasing the job's relative priority within the Job class to which it belongs
• C. Increasing the priority of the job class to which the job belongs
• D. Increasing the priority of the scheduler window to which the job belongs
• E. Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window
• F. Increasing the value of the JOB_QUEUE_PROCESSES parameter

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. several redaction policies, with one redaction policy foe each data type defined for the table must be redacted
• B. several redaction policies, with each redaction policy specifying the redaction for table columns of that redaction type
• C. several redaction policies, with one redaction policy for each table column that must be redacted
• D. one redaction policy on the table, which specifies the redaction types for all table columns that must be redacted