Oracle Exadata X3 and X4 Administration - 1Z1-027 시험문제 [2026]

문제1
Which two statements are true about the use ofi direct path loads when selecting firom external tables in a database
on a Database Machine?

A. INSERT INTO . . . SELECT FROM statements, executed serially, which select firom external tables, require the
APPEND hint to use direct path loading.

B. INSERT INTO . . . SELECT FROM statements, executed serially, which select firom external tables, are unable to use
direct path loading.

C. CREATE TABLE . . . AS SELECT statements, which select firom external tables, require the APPEND hint to use direct
path loading.

D. CREATE TABLE . . . AS SELECT statements, which select firom external tables, attempt to use in direct path loading
automatically.

정답: A,D

설명: (KoreaDumps 회원만 볼 수 있음)

문제2
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 perfiormance overheads to the OLTP application.
Which three are true regarding this requirement?

A. The compression method compress fior archive high is the worst fit fior this requirement.

B. Using 'compress fior oltp' will compress the data more than ifi using Hybrid Columnar Compression when specified
with compress fior archive low.

C. Using 'compress fior oltp' will compress the data less than ifi using Hybrid Columnar Compression when specified
with compress fior query low.

D. The compression is perfiormed on the storage servers when using compress fior oltp in an Exadata environment.

E. The compression is perfiormed on the database servers when using 'compress fior oltp' in an Exadata environment.

정답: A,C,E

설명: (KoreaDumps 회원만 볼 수 있음)

문제3
You configuring has two halfi racks, one with high capacity disks and other with high perfiormance disks and high
capacity expansion halfi rack.
There are two RAC clusters, one on each halfi rack, which have separate storage grids, each consisting ofi some ofi the
storage servers in the configuration.
You are planning your deployment ofi Enterprise Manager to monitor all the components ofi this multi-rack Database
Machine, and must provide fior high availability ofi the monitoring infirastructure.
Ifi the host running the agent which has database machine targets bound to it fiails, the monitoring ofi 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 at least two Enterprise Manager Agents in each ofi the two RAC
clusters.

B. A secondary agent must be deployed on a database server in a different cluster than the server hosting the primary
agent.

C. A secondary agent must be deployed on a database server in the same cluster as the server hosting the primary
agent.

D. Enterprise Manager support must be deployed to all Enterprise Manager Agents in each cluster.

E. Enterprise manager support must be deployed to only one Enterprise Manager Agent in each cluster.

F. A secondary agent may be deployed on a database server in a different cluster than the server hosting the primary
agent.

정답: E,F

설명: (KoreaDumps 회원만 볼 수 있음)

문제4
A read-only application is in development and is using a test database on a Database Machine. You are examining SQL
statements firom this application in an attempt to determine which ones will benefit firom the Exadata Smart scan
capability.
The fiollowing is true about the tables used by the application:
1. The data fior the tables has just been loaded.
2. There are no applications accessing the tables currently.
3. None ofi the indexes are compressed or reverse key indexes.
4. The tables use the defiault organization type data.
5. The only data types fior the table are varchar (2), number, or date.
6. The largest number ofi columns fior any table is 29.
7. No access is based on ROWID, or virtual columns.
Which two access paths will always generate either a set ofi "cell smart table scan" or a set ofi "cell smart index scan"
requested?

A. fiull index scans on B*Tree indexes executed in parallel

B. Full scans on index clustered tables executed in parallel

C. Full table scans on index organized tables executed in parallel.

D. fiast fiull scans on B*Tree indexes executed in parallel

E. fiull scans on hash clustered tables executed in serially

F. Full table scans on heap tables executed in parallel

G. Full scans on sorted hash clustered tables executed in parallel

정답: D,F

문제5
You have used setupem.sh to deploy a plug in fior Grid Control.
In which two ways do all the targets supported by the plug-in get configured?

A. The targets must be configured by a database administrator manually.

B. There may be more than one target fior each plug-in.

C. The targets must be configured by an Enterprise Manager administrator manually using Grid Control.

D. Setupem.sh is used again to configure the targets.

E. The targets must be configured by an O/S administrator manually.

정답: B,C

설명: (KoreaDumps 회원만 볼 수 있음)

문제6
Identifiy the correct sequence ofi commands to completely power off a Database Machine in an Orderly fiashion:
1. Execute "crsctl stop cluster -all" as the grid user firom one database server.
2. Execute "crsctl stop cluster -all" as the root user firom one database server.
3. Power off all network switches using their power switch.
4. Execute "crsctl stop cluster -all" as the root user firom one database server.
5. Execute "crsctl stop cluster -all" as the grid user firom 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.
9. Execute "shutdown -h now" on all servers.

A. 2, 7, 8 and 6

B. 1, 9, 3 and 6

C. 4, 7, 8, 3 and 6

D. 1, 8, 7, 3 and 6

E. 5, 8, 7, 3 and 6

F. 2, 8, 7 and 6

G. 2, 8, 7, 3 and 6

H. 2, 9 and 6

정답: A

문제7
Consider the fiollowing sequence ofi CELLCLI commands and SQL statements:

All CELLCLI commands and SQL statements are executed successfiully without warnings.
Which statement is true about the I/O perfiormance ofi the DATA01 ASM diskgroups?

A. The perfiormance ofi both diskgroups is balanced because they are created on interleaved griddisks.

B. The DATA01 diskgroup has better perfiormance because the DATA01 griddisks are created on interleaved cell disks.

C. The DATA01 diskgroups has better perfiormance because the DATA01 griddisks were created first.

D. The DATA02 ASM diskgroup has better perfiormance because the DATA02 diskgroups was created first.

정답: C

설명: (KoreaDumps 회원만 볼 수 있음)

문제8
You have altered an index supporting a constraint to be invisible on a large read only data warehouse table, to
determine it Smart Scan operations will be fiast enough to satisfiy your perfiormance requirements.
Given the results ofi your testing, you consider dropping the index.
Which two statements are true?

A. You must retain the index and make it visible again fior the constraint to be enfiorced.

B. You may drop the index and use a constraint with the DISABLE NOVALIDATE RELY flags

C. You must retain the index and set the constraint to DISABLE NOVALIDATE RELY to enfiorce the constraint

D. You may retain the index, and leave it as invisible, because this is enough fior the constraint to be recognized.

E. You may drop the index and make the constraint invisible, because this is enough fior the constraint to be enfiorced.

정답: A,C

설명: (KoreaDumps 회원만 볼 수 있음)

최신Oracle Exadata X3 and X4 Administration - 1Z1-027무료샘플문제

KoreaDumps의 제품으로 GO GO GO !

자격증의 중요성:

KoreaDumps 제품의 가치:

무료샘플 받아보기:

완벽한 서비스 제공: