Tag: databases

True

False

True

False

True and False

b. AUTO, ALWAYS and NEVER with default as AUTO

Yes and No

b. AUTO, ALWAYS and NEVER with default as NEVER

None of the above

a. CELL_PARTITION_LARGE_EXTENTS initialization parameter can be used to set the INITIAL storage parameter to a preferred value for all segments in a partitioned object

b. This parameter is relevant only to LMT with AUTOALLOCATE option

c. This parameter is relevant only to LMT with UNIFORM option

d. This parameter does not impact non-partitioned object and has valid values as TRUE, ALWAYS and DEFAULT

True

False

a. Specifies the repair time in hours for any failed disk

b. The amount of time a disk can remain offline before it is dropped by Oracle ASM

c. The amount of time a disk will remain on-line if there is any fault

None of the above

True

False

a. The CELL_FLASH_CACHE storage clause attribute allows the override of the automatic caching policy, when the compatible parameter is greater than or equal to 11.2.0.0

b. The CELL_FLASH_CACHE storage clause attribute can be used to specify how specific database objects are cached in Exadata Smart Flash Cache

c. It can have values NONE, DEFAULT and KEEP

None of the above

True

False

The CELL_OFFLOAD_PROCESSING parameter is set to FALSE.

The CELL_OFFLOAD_PROCESSING parameter is set to TRUE

The table or partition being scanned is small.

The optimizer does not use direct path read.