Limited Time Discount Offer 30% Off - Ends in 02:00:00

×

Oracle 1z0-027 Exam - Oracle Exadata X3 and X4 Administration

Questions & Answers for Oracle 1z0-027

Showing 1-15 of 72 Questions

Question #1

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.

Question #2

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.

Question #3

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

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.

Question #4

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

A. database character set

B. size of the RECO ASM diskgroup

C. size of the DBFS diskgroup

D. O/S owner mode (standard O/S authentication or role-separated O/S authentication)

E. RDBMS DBA group name

Explanation: D: Determine which OS owner mode to use

Question #5

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.

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.

Question #6

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.

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

Question #7

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.

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

Question #8

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

Question #9

You are about to replace one memory DIMM in an Exadata storage server and need to
power off the affected cell.
Which four commands must you execute to safely power off the storage server in your
standard deployed quarter rack Database Machine assuming that redundancy is not
compromised?

A. ‘crsctl stop cluster -all’ on one of the database servers

B. CellCLI> LIST GRIDDISK ATTRIBUTE name WHERE asmdeactivationoutcome != ‘Yes’

C. CellCLI> ALTER GRIDDISK ALL INACTIVE

D. CellCLI> LIST GRIDDISK WHERE STATUS != ‘inactive’

E. ‘shutdown –h now’ on the affected cell

Explanation:
B: Step 1:
Run the following command to check if there are other offline disks
CellCLI> LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes'
If any grid disks are returned, then it is not safe to take the storage server offline because
proper Oracle ASM disk group redundancy will not be intact.
C: Step 2:
Inactivate all the grid disks when Oracle Exadata Storage Server is safe to take offline
using the following command:
CellCLI> ALTER GRIDDISK ALL INACTIVE
Taking the storage server offline when one or more grid disks are in this state will cause
Oracle ASM to dismount the affected disk group, causing the databases to shut down
abruptly.
D: Step 3:
-- Verify all grid disks are INACTIVE to allow safe storage server shut down by running the
following command:CellCLI> LIST GRIDDISK ATTRIBUTES name,
asmmodestatusCellCLI> LIST GRIDDISKIf all grid disks are INACTIVE, then the storage
server can be shutdown without affecting database availability
E: Step 4:
To stop a server, use the shutdown command. To stop immediately and keep it down, i.e.
not reboot, execute:
#
shutdown -h -y now

Question #10

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

Question #11

Identify two valid reasons for creating multiple griddisks on a Single celldisk.

A. To segregate storage into multiple pools with different performance characteristics

B. To facilitate normal or high redundancy ASM diskgroups

C. To enable disk mirroring for the system area

D. To segregate storage into multiple pools that can be assigned to different databases

E. To segregate storage into multiple pools that can be assigned to different resource consumer groups in the same database.

Question #12

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.

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

Question #13

Your database Machine has the exachk utility pre-installed and you decide to use it
periodically, to validate the installation against Oracles 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.

Question #14

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.

Question #15

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.

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.

You Need Avanset VCE Player in Order to Open VCE Files

AUTUMN SALE: 30% DISCOUNT
This is ONE TIME OFFER

You save
30%

Enter Your Email Address to Receive Your 30% Discount Code

AUTUMN SALE: 30% DISCOUNT

You save
30%

Use Discount Code:

A confirmation link was sent to your e-mail.

Please check your mailbox for a message from [email protected] and follow the directions.