READ Free Dumps For Oracle- 1z0-058
| Question ID 2021 | You need to set up a three-Instance RAC database. The data files and fast recovery area will be stored in ASM diskgroups called +data and +fra, respectively. The ASM disk groups will be mounted on all ASM Instances. |
| Option A | A. Cluster File System with each instance writing to a shared location |
| Option B | B. Cluster File System with each instance writing to a separate location as long as all the locations are in directories under the same mount point |
| Option C | C. the ASM diskgroup +fra with the db_recovery_file_dest parameter set to the same value on all instances |
| Option D | D. a raw or block device |
| Correct Answer | A,C |
| Question ID 2022 | Which two statements are true regarding the Automatic Workload Repository (AWR) In a RAC |
| Option A | A. The AWR includes time model statistics based on time usage for activities displayed In the VSSYS_TIME_MODEL and VSSESS_TIHE_HODEL views. |
| Option B | B. The AWR is controlled by the statistics_level initialization parameter and it must be set to TYPICAL or BASIC |
| Option C | C. The Manageability Monitor Processes (MMON) process gathers statistics every hour from every instance and creates an AWR snapshot and stores it In the SGA. |
| Option D | D. The MMON process gathers statistics from its' own instance and kicks off statistics collection form other instances every hour from other instances and creates an AWR snapshot which is written to the sysaux tablespace. |
| Correct Answer | A,D |