What Accurate 1Z0-027 Test Is

NEW QUESTION 1
Which is true regarding Enterprise Manager monitoring and configuration?

• A. Agents must be deployed on the- storage servers, in case all the database servers are down.
• B. Monitoring the power distribution units (PDUs) is done by Enterprise Manager agents, but additional ethernet cables are required to connect the PDUs to the internal network switch in the Database Machine
• C. Monitoring the power distribution units (PDUs) is done by Enterprise Manager agents without, any additional network configuration.
• D. Agents may be deployed on the storage servers, in case all the database servers are down.
• E. Monitoring the power distribution units (PDUS) is done by Enterprise Manager agents but additional ethernet cables are required to connect the PDUs to the corporate network switch.

Answer: C

Explanation:
Note:
* The following prerequisites must be met before you can deploy the plug-in:
* Set and validate the preferred credentials on all Agents where you want to deploy the plug- in. This is essential in order to deploy the plug-in.
The PDU firmware version must be 1.02 or later.
* This plug-in will be used to monitor PDU's actual current value of Phase1, Phase2, and Phase3 and raises appropriate events if they have crossed the different threshold values. Each PDU will have a plug-in instance added to its own OEM Grid Control agent.
By deploying the plug-in to your Grid Control environment, you gain the following management features:
Monitor PDU targets.
Raise alerts and violations based on thresholds set on monitoring and configuration data. Provide rich out-of-box metrics and reports based on the gather
Reference: Oracle Enterprise Manager System Monitoring Plug-In Installation Guide for
Exadata Power Distribution Unit

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

• A. Set thresholds in ILOM and in Enterprise Manager because they are not preset anywhere and must be set in both places
• B. Set thresholds only in ILOM because they are not preset anywhere but need only be set in ILOM.
• C. No thresholds need be set because they are preset in the ILOM and in Enterprise Manager.
• D. No thresholds need ho set because they are preset in the ILOM and these are sufficient for monitoring.

Answer: D

Explanation:
Note:
* The ILOM management interface is also integrated with Oracle Enterprise Manager Ops Center.
* ILOM Features and Functionality include: Remote hardware monitoring which include:
Monitor customer-replaceable units (CRUs) and fieldreplaceable units (FRUs), including power supplies, fans, host bus adapters (HBAs), disks, CPUs, memory, and motherboard
* The ILOM-based service processor (SP) receives error telemetry about error events that occur within the major system components on the host (CPU, memory, and I/O hub) and the environmental subsystem within the chassis (such as fans, power supplies, and temperature). The components and conditions are then diagnosed as fault events and captured in the ILOM event log.

NEW QUESTION 3
You are checking the status of the ports on the one of the InfiniBand switches in your Database Machine.
You have run the getportstatus as shown:

You have 36 ports to check.
Which two methods would you use to check the status of all 36 ports?

• A. Use Enterprise Manager.
• B. Use the ibqueryerros.pl script logged into the InfiniBand switch as root.
• C. Use Database Control.
• D. Create user-defined metrics for the InfiniBand switch.

Answer: AB

Explanation:
http://docs.oracle.com/cd/E17559_01/install.111/e20085/e20085-03.htm

NEW QUESTION 4
Your customer wants you to partition the database and storage grids in his X3-2 full rack, creating database clusters and two storage grids.
One cluster will be used for production and should consist of 6 databases servers and 11 cells from the first storage grid.
The other cluster will be used for test and development, and should consist of 2 database servers and 3 cells from the second storage grid.
The storage must be partitioned so that the cells are visible only to the appropriate database servers based on the description above.
What must be done to achieve this?

• A. Configure Exadata realms using Oracle ASM scoped security mode.
• B. Configure Exadata realms using Database scoped security mode.
• C. Edit the CELLIP.ORA file on each database server to contain IP addresses of cells in the storage grid associated with cluster to which that database server belongs.
• D. Edit the CELLINIT.ORA file on each database server to contain IP addresses of cells in the storage grid associated with the cluster to which that database server belongs.
• E. Edit the CELLIP.ORA file on each database server to contain IP addresses of database servers which are allowed access to specific cells in the same storage grid.
• F. Edit the CELLIP.ORA file on each cell to contain IP addresses of database servers in the database server grid that are associated with the storage grid to which that cell belongs.

Answer: C

Explanation:
cellip.ora
The cellip.ora is the configuration file, on every compute node, that tells ASM instances which cells are available to this cluster.
Here is a content of a typical cellip.ora file for a quarter rack system:
$ cat /etc/oracle/cell/network-config/cellip.ora cell="192.168.10.3"
cell="192.168.10.4" cell="192.168.10.5"
Now that we see what is in the cellip.ora, the grid disk path, in the examples above, should make more sense.
Note:
* cellinit.ora decides which network takes storage traffic.
* cellip.ora - list of cells, new cells can be added dynamically without shutdown

NEW QUESTION 5
Which two are Oracle recommendations for media based backups performed for a database running on a Database Machine?

• A. Allocate equivalent number of channels and instances per tape drive.
• B. Perform periodic level 0 backups and daily cumulative level-1 backups.
• C. Use the InfiniBand network between the database server and media server.
• D. Configure Recovery Manager (RMAN) channels to connect to the least loaded instances.
• E. Use InfiniBand network between the media server and the storage servers.

Answer: AC

Explanation:
A: Configure one RMAN channel per tape drive and add tape drives to scale backup rates. C: Configure the Preferred Network Interface (PNI) to direct the Oracle Secure Backup
traffic over the InfiniBand network interface.
Example:
ob> lspni (List Preferred Network Interface) mediaserver1:
PNI 1:
interface: mediaserver1-ib
clients: dbnode1, dbnode2, dbnode3, dbnode4, dbnode5, dbnode6, dbnode7, dbnode8
PNI 2:
interface: mediaserver1 clients: adminserver dbnode1:
PNI 1:
interface: dbnode1-ib clients: mediaserver1
Note:
* Using the Sun ZFS Backup Appliance as an Oracle RMAN backup target for an Oracle Exadata system delivers much faster backup and recovery, enabling organizations to achieve shorter recovery time objectives and shrink backup windows. The appliance is designed for high sustained read and write I/O performance, and it is connected to the Oracle Exadata system via a high-throughput InfiniBand network fabric.
* As the only unified storage vendor to support InfiniBand as a storage network for backup and restore operations, Oracle is leading the way with native high-bandwidth interconnects.
* The InfiniBand network provides 40 Gb of bandwidth per port between the database servers, storage cells, and the Sun ZFS Backup Appliance. Backup and restore operations can be automatically parallelized across all database nodes, Oracle Exadata storage cells, Sun ZFS Backup Appliance channels, and controllers.

NEW QUESTION 6
Which type of network traffic is transported over the internal InfiniBand network in a Database Machine?

• A. IDB protocol traffic only
• B. Both Clustered ASM and RAC database instance traffic
• C. Clustered ASM Instance traffic only
• D. RAC database instance traffic only
• E. IDB protocol traffic, Clustered ASM traffic, and RAC database instance traffic

Answer: E

NEW QUESTION 7
Yesterday, an Exadata storage server flashdisk entered the poor performance state.
This flashdisk os used by flashcache and has a griddisk which is a member of a normal redundancy diskgroup.
Identify the six steps you must perform to replace flashdisk.

• A. Identify the griddisk located on the poorly performing flashdisk and drop it from the associated ASm diskgroup.
• B. Verify that the griddisk located on the poorly performing flashdisk has been successfully dropped from the associated ASM diskgroup.
• C. Drop the flashcache on all cell.
• D. Safely power off the cell containing the poorly-performing flashdisk.
• E. Replace the poorly performing flashdisk.
• F. Power up the cell containing the replaced flashdisk and activate all griddisks.
• G. Recreate the flashcache on the cell using all flashdisks.
• H. Create a new griddisk on the replaced flashdisk.
• I. Add the griddisk back into the ASM diskgroup to which it belonged.

Answer: ADEFHI

Explanation:
Note:
* The default way to deal with the Flash Storage is to use it completely as Flash Cache. You may think of Flash Cache as a prolongation of the Database Buffer Cache. It is populated automatically by the system with objects deemed useful to cache them.
* The second possibility to deal with the Flash Storage is to take a part of it for building ASM diskgroups upon. All files on these ASM diskgroups will then reside permanently on Flash Storage:
CellCLI> drop flashcache
Flash cache exa5cel01_FLASHCACHE successfully dropped
CellCLI> create flashcache all size=100g
Flash cache exa5cel01_FLASHCACHE successfully created CellCLI> create griddisk all flashdisk prefix=flashdrive

NEW QUESTION 8
Which two statements are true about the IPTables firewall configuration on a Database Machine- Machine after the default Initial deployment?

• A. IPTables is configured with Oracle supplied rules on the cells.
• B. IPTables is configured with Oracle supplied rules on the database servers.
• C. IPTables is installed and available but not configured on any servers.
• D. IPTables is installed and available but not configured on the database servers.
• E. IPTables is installed and available but not configured on the cells.

Answer: AD

NEW QUESTION 9
Which two are true concerning the allocation of I/O resources by the IORM within the CELLSRV process?

• A. Control File I/O is managed automatically at high priority by IORM.
• B. Control File I/O is considered part of the SYSTEM resource Consume group by IORM.
• C. Log Writer I/O to the Smart Flash Log is considered part of the SYSTEM resource consumer group by IORM.
• D. Log Writer I/O to the Smart Flash Log is managed automatically at high priority by IORM.
• E. Database Writer I/O is managed automatically at normal priority by IORM.
• F. Database Writer I/O is considered part of the SYSTEM resource consumer group by IORM.

Answer: AE

Explanation:
Note:
* IORM Rules
IORM is only "engaged" when needed.
/ (A) Redo and control file writes always take precedence.
/ (E) DBWR (database writer) writes are scheduled at the same priority as user IO.
/ IORM does not intervene if there is only one active consumer group on one database.
/ Any disk allocation that is not fully utilized is made available to other workloads in relation to the configured resource plans.
/ Background IO is scheduled based on their priority relative to user IO.
/ For each cell disk, each database accessing the cell has one IO queue per consumer group and three background queues.
/ Background IO queues are mapped to "high", "medium", and "low" priority requests with different IO types mapped to each queue.
/ If no intradatabase plan is set, all non-background IO requests are grouped into a single consumer group called OTHER_GROUPS.
Reference: Using IORM with Exadata

NEW QUESTION 10
You plan to migrate an Oracle database that supports an online transaction processing (OLTP) workload to your Database Machine.
Following are details for the source database: Database version: 10.2.0
Byte order: Big Endian HP-UX (64-bit) Database size: 24 TB
Storage: ASM with 1 MB allocation unit size Which two are supported migration methods?

• A. Physical migration using ASM online Migration
• B. Physical migration using Transportable Database
• C. Logical migration using Oracle Streams
• D. Local migration using Oracle Streams
• E. Logical migration using logical standby

Answer: CE

Explanation:
There are several techniques for migrating data to a Database Machine. Migration can be done
using Oracle Recovery Manager (RMAN) to backup from traditional storage and restore the data
onto Exadata. Oracle Data Guard can also be used to facilitate a migration. This is done by first
creating a standby database based on Exadata storage. The standby can be using Exadata storage
and the production database can be on traditional storage. By executing a fast switchover, taking
just seconds, you can transform the standby database into the production database. This provides
a built-in safety net as you can undo the migration very gracefully if unforeseen issues arise.
Transportable Tablespaces (B) and Data Pump may also be used to migrate to Exadata.
Any
technique used to move data between Oracle Databases can be used with Exadata.

NEW QUESTION 11
Last weekend, an Exadata storage server flashdisk entered the predictive failure state.
The flashdisk is used by the flashcache and has a griddisk which is a member of a normal redundancy diskgroup.
Identify the four steps you must perform to replace this flashdisk.

• A. Identify the griddisk on the predictive failure flashdisk and drop it from the associated ASM diskgroup
• B. Verify that the griddisk located on the predictive failure flashdisk has been successfully dropped from the associated ASM diskgroup.
• C. Drop the flashcache on the cell and re-create it using all but the predictive failure flashdisk.
• D. Safely power off the cell containing the predictive failure flashdlsk.
• E. Replace the predictive failure flashdisk.
• F. Power up the cell containing the replaced flashdlsk and activate all grlddlsks.
• G. Drop the flashcache on the cell and re-create it using all flashdlsks.
• H. Create a new griddisk on the replaced flashdisk.
• I. Add the griddisk back into the ASM diskgroup to which it belonged.

Answer: ADEF

NEW QUESTION 12
Identify two permitted uses of external InfiniBand connections to a Database Machine.

• A. To connect an ExaLogic Elastic Cloud Machine
• B. To monitor the InfiniBand network using Enterprise Manager
• C. To connect an external tape library
• D. To use a bonded client access network
• E. To use a bonded management network

Answer: AC

Explanation:
A: Combining the Oracle Exalogic Elastic Cloud with the Oracle Exadata Database Machine for SAP NetWeaver
The InfiniBand fabric that spans Exalogic and Exadata components provides the following key ways of
simplifying and accelerating SAP NetWeaver installations running on Exalogic
Note: A high specialized database networking protocols connects all the components inside an Exadata Database Machine. External connectivity to the Exadata Database Machine is provided through standard 1 Gigabit and 10 Gigab Multiple X3 even larger configurations.

NEW QUESTION 13
Which three are true about Exadata storage server alerts?

• A. A threshold based alert gets cleared automatically when the measured value no longer violates the threshold.
• B. A storage server alert is only ever issued as a warning or at a critical situation.
• C. Storage server alerts are all stateless alerts.
• D. Storage server alerts notifications may be sent using SNMP.
• E. Storage server alerts are all stateful alerts.
• F. Storage server alerts notifications may be sent using SMTP.

Answer: ABD

Explanation:
Incorrect:
Not C, Not E: there are both stateful and stateless alerts

NEW QUESTION 14
Consider the following sequence of CELLCLI commands and SQL statements:

All CELLCLI commands and SQL statements are executed successfully without warnings. Which statement is true about the I/O performance of the DATA01 ASM diskgroups?

• A. The DATA01 diskgroups has better performance because the DATA01 griddisks were created first.
• B. The DATA02 ASM diskgroup has better performance because the DATA02 diskgroups was created first.
• C. The DATA01 diskgroup has better performance because the DATA01 griddisks are created on interleaved cell disks.
• D. The performance of both diskgroups is balanced because they are created on interleaved griddisks.

Answer: A

Explanation:
Griddisks are the fourth layer of abstraction, and they will be the Candidate Disks to build your ASM diskgroups from. By default (interleaving=none on the Celldisk layer), the first Griddisk that is created upon a Celldisk is placed on the outer sectors of the underlying Harddisk. It will have the best performance therefore
Incorrect:
Not D: non-interleaved is the default.

NEW QUESTION 15
Which three statements are true regarding the configuration of Auto Service Request (ASR) on your Database Machine?

• A. HTTPS connectivity must be enabled from the ASK Manager host to the internet.
• B. ASR Manager must be installed on one of the database servers.
• C. Oracle Solaris must be used on the server where ASK Manager is installed.
• D. SMTP must be enabled on at least one database server.
• E. Oracle Linux must be used on the server where ASR Manager is installed
• F. ASR Manager may be installed on any type of server running Oracle Linux.
• G. ASR Manager may be installed on any type of server running Oracle Solaris.

Answer: AFG

Explanation:
A: Before installing ASR, please ensure the following conditions are met:
/ (A) Ensure connectivity to the Internet using HTTPS.
/ Make sure you have access to My Oracle Support and that your contact information is
correct and current.
/ Make sure all of your assets have a Contact assigned and that the contact is correct and current.
/ Identify and designate a system to serve as ASR Manager.
/ Identify and verify ASR assets.
F, G (not C, not E, not B): The recommended configuration is to install the ASR Manager, which receives fault telemetry information from the servers in Oracle Exadata Database Machine, on an external standalone server. This server must run Solaris or Linux as the operating system.
Reference: Oracle Auto Service Request Exadata Database Machine Quick Installation Guide

NEW QUESTION 16
You must drop all celldisks on all the cells in a quarter rack as part of a reconfiguration project, to support normal redundancy interleaving.
Select two actions that describe the operating system (O/S) account on the cells to which you should log in, and the tool that may be used to drop the celldisks.

• A. To the CELLMONITOR account using CELLCLI interactively on each cell.
• B. To CELLADMIN account calling CELLCLI on all cells using DCLI
• C. To either the CELIMONITOR or the CELLADMIN account calling CELLCLI on all cells using DCLI
• D. To the CELLMONITOR account calling CELLCLI on all cells using DCLI
• E. To the CELLADMIN account using CELLCLI interactively on each cell
• F. To either the CELLMONITOR or CELLADMIN account calling interactively on each cell

Answer: BE

Explanation:
Note:
* Each Exadata Storage cell can be monitored, configured, and maintained using the cellcli command line interface. To invoke the CLI, simply login to the Exadata cell as cellmonitor, celladmin, or root, and type "cellcli". Within cellcli, a wide range of commands can be invoked to monitor the cell.
* While connected to cellcli as the Linux account celladmin, you can perform all cellcli commands except calibrate.
While logged into the cell server as cellmonitor, you can do any "read-only" commands; you cannot change any configuration or attributes.

NEW QUESTION 17
You have configured a multi-rack Database Machine with two X3-8 full racks all in a single cluster and storage grid.
Which two are true regarding the servers on which Enterprise manager agents must be deployed in order to monitor all components of the multi-rack Database Machine?

• A. On only one database server in the first rack
• B. On all storage servers in all racks
• C. On at least two storage servers in the first rack
• D. On all database servers in the first rack
• E. On only one database server in second rack
• F. On all database servers in second rack
• G. On at least two storage servers in the second rack

Answer: DF

Explanation:
Note:
* The Enterprise Manager agent must be deployed to all compute nodes of the Database Machine.
* Oracle's documentation uses the term compute node when referring to the database server tier of the platform.
* The Exadata Database Machine runs Oracle Database 11g Real Application Cluster. The cluster and the database run on the servers known as database nodes or compute nodes (or simply “nodes”).
* Cells and compute nodes are not shared between partitions.
* Compute nodes in same partition share the same Cluster.

NEW QUESTION 18
You are evaluating the performance of a SQL statement that accesses a very large table, and have run the following query producing the output shown:

For which two reasons would the; “physical read total bytes” statistic be greater than the “cell physical IO bytes eligible for predicate offload” statistic?

• A. There is an index on the column used in the where clause, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O for blocks in the cells.
• B. The table is an IOT and has an overflow segment, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O for block in the cells.
• C. There is an uncommitted transaction that has modified some of the table blocks, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O for block in the cells.
• D. The table is an indexed clustered table, causing “cell single block physical reads” to be requested by the database instance, resulting in additional I/O for blocks in the cells.
• E. There are migrated rows in the table, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O for blocks in the cells.

Answer: BD

NEW QUESTION 19
A table in one of your database schemas contains only varchar, number, and date data types for the columns.
Which three operations can be offloaded to the Exadata storage servers when doing a smart scan against this table, if no other situations arise that prevent Smart Scan from occurring?

• A. Column filtering
• B. Sort merge join filtering
• C. Predicate filtering
• D. Nested loop Join filtering
• E. Hash join filtering
• F. Virtual column filtering

Answer: ACE

Explanation:
A: Smart Scan Column Filtering
Exadata provides column filtering, also called column projection, for table scans. Only the columns requested are returned to the database server rather than all columns in a table.
For example, when the following SQL is issued, only
the employee_name and employee_number columns are returned from Exadata to the database kernel.
SELECT employee_name, employee_number FROM employee_table.
For tables with many columns, or columns containing LOBs (Large Objects), the I/O bandwidth saved can be very large. Using both predicate and column filtering dramatically improves performance and reduces I/O bandwidth consumption. In addition, column filtering also applies to indexes, allowing for even faster query performance.
C: Smart Scan Predicate Filtering
Exadata enables predicate filtering for table scans. Only the rows requested are returned to the database server rather than all rows in a table. For example, when the following SQL is issued only rows where the employees' hire date is after the specified date are sent from Exadata to the database instance.
SELECT * FROM employee_table WHERE hire_date > '1-Jan-2003'.
This ability to return only relevant rows to the server greatly improves database performance. This performance enhancement also applies as queries become more complicated, so the same benefits also apply to complex queries, including those with subqueries.

NEW QUESTION 20
You are in the planning stage of the network configuration for your Database Machine. The requirements are:
1. A fault-tolerant network, providing higher availability for connections to database instances
2. Fault tolerance providing higher availability for connections to perform management functions on the database and storage servers.
3. Full monitoring of all Database Machine components using Enterprise Manager
Which three components require external Ethernet network cables to connect your existing network infrastructure to your database machine to satisfy this requirement?

• A. Database servers
• B. Exadata storage servers
• C. InfiniBand storage servers.
• D. Power distribution units (PDUs)
• E. Cisco Ethernet switch

Answer: ADE

NEW QUESTION 21
Identify two valid reasons for creating multiple griddisks on a Single celldisk.

• A. To segregate storage into multiple pools with different performance characteristics
• B. To facilitate normal or high redundancy ASM diskgroups
• C. To enable disk mirroring for the system area
• D. To segregate storage into multiple pools that can be assigned to different databases
• E. To segregate storage into multiple pools that can be assigned to different resource consumer groups in the same database.

Answer: AD

NEW QUESTION 22
Which three are true about Smart Flash log?

• A. I/O Resource Manager database plans can be used to enable or disable Smart Flash Log for different databases.
• B. LGWR will not wait for writes to Smart Flash log if the write to a disk based log file completes first.
• C. Smart Flash Log is enabled by default, using 1024 MB of Rash storage on each storage server.
• D. You can remove Smart Flash Log from a single storage server with the drop flashing command.
• E. I/O Manager category plans can be used to enable or disable Smart Flash Log For different I/O categories.

Answer: ABD

Explanation:
A: the Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine.
B: Smart Flash Logging works as follows. When receiving a redo log write request, Exadata will do
parallel writes to the on-disk redo logs as well as a small amount of space reserved in the flash
hardware. When either of these writes has successfully completed the database will be immediately notified of completion. If the disk drives hosting the logs experience slow response
times, then the Exadata Smart Flash Cache will provide a faster log write response time. Conversely, if the Exadata Smart Flash Cache is temporarily experiencing slow response times
(e.g., due to wear leveling algorithms), then the disk drive will provide a faster response time.
This algorithm will significantly smooth out redo write response times and provide overall better
database performance.
D: Category plans are configured and enabled using the CellCLI utility on the cell. Only one category plan can be enabled at a time
Incorrect:
Not C: By default, 512 MB of the Exadata flash is allocated to Smart Flash Logging

NEW QUESTION 23
Which two are true about the use of DBFS in a Database Machine environment?

• A. DBFS must be used to bulk load data into a database on the Database Machine if the staging area requires Exadata based shared storage.
• B. DBFS must be used to have a POSIX compliant shared storage solution that is accessible from the database servers on a Database Machine.
• C. DBFS must be used to bulk load data into a production database on the Database Machine.
• D. DBFS must use the DBFS_DG diskgroup for any DBFS store.
• E. DBFS must be used to have a POSIX-compliant Exadata-based shared storage solution.

Answer: CD

NEW QUESTION 24
A read-only application is in development and is using a test database on a Database Machine. You are examining SQL statements from this application in an attempt to determine which ones will benefit from the Exadata Smart scan capability.
The following is true about the tables used by the application:
1. The data for the tables has just been loaded.
2. There are no applications accessing the tables currently.
3. None of the indexes are compressed or reverse key indexes.
4. The tables use the default organization type data.
5. The only data types for the table are varchar (2), number, or date.
6. The largest number of columns for any table is 29.
7. No access is based on ROWID, or virtual columns.
Which two access paths will always generate either a set of “cell smart table scan” or a set of “cell smart index scan” requested?

• A. Full scans on sorted hash clustered tables executed in parallel
• B. Full table scans on index organized tables executed in parallel.
• C. Full table scans on heap tables executed in parallel
• D. Full scans on index clustered tables executed in parallel
• E. full scans on hash clustered tables executed in serially
• F. fast full scans on B*Tree indexes executed in parallel
• G. full index scans on B*Tree indexes executed in parallel

Answer: CF

NEW QUESTION 25
Which two are true concerning the allocation of I/O resources by the IORM within the CELLSRV process?

• A. If two consumer groups A and B in the PROD database get 10% and 15% respectively of resource allocation, then the percentage of I/O resource would be the same if they got 20% and 30% respectively, provided that the category plans and inter database plans are unchanged, and consumer groups A and B are still mapped to the same category.
• B. If two consumer groups C and D In the PROD database get 10% and 15% respectively of resource allocation, then the percentage of I/O resource would be the same if they still got 10% and 15% respectively and were remapped to a different category by the DBA, provided that the category plans and Interdatabase plans are unchanged.
• C. If two consumer groups P and Q In the PROD database get 20% and 10% respectively of resource allocation, then the percentage of I/O resource would be the same if they got 10% and 5% respectively, and the Interdatabase plan has changed, provided that the category plan is unchanged, and consumer groups A and B are still mapped to the same categories.
• D. Log Writer I/O and Control File I/O are high priority I/O managed automatically by IORM.
• E. Database Writer I/O is considered to be the highest priority I/O and is managed based on attributes of the IORM plan.

Answer: CD

Explanation:
*(not A, Not B) Rules in an interdatabase resource plan specify allocations to databases, not consumer groups.
* IORM Rules
IORM is only "engaged" when needed.
/ (D) Redo and control file writes always take precedence.
/ (Not E) DBWR (database writer) writes are scheduled at the same priority as user IO.
/ IORM does not intervene if there is only one active consumer group on one database.
/ Any disk allocation that is not fully utilized is made available to other workloads in relation to the configured resource plans.
/ Background IO is scheduled based on their priority relative to user IO.
/ For each cell disk, each database accessing the cell has one IO queue per consumer group and three background queues
Note:
* Use IORM metrics to track
/ I/O load per Consumer Group (IOPS, MBPS, disk utilization %)
/ I/O throttling per Consumer Group Reference: Using IORM with Exadata

NEW QUESTION 26
......