Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials: 1Z0-338

Which three mandatory tasks must be performed when configuring the Auto Service Request (ASR) Manager? (Choose three.)

A. verifying the ASR configuration

B. registering the ASR Manager

C. activating a node on the ASR Manager

D. installing the ASR software on each database server

E. setting up ASR SNMP traps in Enterprise Manager

Which three statements are true about Automatic Degree of Parallelism (Auto DOP) on Exadata? (Choose three.)

A. Auto DOP is enabled via the PARALLEL_M1N_TIME_THRESHOLD initialization parameter.

B. Oracle's Auto DOP algorithms calculate the Degree of Parallelism based on a table's block counts.

C. Auto DOP is disabled by default, and must be enabled before SQL statements can take advantage of its features.

D. Auto DOP, an exclusive feature in Exadata, allows the database optimizer to evaluate each statement and run it in parallel without special hints.

E. Auto DOP is enabled by default, starting with Oracle 11gR2 and later, which allows full use of its features.

F. The SQL statements that take advantage of Auto DOP can be identified by using data from Oracle Automatic Workload Repository (AWR) or Enterprise Manager's Monitored SQL Executions page.

The ipmi tool command is most commonly used to perform which two tasks?

A. To configure base networking and bonds within the Exadata server.

B. To power on a chassis from another system in Exadata machine.

C. To show the ILOM SP server event logs in details for a listing of components status on a particular machine.

D. To manage and maintain the Exadata storage servers and related cell commands.

E. To manage cluster components.