Oracle 1Z0-027 Free Practice Questions

NEW QUESTION 1
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 2
Which two are true concerning the allocation of I/O resources by the IORM within the CELLSRV process?

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

Answer: AE

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

NEW QUESTION 3
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 4
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 5
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 6
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 7
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 8
Which two may act as building blocks for the creation of two or more griddisks residing on the same physical device and which have more balanced performance characteristics?

• A. griddisk on hard drive-based intervleaved celldisks.
• B. griddisk on hard drive-based celldisks consumed by ASM when creating diskgroups using ASM-based intelligent Data Placement (IDP)
• C. griddisk on hard drive-based non-interleaved celldisks.
• D. griddisk on Flash-base celldisks.

Answer: AD

Explanation:
Interleaved Griddisks mean equally fast Griddisks, whereas with non Interleaved Griddisks (the default) the Griddisks created first are being taken from the outer tracks of the underlying physical disk.

NEW QUESTION 9
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 10
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 11
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 12
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 13
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 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
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 16
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 17
You configuring has two half racks, one with high capacity disks and other with high performance disks and high capacity expansion half rack.
There are two RAC clusters, one on each half rack, which have separate storage grids, each consisting of some of the storage servers in the configuration.
You are planning your deployment of Enterprise Manager to monitor all the components of this multi-rack Database Machine, and must provide for high availability of the monitoring
infrastructure.
If the host running the agent which has database machine targets bound to it fails, the monitoring of these targets must be another agent.
Which two are true regarding the configuration used to support this?

• A. Enterprise manager support must be deployed to only one Enterprise Manager Agent in each cluster.
• B. A secondary agent must be deployed on a database server in the same cluster as the server hosting the primary agent.
• C. Enterprise Manager support must be deployed to all Enterprise Manager Agents in each cluster.
• D. A secondary agent may be deployed on a database server in a different cluster than the server hosting the primary agent.
• E. A secondary agent must be deployed on a database server in a different cluster than the server hosting the primary agent.
• F. Enterprise Manager support must be deployed to at least two Enterprise Manager Agents in each of the two RAC clusters.

Answer: AD

Explanation:
Note:
* Instructions for configuring a high availability solution for the Exadata Storage cell or any other Exadata plug-in are documented in the Oracle Database Machine Monitoring Best Practices (Doc ID 1110675.1) document located in My Oracle Support
* High Availability for Plug-Ins
Normally a plug-in target is bound to a specific agent If the agent is down the target cannot be monitored
A procedure exists to facilitate target failover to a secondary agent
* The Enterprise Manager agent must be deployed to all compute nodes of the Exadata Database Machine.
* The Oracle ILOM plug-in monitors the Oracle ILOM service processor in a compute node for hardware events and records sensor data to the Oracle Enterprise Manager Repository.
The ILOM plug-in is deployed to the Enterprise Manager (EM) Agent on the first compute node in an Oracle Database Machine, and only that EM agent communicates with the EM Management Server and Repository for all ILOM database server service processors in the Oracle Database Machine.
* OEM Agent and Exadata Plug-ins
1. OEM Agent and Plug-Ins are deployed under Oracle Home
2. Agent incorporates additional functionality in Plug-In
3. Agent and Plug-in
DB Server on Exadata DBM
3. Agent and Plug-in communicates with Storage Server
4. Plug-Ins are available for monitoring all Exadata hardware components
5. OEM Agent communicates with the OEM

NEW QUESTION 18
Which three factors should you consider when choosing a method for migrating a database to the Database Machine?

• A. Type of database workload
• B. Number of tablespaces in the source database
• C. Size of the source database
• D. Endian format of the source database
• E. ASM attributes and allocation unit (AU) size of the diskgroups used by the source database

Answer: ACD

Explanation:
A: Use Real Production Workload
– Real Application Testing (RAT)
• Database Workload Replay
• SQL Performance Analyzer (SPA)
D:
* Endian format: Non-Exadata format
Reference: Exadata MAA Best Practices, Migrating Oracle Databases

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

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

Answer: ABD

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

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