Oracle Exadata X5 Administration - 1z0-070 Exam Practice Test

A. querying a table containing a JSON column

B. querying a table containing many migrated rows

C. performing a Fast Full Index scan on a reverse key index

D. referencing more than 255 columns form an OLTP compressed table in a query

E. performing a minimum or maximum function on an indexed column

F. querying a table containing many chained rows

A. Smart Scan will always use the Smart Flash Cache for all I/Os fast full index capacity.

B. Smart Scan will always use the Smart Flash Cache for all I/Os for full table scans.

C. The "keep" cache is limited to a maximum of 80% of the total Smart Flash Cache capacity.

D. Single block reads can benefit from Smart Flash Cache.

E. Multiblock reads can benefit from Smart Flash Cache.

A. 3, 4 and 8 run on the database servers; 1, 2, 5, 6 and 7 run on the Exadata storage servers.

B. 1, 2, 3, 4 and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.

C. 1, 2, 3, 4, 5, and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.

D. 1, 2, 3 and 4 run on the database servers; 5, 6, 7, and 8 run on the Exadata storage servers.

E. 2, 3, 4 and 8 run on the database servers; 1, 5, 6 and 7 run on the Exadata storage servers.

A. Number of tablespaces in the source database

B. Endian format of the source database

C. The type of database workloads

D. Size of the source database

E. The down time allowed for the migration

A. Disk repair is made immediately from Smart Flash Cache for corruption on disk when the corresponding data is dirty in the Smart Flash Cache.

B. Hard disks are scanned every two weeks by default but only when disks are idle.

C. Disk repair may be made from another mirror copy if the corrupt area is part of a Normal or High Redundancy Disk Group.

D. Hard disks are scanned every two weeks by default in all situations.

E. Disk repair is made immediately from Smart Flash Cache for corruption on disk when the corresponding data is clean in the Smart Flash Cache.

A. It improves single-row lookup performance.

B. It is enabled by default.

C. It automatically transforms ROW STORE COMPRESS compressed data into a pure columnar format during Exadata Smart Flash Cache population.

D. It automatically transforms Hybrid Columnar Compressed (HCC) data into a pure columnar format during Exadata Smart Flash Cache population.

E. It can be enabled or disabled for individual databases by using I/O Resource Manager database plans.

F. Data is either cached in Hybrid Columnar Compressed format or in pure compressed format, but never in both formats at the same time.

A. Reduced I/O latency for reads due to read flashcache on all Exadata X5 and later models

B. An improved highly efficient undo and redo architecture

C. Ultra high I/O performance for reads and writes when using Exadata Extreme Flash in X5 and later models

D. Reduced I/O latency for writes due to writeback flashcache on all Exadata X5 and later models

E. Faster optimization due to an Exadata-specific optimizer