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.

The CELL_OFFLOAD_PROCESSING parameter is set to FALSE.

The optimizer uses direct path read.

A scan is performed on a clustered table.

A scan is performed on an index-organized table.

A fast full scan is performed on compressed indexes.

A fast full scan is performed on reverse key indexes.

The table has row dependencies enabled or the rowscn is being fetched.

The optimizer wants the scan to return rows in ROWID order.

The command is CREATE INDEX using nosort.

A LOB or LONG column is being selected or queried.

A scan is performed on a flashback table.

A query that has more than 255 columns referenced

A query that has more than 255 columns referenced and HCC compressed

The tablespace is encrypted, and the CELL_OFFLOAD_DECRYPTION parameter is set to false

The tablespace is encrypted, and the CELL_OFFLOAD_DECRYPTION parameter is set to true

A scan is performed on a flashback table.

A query that has more than 255 columns referenced

A query that has more than 255 columns referenced and HCC compressed

The tablespace is encrypted, and the CELL_OFFLOAD_DECRYPTION parameter is set to false

The tablespace is encrypted, and the CELL_OFFLOAD_DECRYPTION parameter is set to true

The predicate evaluation is on a virtual column.

The tablespace is not completely stored on Exadata Cell.

A scan is performed on a flashback table.

The command is CREATE INDEX using nosort.

True

False

True

False

The return type for a method can be any Java type, including void

An important principal of object oriented programming is implementation hiding

When you perform mathematical calculations on the unlike data type, java will perform a implicit conversion to unify the types

All the Above

Column

1966_Invoices

Catch_#22

#Invoices

Drop

Delete

Cascade

Truncate

Clustered and non clustered

Unique

XML index

All the Above