NEW QUESTION 1
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 2
Which three must be true for Smart Scans to be done?

• A. Executing a query in parallel
• B. Setting _serial_direct_read=true in the session issuing the SQL statements
• C. Having direct path reads used at run time
• D. Having a 4 meg AU size for the ASM diskgroup containing the tablespace in which tables accessed by a query are stored
• E. Cell_offload_process = true for the ASM diskgroup containing the tablespace in which tables accessed by a query are stored.
• F. cell.smart_scan_capable=true for the ASM diskgroup containing the tablespace in which tables accessed by a query are stored.

Answer: BCF

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
You are monitoring and evaluating a create index statement on your Database Machine and have run the following query after executing statement, providing the output. Shown:

Select two reasons why the statement would have produced so many “cell single block physical read” waits compared to “cell smart table scan” waits.

• A. There are huge numbers of migrated rows in the table on which the index is being built.
• B. There is an uncommitted transaction that has modified one block of the table on which the index is being built, in each cell.
• C. There is a transaction that has modified one block of the table on which the index is being built in each cell, which committed after the create index began.
• D. There are huge numbers of chained rows in the table on which the index is being built.
• E. There is a ROWID column in the table on which the index is being built.

Answer: AD

Explanation:
A: It could be that row migration.
D: It could be that row migration or chained rows could cause it.
Note:
* Some facts about scans: Scans exists in “OLTP” systems
Exadata smart scan requires a direct path read.
A direct path read is chosen at runtime based on internal heuristics The STORAGE clause in an explain plan doesnt necessarily mean you will perform a smart scan.
* The buffer caching in certain “OLTP” environments can occasionally induce conventional reads when smart scan is faster.
* Typically see cell multiblock physical read instead of cell smart table scan waits
* No one-size-fits-all solution can be given here but it is very fixable.

NEW QUESTION 5
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 6
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 7
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 8
Which three are true regarding the use of Storage Indexes?

• A. Different storage regions may have different columns indexed for the same table.
• B. A Storage index is automatically maintained by CELLSRV based on the filter columns of the offload SQL.
• C. The use of Storage indexes for a particular database can be disabled by using an I/O Resource Manager Database Plan.
• D. Storage Indexes occupy space in the Smart Flash Cache.
• E. The use of Storage Indexes for particular categories of I/O can be disabled by using an I/O Resource Manager Category Plan.
• F. A maximum of eight table columns for any table are Indexed per storage region.

Answer: ABF

Explanation:
Note:
* Storage indexes are used during smart scans. All the limitations to smart scans apply to storage indexes. They do not work with joins. Bind variables are supported, however it’s slightly more restrictive than regular indexes/queries.
* The storage index is stored in the memory on each of the Exadata storage cells and is created and maintained transparently. However, if a storage cell is shutdown or rebooted the storage index will be lost from memory and will be recreated on subsequent accesses to the data after the cell has been brought back online.
* Storage Indexes are a very powerful capability provided in Exadata storage that helps avoid I/O operations. The Exadata Storage Server Software creates and maintains a Storage Index (that is, metadata about the database objects) in the Exadata cell. The Storage Index keeps track of minimum and maximum values of columns for tables stored on that cell. When a query specifies a WHERE clause, but before any I/O is done, the Exadata software examines the Storage Index to determine if rows with the specified column value exist in the cell by comparing the column value to the minimum and maximum values maintained in the Storage Index. If the column value is outside the minimum and maximum range, scan I/O for that query is avoided. Many SQL Operations run dramatically faster because large numbers of I/O operations are automatically replaced by a few lookups. To minimize operational overhead, Storage Indexes are created and maintained transparently and automatically by the Exadata Storage Server Software.

NEW QUESTION 9
Which two communication methods are used by which components in the Enterprise manager Architecture for the Database Machine?

• A. SNMP traps for alerts are sent by the storage server ILOM to the storage server MS process
• B. SNMP traps for alerts are sent by the storage server MS process to the storage server ILOM
• C. SNMP traps for alerts are sent by the storage server ILOM to the Enterprise Manager agent.
• D. SNMP traps for alerts are sent by the storage server MS process to the enterprise Manager agent
• E. SNMP traps for alerts are sent by the storage server ILOM to the storage server RS process.

Answer: AD

Explanation:
There are two types of server alerts that come from Oracle Exadata Storage Server:
* (A) For Integrated Lights Out Manager (ILOM)-monitored hardware components, ILOM reports a failure or threshold exceeded condition as an SNMP trap, which is received by MS.
MS processes the trap, creates an alert for the storage server, and delivers the alert via SNMP
to Oracle Enterprise Manager 12c.
* (D) For MS-monitored hardware and software components, MS processes a failure or threshold
exceeded condition for these components, creates an alert, and delivers the alert via SNMP to
Oracle Enterprise Manager Cloud Control 12c.
Reference: Managing Oracle Exadata with Oracle Enterprise Manager 12c, Oracle White
Paper

NEW QUESTION 10
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 11
You are planning the physical installation of two full rack Database Machines and two full- rack expansion racks. The four racks will be combined into one multi rack system.
Which are the two guidelines for installing this configuration in your data Center?

• A. All Database Machines must be placed side by side with no space between them.
• B. All Expansion Racks must be placed side by side with no space between them.
• C. All racks must be placed in such a way that the exhaust air of one rack does not enter the air inlet of another
• D. All racks must be placed side by side with no space between them.
• E. All racks must be isolated from each other with at least one meter between them.
• F. Racks may be placed as required in the machine room.
• G. Expansion Racks must be placed side by side at least one meter apart.

Answer: AC

Explanation:
A: Group related racks together – for example, racks that run a common database or are part of a common cluster
C: Inadequate cold air flow could result in higher air inlet temperatures in the servers due to exhaust air recirculation

NEW QUESTION 12
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 13
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 14
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 15
Which tool will provide you with diagnostic information for all the software log, trace files,
and OS information on Database Machine?

• A. dbmcheck.sh
• B. diagget.sh
• C. oswatcher
• D. adrci
• E. Enterprise Manager

Answer: B

Explanation:
Gather all diagnostics information
/opt/oracle.SupportTools/onecommand/diagget.sh

NEW QUESTION 16
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 17
Identify the three components that serve a purpose only in the Database Machine.

• A. ASM intelligent Data Placement (IDP)
• B. Intelligent Database Protocol (IDB)
• C. Database Resource Manager (DBRM)
• D. I/O Resource Manager (IORM)
• E. Database Filesystem (DBFS)
• F. The DISKMON process

Answer: ABD

Explanation:
Intelligent Data Placement, a feature of ASM that allows placing data in such a way that more frequently accessed data is located close to the periphery of the disk where the access is faster.
The Exadata software is optimally divided between the database servers and Exadata cells. The database servers and Exadata Storage Server Software communicate using the iDB –
the Intelligent Database protocol. iDB is implemented in the database kernel and transparently
maps database operations to Exadata-enhanced operations. iDB implements a function shipping
architecture in addition to the traditional data block shipping provided by the database. iDB is
used to ship SQL operations down to the Exadata cells for execution and to return query result
sets to the database kernel. Instead of returning database blocks, Exadata cells return only the
The inter-database I/O allocations are defined within the software in the Exadata cell and managed by the I/O Resource Manager (IORM). The Exadata cell software ensures that inter-database I/O resources are managed and properly allocated within, and between, databases.

NEW QUESTION 18
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 19
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 20
Which two statements are true about the use of direct path loads when selecting from external tables in a database on a Database Machine?

• A. INSERT INTO . . . SELECT FROM statements, executed serially, which select from external tables, require the APPEND hint to use direct path loading.
• B. CREATE TABLE . . . AS SELECT statements, which select from external tables, attempt to use in direct path loading automatically.
• C. CREATE TABLE . . . AS SELECT statements, which select from external tables, require the APPEND hint to use direct path loading.
• D. INSERT INTO . . . SELECT FROM statements, executed serially, which select from external tables, are unable to use direct path loading.

Answer: AB

Explanation:
A CTAS (Create table as select) will always use direct path (B, not C) load but IAS (Insert as select) statement will not. In order to achieve direct path load with an IAS statement you must add the APPEND hint to the command (A, not D).
Direct path loads can also run in parallel. You can set the parallel degree for a direct path load
either by adding the PARALLEL hint to the CTAS or IAS statement or by setting the
PARALLEL clause on both the external table and the table into which the data will be loaded.
Once the parallel degree has been set at CTAS will automatically do direct path load in parallel
but an IAS will not. In order to enable an IAS to do direct path load in parallel you must alter the session to enable parallel DML.
Note:
* Parallel Direct Path Load
The key to good load performance is to use direct path loads wherever possible. A direct path
load parses the input data according to the description given in the external table definition,
converts the data for each input field to its corresponding Oracle data type, then builds a column
array structure for the data. These column array structures are used to format Oracle data blocks
and build index keys. The newly formatted database blocks are then written directly to the database, bypassing the standard SQL processing engine and the database buffer cache.
Reference: Best Practices for Implementing a Data Warehouse on the Oracle Exadata Database Machine; Using CTAS & Exchange Partition Replace IAS for Copying Partition on Exadata

NEW QUESTION 21
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 22
......