Online Access Free 1z1-070 Practice Test

Which two statements are true about the X5 Exadata storage server rescue procedure?

• A.The rescue procedure can be executed from the CELLBOOT USB flash drive.
• B.The rescue procedure can be used to restore a corrupt system area.
• C.The rescue procedure can be used to repair corruption in an ASM diskgroup.
• D.The rescue procedure must be used to recover from a failed Exadata storage server software upgrade.
• E.An Exadata storage server automatically enters the rescue environment when it cannot boot from the system area.

Which two completely prevent a Smart Scan from occurring?

• A.referencing more than 255 columns form an OLTP compressed table in a query
• B.querying a table containing a JSON column
• C.performing a minimum or maximum function on an indexed column
• D.performing a Fast Full Index scan on a reverse key index
• E.querying a table containing many migrated rows
• F.querying a table containing many chained rows

Which four are true about Exadata features?

• A.Hybrid Columnar Compressed tables can be compressed and decompressed on Exadata storage servers.
• B.Storage Indexes persist across database server reboots.
• C.Hybrid Columnar Compressed tables can be compressed and decompressed on the database servers.
• D.Data Warehouse workloads will benefit from Smart Flash Cache configured in Write-Through mode.
• E.Storage Indexes persist across Exadata storage server reboots.
• F.OLTP workloads will benefit from Smart Flash Cache configured in Write-Back mode.

Identify the four software components that run only on an Exadata Database Machine Database Server.

• A.DSKM
• B.ASM instance
• C.Automatic Diagnostic Repository Command Interpreter (ADRCI)
• D.CELLCLI
• E.DISKMON
• F.Cell Serve (CELLSRV)
• G.Oracle Enterprise Manager Agent (OMA)

A heap-organized table in one of your database schemas contains only date, char, varchar2, and number data type columns.
Which three operations can be offloaded to Exadata Storage Servers when performing a Smart Scan on this table?

• A.Predicate filtering
• B.Sort-merge join filtering
• C.Virtual column filtering
• D.MIN/MAX scans
• E.Column filtering
• F.Nested loop join filtering