Online Access Free 1Z0-027 Practice Test

Which three are true regarding the use ofi Storage Indexes?

• A.Storage Indexes occupy space in the Smart Flash Cache.
• B.Different storage regions may have different columns indexed fior the same table.
• C.The use ofi Storage Indexes fior particular categories ofi I/O can be disabled by using an I/O Resource Manager
  Category Plan.
• D.The use ofi Storage indexes fior a particular database can be disabled by using an I/O Resource Manager Database
  Plan.
• E.A Storage index is automatically maintained by CELLSRV based on the filter columns ofi the offload SQL.
• F.A maximum ofi eight table columns fior any table are Indexed per storage region.

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 MS process
• B.SNMP traps fior alerts are sent by the storage server ILOM to the Enterprise Manager agent.
• 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 storage server RS process.
• E.SNMP traps fior alerts are sent by the storage server MS process to the enterprise Manager agent

Which three must be true fior Smart Scans to be done?

• A.Setting _serial_direct_read=true in the session issuing the SQL statements
• B.Having direct path reads used at run time
• C.Cell_offload_process = true fior the ASM diskgroup containing the tablespace in which tables accessed by a query
  are stored.
• D.Having a 4 meg AU size fior the ASM diskgroup containing the tablespace in which tables accessed by a query are
  stored
• E.Executing a query in parallel
• F.cell.smart_scan_capable=true fior the ASM diskgroup containing the tablespace in which tables accessed by a query
  are stored.

To guarantee proper cooling, you plan to place perfiorated floor tiles near your Database Machine.
Where, in relation to the cabinet, should they be placed?

• A.On the left side, because the air flow is firom left to right
• B.At the back, because the air flow is firom back to firont
• C.Underneath the cabinet, because the air flow is firom bottom to top
• D.At the firont, because the air flow is firom firont to back
• E.On the right side, because the air flow is firom right to left.

Identifiy two valid reasons fior creating multiple griddisks on a Single celldisk.

• A.To segregate storage into multiple pools that can be assigned to different databases
• B.To enable disk mirroring fior the system area
• C.To segregate storage into multiple pools with different perfiormance characteristics
• D.To segregate storage into multiple pools that can be assigned to different resource consumer groups in the same
  database.
• E.To fiacilitate normal or high redundancy ASM diskgroups