READ Free Dumps For Oracle- 1z0-062
| Question ID 2380 | Which three statements are true about Automatic Workload Repository (AWR)? |
| Option A | A. All AWR tables belong to the SYSTEM schema. |
| Option B | B. The AWR data is stored in memory and in the database. |
| Option C | C. The snapshots collected by AWR are used by the self-tuning components in the database |
| Option D | D. 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. |
| Option E | E. AWR contains system wide tracing and logging information. |
| Correct Answer | B,C,E |
| Question ID 2381 | You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). |
| Option A | A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM. |
| Option B | B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users. |
| Option C | C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No. |
| Option D | D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes. |
| Option E | E. Re-create the password file in the Oracle Database 12c format. |
| Correct Answer | B,D |
