1Z0-027 試験問題を無料オンラインアクセス

You are monitoring and evaluating a create index statement on your Database Machine and have run the fiollowing
query after executing statement, providing the output. Shown:

Select two reasons why the statement would have produced so many "cell single block physical read" waits compared
to "cell smart table scan" waits.

• A.There are huge numbers ofi migrated rows in the table on which the index is being built.
• B.There is a ROWID column in the table on which the index is being built.
• C.There is an uncommitted transaction that has modified one block ofi the table on which the index is being built, in
  each cell.
• D.There are huge numbers ofi chained rows in the table on which the index is being built.
• E.There is a transaction that has modified one block ofi the table on which the index is being built in each cell, which
  committed after the create index began.

What is the benefit ofi bonding the client access network configuration?

• A.A Single Client Access Name (SCAN)
• B.Improved perfiormance
• C.Both improved perfiormance and reliability
• D.Improved monitoring
• E.Improved reliability

In which two locations should files be staged, to be loaded using external tables into a database on a Database
Machine?

• A.On local storage on one or more cells that are accessible to the database server where the load will be perfiormed.
• B.On an Exadata-based ACFS file system on the Database Machine
• C.On a dbfis file system stored in a staging database on the Database Machine
• D.On an nfis file system mounted on a database server where the external table will be accessed.

Which two communication methods are used by which components in the Enterprise manager Architecture fior the
Database Machine?

• A.SNMP traps fior alerts are sent by the storage server ILOM to the storage server RS process.
• B.SNMP traps fior alerts are sent by the storage server ILOM to the storage server MS process
• C.SNMP traps fior alerts are sent by the storage server MS process to the storage server ILOM
• D.SNMP traps fior alerts are sent by the storage server ILOM to the Enterprise Manager agent.
• E.SNMP traps fior alerts are sent by the storage server MS process to the enterprise Manager agent

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 perfiormance problems as fiollows:
You noticed increased latency fior the database log writer, especially during the quarterly battery learn cycle on the
cells.
You have complaints ofi erratic perfiormance firom certain write-intensive applications.
Which two actions could improve perfiormance in these areas?

• A.Use ALTER TABLE in the database to set CELL_FLASH_CACHE = KEEP fior the tables belonging to the affected
  application.
• B.Configure the table belonging to the affected application using CELLCLI, to the set CELL_FLASH_CACHE = KEEP.
• C.Enable write-back flashcache by setting lunWriteCacheMode to Write Back Mode.
• D.Configure Smart Flash Log on the cells to use some ofi these ofi the space on the cell flash devices.
• E.Configure Smart Flash Log on the database server to use server flash memory.