Question No 1

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?

Choose the Choices:

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.

Question No 2

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

Choose the Choices:

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 clusters

Question No 3

Which three statements are true concerning the configuration of SNMP on an Exadata x5 or x6 Database Machine?

Choose the Choices:

All SNMP notifications from the storage server ILOMs are sent directly to the Automatic Service Request (ASR) manager.

Some SNMP notifications may be configured using the alter cell command on the storage servers.

The Database Machine internal Cisco Switch communicates directly with the Enterprise Manager agent via SNMP.

Some SNMP notifications from a storage server ILOM are sent directly to the management server (MS) process on the same storage servers.

All SNMP notifications from a database server ILOM are sent directly to the Automatic Service Request (ASR) manager.

All SNMP notifications from a database server ILOM are sent directly to the management server (MS) process on the same database server.

Question No 4

You have partitioned an X5 - 2 full rack into two four - node RAC clusters called CLUSA and CLUSB. No virtualization is used and the storage grid has not been partitioned. Which two set of files on which servers must be modified after connecting an Exadata storage expansion rack to your X5 - 2 Exadata Database Machine on the InfiniBand network so that the storage servers in the expansion rack are added to the storage grid?

Choose the Choices:

the CELLINIT.ORA files on the database servers in CLUSA

the CELLIP.ORA files on the database servers in CLUSA

the CELLINIT.ORA files on the database servers in CLUSB

the CELLIP.ORA files on all existing Exadata storage servers

the CELLIP.ORA files on the database servers in CLUSB

the CELLIP.ORA files on all newly added Exadata storage servers

Question No 5

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?

Choose the Choices:

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.

Practice Oracle 1Z0-070 Exam Questions

Question No 1

Question No 2

Question No 3

Question No 4

Question No 5

1Z0-070 Exam Features

1Z0-070 PDF Dumps