NEW QUESTION 1
Which four statements are true about Exadata Smart Flash Cache?

• A. Smart Scan will always be done for I/Os to flash based griddisks.
• B. Flash based ASM diskgroups may share space with the Flash Cache on the flashdisks.
• C. Single block reads can benefit from Smart Flash Cache.
• D. Smart Scan will never be done for I/Os to flash based griddisks.
• E. Multiblock reads can benefit from Smart Flash Cache.
• F. Smart Flash Logs reduce the size of Smart Flash Cache.

Answer: BCEF

Explanation:
B: * Grid disks (the logical disks
that reside on physical cell disks) are created on these flash-based cell disks and the grid disks are assigned to an Automatic Storage Management (ASM) diskgroup. The best practice would be to reserve the same amount of flash on each Exadata cell for flash disks and have the ASM
diskgroup spread evenly across the Exadata cells in the configuration just as you would do for
regular Exadata grid disks. This will evenly distribute the flash I/O load across the Exadata cells
and flash.
Note:
* The Exadata
Storage Server comes with a substantial amount of flash storage. A small amount is allocated for
database logging and the remainder will be used for caching user data

NEW QUESTION 2
Which two are true about Exadata storage server alerts?

• A. Metric alerts are never stateful.
• B. Metrics have no thresholds set on them by default.
• C. SNMP alert notifications can be sent to only one destination.
• D. Metric threshold; if set, will persist across storage server reboots.
• E. SMTP alert notifications must be sent to both ASR manager and Enterprise Manager Agents

Answer: DEExplanation:Incorrect:

Explanation:
Not A: there are both stateful and stateless alerts. Not B: Metrics have defaults.
Not C: An SNMP alert can have multiple destinations.

NEW QUESTION 3
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 4
Which two are true about the use of the Integrated Lights Out Manager (ILOM) on the Database Machine?

• A. ILOM can be used to power-on the Cisco switch.
• B. ILOM can be used to power on the InfiniBand switches.
• C. ILOM can be used to power-on the database servers.
• D. ILOM generates hardware alerts for the power distribution units.
• E. ILOM provides a remote console for the storage servers.

Answer: CE

Explanation:
* The Oracle ILOM Remote Console is supported on all Oracle Sun x86 processor-based servers. It is also supported on some SPARC processor-based servers. The Oracle ILOM Remote Console is a Java application that you can launch from the Oracle ILOM web interface
* Remote Management: Integrated Lights Out Manager (ILOM) Ethernet port

NEW QUESTION 5
Your Database Machine has a large database with some very large tables supporting OLTP workloads.
High volume Insert applications and high volume update workloads access the same tables.
You decide to compress these tables without causing unacceptable performance overheads to the OLTP application.
Which three are true regarding this requirement?

• A. Using 'compress for oltp' will compress the data less than if using Hybrid Columnar Compression when specified with compress for query low.
• B. The compression is performed on the storage servers when using compress for oltp in an Exadata environment.
• C. The compression method compress for archive high is the worst fit for this requirement.
• D. Using 'compress for oltp' will compress the data more than if using Hybrid Columnar Compression when specified with compress for archive low.
• E. The compression is performed on the database servers when using 'compress for oltp' in an Exadata environment.

Answer: ACE

Explanation:
Note:
(E not B):
* Types of compression
Basic compression OLTP compression Warehouse compression
Online archival compressio
*
/ OLTP compression allows compression during DML operations.
/ Basic compression works at the data block level.
* When you enable table compression by specifying COMPRESS FOR OLTP, you enable OLTP table compression. Oracle Database compresses data during all DML operations on the table. This form of compression is recommended for OLTP environments.
* When you specify COMPRESS FOR QUERY or COMPRESS FOR ARCHIVE, you enable hybrid columnar compression. With hybrid columnar compression, data can be compressed during bulk load operations. During the load process, data is transformed into a column-oriented format and then compressed. Oracle Database uses a compression algorithm appropriate for the level you specify. In general, the higher the level, the greater the compression ratio.
Hybrid columnar compression can result in higher compression ratios, at a greater CPU cost. Therefore, this form of compression is recommended for data that is not frequently updated.

NEW QUESTION 6
Which two activities are supported on the storage servers in the Database Machine?

• A. Installing an alternative package manager
• B. configuring secure shell user equivalency for the callmonitor user
• C. changing root password
• D. upgrading the Storage Server software package using RPN
• E. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure

Answer: BC

NEW QUESTION 7
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 8
Which three statements are true about the initial storage configuration after the standard deployment of a new database Machine?

• A. The Data_<DBM_Name> and RECO_<DBM_Name> ASM diskgroups are built on part of the interleaved griddisks.
• B. The Data_<DBM_Name> and RECO_<DBM_Name> ASM diskgroups are built on top of the non-interleaved griddisks.
• C. There is a free space available on the hard disks inside the database servers for possible extension of the /u01 file system.
• D. There is no free disk space available on the hard disk inside the database servers for possible extensions of the /u01 file system.
• E. There is free space available on the flashdisk inside the Exadata storage servers for possible use as flash-based griddisks.
• F. There is no free disk available on the flashdisk inside the Exadata storage servers for possible use as flash-based griddisks.

Answer: BCF

Explanation:
B( not A): 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. If we follow the recommendations, we will create 3 Diskgroups upon our Griddisks: DATA, RECO and SYSTEMDG.
Note:
* non-root partition (/u01).
* Oracle Database files: DATA disk group.
* Flashback log files, archived redo files, and backup files: RECO disk group.

NEW QUESTION 9
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 10
You plan to migrate an existing production database supporting online transaction processing (OLTP) workloads to the Exadata Database Machine. The database currently supports an application requiring fast response times, which satisfies stringent requirements, and most of the application queries use index access to the tables in the application schema.
For which case would you consider dropping indexes to allow Smart Scans to occur?

• A. Drop non-constraint indexes if Smart Scan occurs instead of an index access path on the corresponding table.
• B. Drop non-constraint indexes if Smart Scan performs better than index unique scans on the corresponding table.
• C. Drop non-constraint indexes if Smart Scan performs better than index range scans on the corresponding table.
• D. Drop non-constraint Indexes if Smart Scan performs better than any index scans on the corresponding table.

Answer: D

NEW QUESTION 11
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 12
You have used setupem.sh to deploy a plug in for Grid Control.
In which two ways do all the targets supported by the plug-in get configured?

• A. The targets must be configured by an Enterprise Manager administrator manually using Grid Control.
• B. Setupem.sh is used again to configure the targets.
• C. The targets must be configured by an O/S administrator manually.
• D. The targets must be configured by a database administrator manually.
• E. There may be more than one target for each plug-in.

Answer: AE

NEW QUESTION 13
What is the benefit of bonding the client access network configuration?

• A. Improved performance
• B. Improved reliability
• C. Both improved performance and reliability
• D. A Single Client Access Name (SCAN)
• E. Improved monitoring

Answer: B

Explanation:
Reference: Oracle Exadata Database Machine - Backup & Recovery Sizing: Tape Backups

NEW QUESTION 14
You plan to monitor storage servers after configuring an I/O resource manager plan with directives for inter-database plans and intra-database plans.
Which two types if metrics would help assess the impact of the intra-database plans on I/O to the storage servers?

• A. Category I/O
• B. Database I/O
• C. Resource Consumer Group I/O
• D. Smart Flash Log I/O
• E. Smart Flash Cache I/O

Answer: BC

Explanation:
B: Database metrics provide information about the size of the I/O load from each database specified in the interdatabase plan.
C: Consumer group metrics provide information about the size of the I/O load from each consumer group specified in a database resource plan. Each database in the interdatabase plan has metrics for each of its consumer groups.
Note:
* I/O Resource Manager (IROM) Settings
* Incorrect:
Not A: Category metrics provide information about the size of the I/O load from each category specified in the current IORM category plan.

NEW QUESTION 15
You must apply patches and patch bundles in a rolling fashion, if possible, on the components of your Database Machine.
You use RAC for your database and also use Data Guard, having standby database on another Database Machine.
You wish to have scripts that contain the appropriate command to patch your environment. Your patch bundle is on the first database server and is located at /u01/stage.
You have downloaded the oplan utility to the first database server and run the following:
$ORACLE_HOME/oplan/oplangenerateApplySteps /u01/stage Which two are true concerning oplan?

• A. It will generate instructions for patching only storage servers.
• B. It will generate instructions for patching all the components on the Database Machine.
• C. It will generate instructions for patching the RAC Oracle Home on the primary location.
• D. It will generate instructions for patching the Data Guard environment on the standby location.
• E. It will generate instructions for patching the Grid Infrastructure home on the primary location.

Answer: CE

Explanation:
Oplan generates instructions for all of the nodes in the cluster.
Note:
* Oplan is a utility that facilitates you with the application of bundle patches on Exadata compute nodes via Opatch. This new utility helps you with the patch process by generating step-by-step instructions telling you how to apply a bundle patch in your environment.
* Exadata is much more than a "database-in-a-box." It is a set of compute nodes (think RAC node servers) combined with ultra-fast infiniband (...and 10GB ethernet, and multiple
* 1GB ethernet) and storage nodes.
Incorrect:
Not D: There is no support for Oracle DataGuard

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
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 18
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 19
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 20
Which three are true abort Enterprise Manager plug- in configuration for the Database Machine?

• A. There are several separate plug-ins for Grid Control.
• B. There is one plug-in for Cloud Control.
• C. There are several separate plug-ins for Cloud Control.
• D. Some plug-ins require SNMP trap forwarders.
• E. All plug-ins require SNMP trap forwarders.
• F. There is one plug-in for Grid Control.

Answer: ACD

NEW QUESTION 21
......