Tag: databases

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