READ Free Dumps For Oracle- 1z0-058
Question ID 2019 | You notice that there is a very high percentage of wait time for the ’enq:HW-contention’ event in your RAC database that has frequent insert operations. |
Option A | A. shorter transactions |
Option B | B. increasing sequence cache sizes |
Option C | C. using reverse key indexes |
Option D | D. uniform and large extent sizes |
Option E | E. automatic segment space management |
Option F | F. smaller extent sizes |
Correct Answer | D,E |
Question ID 2020 | You are managing RAC database with policy managed services. The database is started by using an SPILE. |
Option A | A. All initialization parameters must have identical settings on all instances. |
Option B | B. All instances in the cluster database use the same SPFILE. |
Option C | C. To change values for initialization parameters for an instance, you must log in to that instance. |
Option D | D. All initialization parameters for all instances can be changed from any instance In a RAC database. |
Correct Answer | B,D |