Oracle Exadata X5 Administration

Here you have the best Oracle 1z0-070 practice exam questions

You have 88 total questions to study from
Each page has 5 questions, making a total of 18 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on October 12, 2025
This site is not affiliated with or endorsed by Oracle.

Question 1 of 88

Batch and DSS workloads on your Exadata X6 Database Machine are causing performance problems for OLTP workloads at certain times of the day.
There are five RAC databases performing OLTP I/O. Two of them also perform batch I/O. There is another RAC database that performs only DSS I/O.
You are asked to resolve this problem so that the OLTP workload will not suffer when competing with the batch or DSS workloads.
You decide to use the I/O resource manager.
Which is the best way to solve this problem?

Create a category plan with EXADCLI calling EXACLI to give the OLTP category the highest priority on all the cells, and use the Database Resource Manager to create the OLTP category and map all OLTP- oriented consumer groups in all databases to it.

Use the Database Resource Manager to give the OLTP category the highest priority and use EXADCLI calling EXACLI to create the OLTP category on all the cells.

Create a category plan with EXADCLI calling EXACLI to give the OLTP category the highest priority on all the cells, and use the Database Resource Manager to give the OLTP consumer group the highest priority on all databases.

Create a database plan using EXADCLI calling EXACLI to give OLTP I/O the highest priority from all six databases.

Correct Answer: C

Question 2 of 88

Identify three valid reasons for creating multiple griddisks on a single harddisk-based celldisk.

to implement storage realms so that storage that can be reserved for specific resource consumer groups in the same database

to enable the creation of normal or high redundancy ASM diskgroups

to segregate storage into multiple pools with different performance characteristics

to enable disk mirroring for the system area

to implement storage realms so that storage can be reserved for specific databases

to implement storage realms so that storage that can be reserved for specific Grid Infrastructure

Correct Answer: A, C, E

Creating multiple griddisks on a single harddisk-based celldisk can serve several purposes. First, it can help in implementing storage realms so that storage can be reserved for specific resource consumer groups within the same database, ensuring that different groups have dedicated storage resources (A). Additionally, it can segregate storage into multiple pools with different performance characteristics, allowing for better management and optimization of storage resources based on performance needs (C). Lastly, it allows for the implementation of storage realms so that specific databases can have dedicated storage, thereby enhancing organization and management of storage based on database requirements (E).

Question 3 of 88

You plan to monitor the status of the motherboard, memory, power, fans, and network cards on the database nodes in your Exadata X6 Database Machine using
Enterprise Manager.
Where must you set the thresholds for these hardware components and why, to assure that sensor readings, faults, and any related alerts, are visible in
Enterprise Manager?

No thresholds need to be set because they are present in the ILOM and in Enterprise Manager.

Set thresholds in ILOM and in Enterprise Manager because they are not present anywhere and must be set in both places.

Set thresholds only in ILOM because they are not preset anywhere but need to be set only in ILOM.

No thresholds need to be set because they are preset in the ILOM and these are sufficient for monitoring.

Correct Answer: D

Question 4 of 88

Examine this list of software components:
1. Oracle Virtual Machine (OVM)
2. Oracle Enterprise Manager Agent (OMA)
3. ASM instance
4. RDBMS instance
5. Automatic Diagnostic Repository Command Interpreter (ADRCI)
6. CELLCLI
7. Cell Server (CELLSRV)
8. diskmon
Identify the location where these software components can run in the standard Exadata Database Machine deployment.

1, 2, 3 and 4 run on the database servers; 5, 6, 7, and 8 run on the Exadata storage servers.

1, 2, 3, 4, 5, and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.

1, 2, 3, 4 and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.

3, 4 and 8 run on the database servers; 1, 2, 5, 6 and 7 run on the Exadata storage servers.

2, 3, 4 and 8 run on the database servers; 1, 5, 6 and 7 run on the Exadata storage servers.

Correct Answer: B

Question 5 of 88

Which two statements are true regarding the use of Auto Service Request (ASR) with an X6 Database Machine?

The database server ILOMs must use SMTP over the management network for notifications to ASR Manager.

The database server ILOMs must have SNMP traps configured to use the management network for notifications to ASR Manager.

The storage server ILOMs must have SNMP traps configured to use the management network for notifications to ASR Manager.

The database server MS process must have SNMP traps configured to use the management network for notifications to ASR Manager.

Correct Answer: B, C