NEW QUESTION 1
Identify three valid configuration options that can be implemented during the initial configuration process of a new Database Machine by using the Exadata Deployment Assistant

• A. database character set
• B. size of the RECO ASM diskgroup
• C. size of the DBFS diskgroup
• D. O/S owner mode (standard O/S authentication or role-separated O/S authentication)
• E. RDBMS DBA group name

Answer: BDE

Explanation:
D: Determine which OS owner mode to use

NEW QUESTION 2
Consider the following list of software components:
1. DCLI
2. Management Server (MS)
3. ASM Instance
4. RDBMS instance
5. Restart Server (RS)
6. Cellcli
7. Cell Server (CELLSRV)
8. Diskmon
Identify the location where these software components may run in the standard Database machine deployment.

• A. 3, 4 and 8 run on the database servers; 1, 2, 5, 6 and 9 run on the Exadata Storage servers.
• B. 4 and 8 run on the database servers; 1, 2, 3, 5, 6 and 7 run on the Exadata Storage servers.
• C. 1, 3 and 4 run on the database servers; 2, 5, 6, 7 and 8 run on the Exadata Storage servers.
• D. 3, 4 and 8 run on the database servers; 1, 2, 5, 6 and 7 run on the Exadata Storage servers.
• E. 3, 4 and 8 run on the database servers; 1, 2, 5, 7 and 8 run on the Exadata Storage servers.
• F. 1, 3, 4 and 8 run on the database servers; 1, 2, 5, 7 and 8 run on the Exadata Storage servers.

Answer: D

NEW QUESTION 3
You recently upgraded your Exadata image to the latest release; previously you were using 11.2.0.3.
At the same time, you decide to address some performance problems as follows:
You noticed increased latency for the database log writer, especially during the quarterly battery learn cycle on the cells.
You have complaints of erratic performance from certain write-intensive applications. Which two actions could improve performance in these areas?

• A. Enable write-back flashcache by setting lunWriteCacheMode to Write Back Mode.
• B. Use ALTER TABLE in the database to set CELL_FLASH_CACHE = KEEP for the tables belonging to the affected application.
• C. Configure Smart Flash Log on the cells to use some of these of the space on the cell flash devices.
• D. Configure the table belonging to the affected application using CELLCLI, to the set CELL_FLASH_CACHE = KEEP.
• E. Configure Smart Flash Log on the database server to use server flash memory.

Answer: BC

Explanation:
B: The following command could be used to pin the table CUSTOMERS in Exadata
Smart Flash Cache
ALTER TABLE customers STORAGE (CELL_FLASH_CACHE KEEP)
C: Creating Flash Disks Out Of The Flash Cache
When an Exadata cell is installed, by default, all the flash is assigned to be used as flash cache and
user data is automatically cached using the default caching behavior. Optionally, a portion of the
cache can be reserved and used as logical flash disks. These flash disks are treated like any
Exadata cell disk in the Exadata cell except they actually reside and are stored as non- volatile
disks in the cache.
Note:
* Pinning Objects In The Flash Cache
Preferential treatment over which database objects are cached is also provided with the Exadata
Smart Flash Cache. For example, objects can be pinned in the cache and always be cached, or an
object can be identified as one which should never be cached. This control is provided by the
new storage clause attribute, CELL_FLASH_CACHE, which can be assigned to a database table, index, partition and LOB column
* There are two techniques provided to manually use and manage the cache. The first enables the
pinning of objects in the flash cache. The second supports the creation of logical disks out of the
flash for the permanent placement of objects on flash disks.

NEW QUESTION 4
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 5
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 6
Which three are among the software components that constitute the QoS Management framework?

• A. Cluster Health Monitor (CHM)
• B. Cluster Verification Utility (CLUVFY)
• C. O/S Resource Manager
• D. Grid Infrastructure for a standalone server
• E. Grid Infrastructure for a cluster
• F. OC4J cluster resource

Answer: AEF

Explanation:
A: In conjunction with Cluster Health Monitor, QoS Management’s Memory Guard detects nodes that are at risk of failure due to
memory over-commitment. It responds by automatically preventing new connections thus preserving existing workloads and restores connectivity once the sufficient memory is again available.
F: The ora.oc4j is for the QoS (Quality of Service Management), which is only available on
Exadata.
Incorrect:
Not B: The Cluster Verification Utility (CVU) performs system checks in preparation for installation, patch updates, or other system changes. Using CVU ensures that you have completed the required system configuration and preinstallation steps so that your Oracle grid infrastructure or Oracle Real Application Clusters (Oracle RAC) installation, update, or patch operation completes successfully.

NEW QUESTION 7
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 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
In which two locations should files be staged, to be loaded using external tables into a database on a Database Machine?

• A. On a dbfs file system stored in a staging database on the Database Machine
• B. On an Exadata-based ACFS file system on the Database Machine
• C. On an nfs file system mounted on a database server where the external table will be accessed.
• D. On local storage on one or more cells that are accessible to the database server where the load will be performed.

Answer: AC

Explanation:
Reference: Installing Oracle E-Business Suite Release 12 with the Oracle Exadata Database Machine

NEW QUESTION 10
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 11
You are about to run the oplan utility to patch the servers on your test Database Machine before patching the production environment.
The following task might be performed:
A) Test the failback procedure
B) Run the exachk utility
C) Read the README file.
D) Automate the patch application process as appropriate.
E) Verify that the patch provides the functionality it is meant to.
F) Apply the patch.
G) Evaluate the system performance.
In which order should the tasks be performed to patch in the recommended fashion?

• A. C, B, D, F, B, E, A
• B. C, D, F, B, E, G, A, B
• C. C, B, D, F, E, G, A
• D. C, B, D, F, E, A, G
• E. C, B, D, F, B, E, G, A

Answer: E

NEW QUESTION 12
Identify the correct sequence of commands to completely power off a Database Machine in an Orderly fashion:
1. Execute “crsctl stop cluster –all” as the grid user from one database server.
2. Execute “crsctl stop cluster –all” as the root user from one database server.
3. Power off all network switches using their power switch.
4. Execute “crsctl stop cluster –all” as the root user from one database server.
5. Execute “crsctl stop cluster –all” as the grid user from one database server.
6. Power off the rack using the power switches on the PDUs.
7. Execute “shutdown –h now” on all database servers.
8. Execute “shutdown –h now” on all Exadata storage servers.
1. 9. Execute “shutdown –h now” on all servers.

• A. 1, 9, 3 and 6
• B. 2, 9 and 6
• C. 4, 7, 8, 3 and 6
• D. 5, 8, 7, 3 and 6
• E. 2, 8, 7, 3 and 6
• F. 1, 8, 7, 3 and 6
• G. 2, 7, 8 and 6
• H. 2, 8, 7 and 6

Answer: G

NEW QUESTION 13
You are examining the existing IORM configuration on the cells of Database Machine, to see if they require my modifications based on recent changes to various workloads.
All seven cells in your X3-2 half-rack shown the following:

Which two are true about I/O to the cells using this plan?

• A. I/O requests in the batch category may use flashcache if the I/O is from the sales finance database, and these I/O requests are guaranteed to get 80% of the I/O if the interactive category I/Os use no more than 20%.
• B. I/O requests made by sessions in the marketing database may use flashing and flashcache if no other categories or database or database are using flashing and flashcache at the same time.
• C. I/O requested in the interactive category may use flashdns if the I/O is from the sales or finance databases, and these I/O requests are guaranteed to get 90% of the I/O if the enough I/Os are issued in this category.
• D. I/O requests from the sales database may use flashing regardless of the I/O category.
• E. No I/Os in any category or from any database may use flashing or flashcache because the objective is off.

Answer: AD

NEW QUESTION 14
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 15
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 16
You have two very large databases supporting OLTP workloads which run on multiple small-blade style servers in a cluster and which require optimal latency for I/O.
You plan to migrate them to a Database Machine once a capacity planning exercise is finished.
The database backup strategy requires that backups are written directly to media.
High availability requirements state that you must be able to survive node failures at any time.
Which three Database Machine components or features would you recommend to support these requirements?

• A. Use of write back flash cache
• B. Use of smart flash logs
• C. High capacity disks in the Database Machine
• D. High performance disks in the Database Machine
• E. A high capacity expansion full rack
• F. A high performance expansion full rack

Answer: ABC

NEW QUESTION 17
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 18
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 19
To troubleshoot a possible hardware problem, you consider moving all disk drives from one Exadata storage server to a replacement chassis.
You must contain storage availability while performing task.
The Exadata storage server is an X3-8 Database Machine and storage grid is not
partitioned.
Which two factors would prevent you from moving the disks from one Exadata storage server to another one?

• A. The existence of an external redundancy ASM diskgroup
• B. The existence of a normal redundancy ASM diskgroup
• C. The existence of an ASM diskgroup with the repair_time attribute set to 0.
• D. The existence of an ASM diskgroup with its compatible.asm attribute set to 10.2.0.0.0
• E. Offline or inactive celldisks in another Exadata server

Answer: AD

Explanation:
A: If you want Oracle ASM to mirror files, specify the redundancy level as NORMAL REDUNDANCY (2-way mirroring by default for most file types) or HIGH REDUNDANCY (3-way mirroring for all files). You specify EXTERNAL REDUNDANCY if you do not want mirroring by Oracle ASM. For example, you might choose EXTERNAL REDUNDANCY if you want to use storage array protection features.
D: Restoring the redundancy of an Oracle ASM disk group after a transient disk path failure can be time consuming. This is especially true if the recovery process requires rebuilding an entire Oracle ASM failure group. Oracle ASM fast mirror resync significantly reduces the time to resynchronize a failed disk in such situations. When you replace the failed disk, Oracle ASM can quickly resynchronize the Oracle ASM disk extents.
To use this feature, the disk group compatibility attributes must be set to 11.1 or higher.
Incorrect:
Not C: You can set the DISK_REPAIR_TIME disk group attribute to delay the drop operation by specifying a time interval to repair the disk and bring it back online.
Note:
* The redundancy levels are:
/ External redundancy
Oracle ASM does not provide mirroring redundancy and relies on the storage system to provide RAID functionality. Any write error cause a forced dismount of the disk group. All disks must be located to successfully mount the disk group.
/ Normal redundancy
Oracle ASM provides two-way mirroring by default, which means that all files are mirrored so that there are two copies of every extent. A loss of one Oracle ASM disk is tolerated. You can optionally choose three-way or unprotected mirroring.
/ High redundancy
Oracle ASM provides triple mirroring by default. A loss of two Oracle ASM disks in different failure groups is tolerated.
Reference: Administering Oracle ASM Disk Groups

NEW QUESTION 20
You plan to migrate your Oracle Version 11.1.0.2 database to your Exadata Database Machine.
The database supports an online transaction processing (OLTP) workload and is currently hosted on a Little Endian platform
Which two are the supported and appropriate migration methods to minimize downtime?

• A. Upgrade source database to 11.2.0 and migrate using a physical standby database.
• B. Migrate using Data Pump.
• C. Migrate using GoldenGate.
• D. Migrate using cross platform Transportable Database.
• E. Migrate using ASM online migration.

Answer: AB

Explanation:
Reference: Migrating the Oracle E-Business Suite Database to Oracle Exadata Database Machine Using Transportable Tablespaces
Reference: Migrating Oracle E-Business Suite to Oracle Exadata Database Machine Using Oracle Data Pump

NEW QUESTION 21
Which three storage components are available after the standard initial Database machine deployment?

• A. The DATA_<DBM_Name> ASM diskgroup
• B. The RECO_<DBM_Name> ASM diskgroup
• C. Mirrored system partitions on hard disk 0 and hard disk 1
• D. The DBFS_DG diskgroup with external redundancy
• E. Exadata Smart Flash Cache using all of the flashdisk space

Answer: ABC

NEW QUESTION 22
Which statement is true about operating systems on database Machine multi-rack configuration consisting of two full racks and one Exadata storage rack?

• A. All Exadata storage servers and all database servers must run the Oracle Linux O/S and X3-8 database server may run the Oracle Solaris O/S.
• B. All Exadata storage servers must run the Oracle Linux O/S and all database servers within the same cluster must run the Oracle Linux O/s.
• C. All Exadata storage servers must run the Oracle Linux O/S and all database servers within the same cluster must run the same O/s.
• D. All Exadata Storage Servers must run the Oracle Solaris O/S and all database servers within the same cluster must run the same O/S.
• E. All Exadata storage servers in the same cluster must run the same O/S but Exadata Storage Servers in different clusters may run a different O/S.

Answer: C

NEW QUESTION 23
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 24
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 25
......