Free Oracle 1Z0-027 Exam Dumps Questions & Answers

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.CREATE TABLE . . . AS SELECT statements, which select firom external tables, require the APPEND hint to use direct
  path loading.
• B.CREATE TABLE . . . AS SELECT statements, which select firom external tables, attempt to use in direct path loading
  automatically.
• C.INSERT INTO . . . SELECT FROM statements, executed serially, which select firom external tables, are unable to use
  direct path loading.
• D.INSERT INTO . . . SELECT FROM statements, executed serially, which select firom external tables, require the
  APPEND hint to use direct path loading.

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 MS process to the enterprise Manager agent
• 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 ILOM to the Enterprise Manager agent.
• 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 storage server ILOM

Which two are true concerning the allocation ofi I/O resources by the IORM within the CELLSRV process?

• A.Ifi two consumer groups P and Q In the PROD database get 20% and 10% respectively ofi resource allocation, then
  the percentage ofi I/O resource would be the same ifi they got 10% and 5% respectively, and the Interdatabase plan
  has changed, provided that the category plan is unchanged, and consumer groups A and B are still mapped to the
  same categories.
• B.Log Writer I/O and Control File I/O are high priority I/O managed automatically by IORM.
• C.Ifi two consumer groups C and D In the PROD database get 10% and 15% respectively ofi resource allocation, then
  the percentage ofi I/O resource would be the same ifi they still got 10% and 15% respectively and were remapped to a
  different category by the DBA, provided that the category plans and Interdatabase plans are unchanged.
• D.Ifi two consumer groups A and B in the PROD database get 10% and 15% respectively ofi resource allocation, then
  the percentage ofi I/O resource would be the same ifi they got 20% and 30% respectively, provided that the category
  plans and inter database plans are unchanged, and consumer groups A and B are still mapped to the same category.
• E.Database Writer I/O is considered to be the highest priority I/O and is managed based on attributes ofi the IORM
  plan.

Which two activities are supported on the storage servers in the Database Machine?

• A.changing root password
• B.upgrading a device driver fior hard disks when inserting a replacement disk after a hard disk fiailure
• C.upgrading the Storage Server software package using RPN
• D.Installing an alternative package manager
• E.configuring secure shell user equivalency fior the callmonitor user

Identifiy the three components that serve a purpose only in the Database Machine.

• A.I/O Resource Manager (IORM)
• B.ASM intelligent Data Placement (IDP)
• C.Database Filesystem (DBFS)
• D.Database Resource Manager (DBRM)
• E.The DISKMON process
• F.Intelligent Database Protocol (IDB)