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

Which two are true about Smart Scan?

• A.Some joins can be offloaded to the storage servers.
• B.a query rewrite may occur to a container table stored in Exadata but will never benefit From Smart scan.
• C.A query rewrite may occur to a container table stored Exadata, and it will always benefit firom Smart Scan.
• D.It is possible to offload single row fiunctions to the storage servers.
• E.Column projection does not contribute to the perfiormance benefit ofi Smart Scan
• F.All joins can be offloaded to the storage servers.

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

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

You plan to migrate your Oracle Version 11.1.0.2 database to your Exadata Database Machine.
The database supports an online transaction processing (OLTP) workload and is currently hosted on a Little Endian
platform
Which two are the supported and appropriate migration methods to minimize downtime?

• A.Migrate using cross platform Transportable Database.
• B.Upgrade source database to 11.2.0 and migrate using a physical standby database.
• C.Migrate using Data Pump.
• D.Migrate using GoldenGate.
• E.Migrate using ASM online migration.

A table in one ofi your database schemas contains only varchar, number, and date data types fior the columns.
Which three operations can be offloaded to the Exadata storage servers when doing a smart scan against this table, ifi
no other situations arise that prevent Smart Scan firom occurring?

• A.Virtual column filtering
• B.Predicate filtering
• C.Sort merge join filtering
• D.Nested loop Join filtering
• E.Hash join filtering
• F.Column filtering

Which is true regarding Enterprise Manager monitoring and configuration?

• A.Monitoring the power distribution units (PDUs) is done by Enterprise Manager agents, but additional ethernet
  cables are required to connect the PDUs to the internal network switch in the Database Machine
• B.Agents must be deployed on the- storage servers, in case all the database servers are down.
• C.Monitoring the power distribution units (PDUs) is done by Enterprise Manager agents without, any additional
  network configuration.
• D.Monitoring the power distribution units (PDUS) is done by Enterprise Manager agents but additional ethernet
  cables are required to connect the PDUs to the corporate network switch.
• E.Agents may be deployed on the storage servers, in case all the database servers are down.