Online Access Free 1Z0-027 Exam Questions

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.Nested loop Join filtering
• B.Hash join filtering
• C.Column filtering
• D.Virtual column filtering
• E.Sort merge join filtering
• F.Predicate filtering

You are about to run the oplan utility to patch the servers on your test Database Machine befiore patching the
production environment.
The fiollowing task might be perfiormed:
A) Test the fiailback procedure
B) Run the exachk utility
C) Read the README file.
D) Automate the patch application process as appropriate.
E) Verifiy that the patch provides the fiunctionality it is meant to.
F) Apply the patch.
G) Evaluate the system perfiormance.
In which order should the tasks be perfiormed to patch in the recommended fiashion?

• A.C, B, D, F, B, E, G, A
• B.C, B, D, F, E, A, G
• C.C, B, D, F, B, E, A
• D.C, B, D, F, E, G, A
• E.C, D, F, B, E, G, A, B

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

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

Which three statements are true about the initial storage configuration after the standard deployment ofi a new
database Machine?

• A.There is a firee space available on the hard disks inside the database servers fior possible extension ofi the /u01 file
  system.
• B.The Data_<DBM_Name> and RECO_<DBM_Name> ASM diskgroups are built on top ofi the non-interleaved
  griddisks.
• C.There is no firee disk available on the flashdisk inside the Exadata storage servers fior possible use as flash-based
  griddisks.
• D.There is no firee disk space available on the hard disk inside the database servers fior possible extensions ofi the /u01
  file system.
• E.The Data_<DBM_Name> and RECO_<DBM_Name> ASM diskgroups are built on part ofi the interleaved griddisks.
• F.There is firee space available on the flashdisk inside the Exadata storage servers fior possible use as flash-based
  griddisks.

Which three are true about Smart Flash log?

• A.LGWR will not wait fior writes to Smart Flash log ifi the write to a disk based log file completes first.
• B.You can remove Smart Flash Log firom a single storage server with the drop flashing command.
• C.I/O Resource Manager database plans can be used to enable or disable Smart Flash Log fior different databases.
• D.Smart Flash Log is enabled by defiault, using 1024 MB ofi Rash storage on each storage server.
• E.I/O Manager category plans can be used to enable or disable Smart Flash Log For different I/O categories.