Latest Oracle 1Z1-027 Actual Free Exam Questions & Community Discussion, Page 4

Question #25

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. Full table scans on index organized tables executed in parallel.

B. Full table scans on heap tables executed in parallel

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

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

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

F. Full scans on index clustered tables executed in parallel

G. fiull scans on hash clustered tables executed in serially

Discussion 0

Correct Answer: B,E Vote an answer

Question #26

You are examining the existing IORM configuration on the cells ofi Database Machine, to see ifi they require my
modifications based on recent changes to various workloads.
All seven cells in your X3-2 halfi-rack shown the fiollowing:

Which two are true about I/O to the cells using this plan?

A. I/O requests in the batch category may use flashcache ifi the I/O is firom the sales finance database, and these I/O
requests are guaranteed to get 80% ofi the I/O ifi the interactive category I/Os use no more than 20%.

B. I/O requested in the interactive category may use flashdns ifi the I/O is firom the sales or finance databases, and
these I/O requests are guaranteed to get 90% ofi the I/O ifi the enough I/Os are issued in this category.

C. No I/Os in any category or firom any database may use flashing or flashcache because the objective is off.

D. I/O requests firom the sales database may use flashing regardless ofi the I/O category.

E. I/O requests made by sessions in the marketing database may use flashing and flashcache ifi no other categories or
database or database are using flashing and flashcache at the same time.

Discussion 0

Correct Answer: A,D Vote an answer

Question #27

You are evaluating the perfiormance ofi a SQL statement that accesses a very large table, and have run the fiollowing
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 fior 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 fior 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 fior block in the cells.

C. 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 fior blocks in the cells.

D. 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 fior blocks in the cells.

E. There is an uncommitted transaction that has modified some ofi the table blocks, causing some "cell single block
physical reads" to be requested by the database instance, resulting in additional I/O fior block in the cells.

Discussion 0

Correct Answer: B,C Vote an answer

Question #28

You plan to migrate an Oracle database that supports an online transaction processing (OLTP) workload to your
Database Machine.
Following are details fior the source database:
Database version: 10.2.0
Byte order: Big Endian HP-UX (64-bit)
Database size: 24 TB
Storage: ASM with 1 MB allocation unit size
Which two are supported migration methods?

A. Physical migration using ASM online Migration

B. Logical migration using Oracle Streams

C. Logical migration using logical standby

D. Local migration using Oracle Streams

E. Physical migration using Transportable Database

Discussion 0

Correct Answer: B,C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #29

You must drop all celldisks on all the cells in a quarter rack as part ofi a reconfiguration project, to support normal
redundancy interleaving.
Select two actions that describe the operating system (O/S) account on the cells to which you should log in, and the
tool that may be used to drop the celldisks.

A. To the CELLMONITOR account calling CELLCLI on all cells using DCLI

B. To the CELLADMIN account using CELLCLI interactively on each cell

C. To either the CELIMONITOR or the CELLADMIN account calling CELLCLI on all cells using DCLI

D. To either the CELLMONITOR or CELLADMIN account calling interactively on each cell

E. To CELLADMIN account calling CELLCLI on all cells using DCLI

F. To the CELLMONITOR account using CELLCLI interactively on each cell.

Discussion 0

Correct Answer: B,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #30

Which three are true abort Enterprise Manager plug- in configuration fior the Database Machine?

A. There is one plug-in fior Cloud Control.

B. Some plug-ins require SNMP trap fiorwarders.

C. There is one plug-in fior Grid Control.

D. There are several separate plug-ins fior Cloud Control.

E. There are several separate plug-ins fior Grid Control.

F. All plug-ins require SNMP trap fiorwarders.

Discussion 0

Correct Answer: B,D,E Vote an answer

Question #31

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 the same cluster as the server hosting the primary
agent.

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

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

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

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

Discussion 0

Correct Answer: C,F Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #32

To troubleshoot a possible hardware problem, you consider moving all disk drives firom one Exadata storage server to a replacement chassis.
You must contain storage availability while perfiorming task.
The Exadata storage server is an X3-8 Database Machine and storage grid is not partitioned.
Which two fiactors would prevent you firom moving the disks firom one Exadata storage server to another one?

A. Offline or inactive celldisks in another Exadata server

B. The existence ofi a normal redundancy ASM diskgroup

C. The existence ofi an ASM diskgroup with its compatible.asm attribute set to 10.2.0.0.0

D. The existence ofi an external redundancy ASM diskgroup

E. The existence ofi an ASM diskgroup with the repair_time attribute set to 0.

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Oracle 1Z1-027 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1Z1-027 Demo