READ Free Dumps For Oracle- 1z0-058
| Question ID 2099 | Assuming a RAC database called ORCL, select three statements that correctly demonstrate management actions for the AP service. |
| Option A | A. To start the AP service, execute: srvctl start service -d ORCL -s AP |
| Option B | B. To disable the AP service on the ORCL4 instance, execute: srvctl disable service -d ORCL -s AP -i ORCL4 |
| Option C | C. To stop the AP service, execute: srvctl stop service -s AP |
| Option D | D. To make ORCL5 a preferred instance for the AP service, execute: srvctl set service -d ORCL -s AP -i ORCL5 -r |
| Option E | E. To relocate the AP service from the ORCL5 instance to the ORCL4 instance, execute: srvctl relocate service -d ORCL -s AP -i ORCL5 -t ORCL4 |
| Correct Answer | A,B,E |
| Question ID 2100 | Which two actions in a warehousing RAC database may cause concurrent cross-instance calls leading to I/O contention? |
| Option A | A. truncate table statements |
| Option B | B. select statements referring to non-partitioned tables |
| Option C | C. drop table statements |
| Option D | D. insert statements where each instance inserts into different partitions of a partitioned table |
| Correct Answer | A,C |