The Secret Of Oracle 1Z0-027 Question

NEW QUESTION 1
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 2
Which two are true about Smart Scan?

• A. a query rewrite may occur to a container table stored in Exadata but will never benefit From Smart scan.
• B. Column projection does not contribute to the performance benefit of Smart Scan
• C. It is possible to offload single row functions to the storage servers.
• D. Some joins can be offloaded to the storage servers.
• E. A query rewrite may occur to a container table stored Exadata, and it will always benefit from Smart Scan.
• F. All joins can be offloaded to the storage servers.

Answer: CD

Explanation:
C: With Exadata storage, database operations are handled much more efficiently. Queries that perform table scans can be processed within Exadata storage with only the required subset of data returned to the database server. Row filtering, column filtering and some join processing (among other functions) are performed within the Exadata storage cells. When this takes place only the relevant and required data is returned to the database server.
D (not F):
* Exadata performs joins between large tables and small lookup tables, a very common scenario for data warehouses with star schemas. Joining large tables and small lookup tables is implemented using Bloom Filters, which are a very efficient probabilistic method to determine whether a row is a member of the desired result set.
* If storage indexes are so great, why doesn’t Oracle Exadata use them all the time? The short answer is that they are created and used only when they will be beneficial.
* To use storage indexes, Oracle Exadata queries must use smart scans, so not all types of applications can benefit from storage indexes. Applications with queries that include predicates and perform a lot of full table scans or fast full scans of indexes—typically those used in data warehousing environments—will benefit greatly from storage indexes. Online
* transaction processing (OLTP) applications, on the other hand, typically access a small number of rows through standard indexes and do not perform full table scans, so they may not benefit from storage indexes.
Note:
* Storage indexes reside in the memory of the storage servers—also called storage cells—and significantly reduce unnecessary I/O by excluding irrelevant database blocks in the storage cells.
* To use storage indexes, Oracle Exadata queries must use smart scans, so not all types of applications can benefit from storage indexes.
Incorrect:
Not B: 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.
Reference: Oracle Communications Data Model Implementation and Operations Guide, Exadata Smart Scan Processing and Storage Index

NEW QUESTION 3
Which two are regarding the case of storage indexes?

• A. To increase the chance of using the a storage index, you can make table indexes invisible.
• B. To maximize the benefit of storage Indexes, load your data stored on the filtered columns.
• C. The cell physical 10 bytes saved by storage index statistic returns multiple rows, one for each storage server.
• D. Storage indexes are retained after a cell is rebooted.
• E. Avoid the use of bind variables because Storage Indexes do not work with bind variables.

Answer: AB

Explanation:
To use storage indexes, Oracle Exadata queries must use smart scans, so not all types of applications can benefit from storage indexes.
* With Exadata storage, database operations are handled much more efficiently. Queries that perform table scans can be processed within Exadata storage with only the required
* subset of data returned to the database server. Row filtering, column filtering and some join processing (among other functions) are performed within the Exadata storage cells. When this takes place only the relevant and required data is returned to the database server.

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 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 6
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 7
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 8
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 9
Identity the resource bottleneck for which QoS Management can generate recommendation?

• A. CPU resource bottlenecks
• B. Global Cache resource bottlenecks
• C. I/O resource bottlenecks
• D. Network resource bottlenecks

Answer: A

NEW QUESTION 10
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 11
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 12
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 13
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 14
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 15
Your database Machine has the exachk utility pre-installed and you decide to use it periodically, to validate the installation against Oracle’s recommended best practices.
Which two actions could you take to do this?

• A. Use a cron job on a database node to run it at regular intervals.
• B. Rut it once from a database node and it will then perform periodic monitoring automatically.
• C. Use a cron job on each cell to run it at regular intervals.
• D. Run it once on each cell and it will then perform periodic monitoring automatically.
• E. Create a Job in Enterprise Manager to run the exachk utility at regular intervals.

Answer: AE

NEW QUESTION 16
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 17
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 18
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 19
You installed ASR Manager on a stand-alone server and configured Auto Service Request (ASR) for your Database machine and its assets.
Which three statements are true about this configuration?

• A. When a component fault occurs, fault telemetry is securely transmitted to Oracle via Simple Network Management Protocol (SNMP).
• B. Simple Network Management Protocol (SNMP) traps are used to send notifications from storage servers to ASR Manager.
• C. When a component fault occurs, fault telemetry is securely transmitted to Oracle via HTTPS.
• D. Simple network Management Protocol (SNMP) traps are used to send notification from Enterprise manager to ASR Manager.
• E. Simple Network Management Protocol (SNMP) traps are used to send notifications from database servers to ASR Manager.
• F. Simple Network Management Protocol (SNMP) traps received by ASR Manager are forwarded to Enterprise Manager.

Answer: ABE

Explanation:
To configure fault telemetry, choose one of the following three options:
Add SNMP Trap Destinations Using OneCommand (recommended for new installations) Add SNMP Trap Destinations for Multiple Servers Using the dcli Utility
Add SNMP Trap Destinations for a Single Server

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