Tag: databases

Questions Related to databases

Predicate evaluation is not offloaded to Exadata Cell in the following cases:
technology databases

  1. The CELL_OFFLOAD_PROCESSING parameter is set to FALSE.

  2. The optimizer uses direct path read.

  3. A scan is performed on a clustered table.

  4. A scan is performed on an index-organized table.

  5. A fast full scan is performed on compressed indexes.

Show answer
Correct Option: A,C,D,E

Predicate evaluation is not offloaded to Exadata Cell in the following cases:

technology databases

  1. A fast full scan is performed on reverse key indexes.

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

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

  4. The command is CREATE INDEX using nosort.

  5. A LOB or LONG column is being selected or queried.

Show answer
Correct Option: A,B,C,D,E

Predicate evaluation is not offloaded to Exadata Cell in the following cases

technology databases

  1. A scan is performed on a flashback table.

  2. A query that has more than 255 columns referenced

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

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

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

Show answer
Correct Option: A,B,D

Predicate evaluation is not offloaded to Exadata Cell in the following cases

technology databases

  1. A scan is performed on a flashback table.

  2. A query that has more than 255 columns referenced

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

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

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

Show answer
Correct Option: A,B,D

Predicate evaluation is not offloaded to Exadata Cell in the following cases:
technology databases

  1. The predicate evaluation is on a virtual column.

  2. The tablespace is not completely stored on Exadata Cell.

  3. A scan is performed on a flashback table.

  4. The command is CREATE INDEX using nosort.

Show answer
Correct Option: A,B,C,D

When the disk repair time value is increased, the vulnerability of a double failure is increased
technology databases

  1. True

  2. False

Show answer
Correct Option: A

In order to know which SQL operator or function can be referenced in predicate without violating the Exadata Cell offload, you can query OFFLOADABLE column of V$SQLFN_METADATA view. The value “NO” indicates offloading is allowed.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which of the following statements are true?

technology databases

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

  2. An important principal of object oriented programming is implementation hiding

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

  4. All the Above

Show answer
Correct Option: D

Which of the following can be a valid column name?

technology databases

  1. Column

  2. 1966_Invoices

  3. Catch_#22

  4. #Invoices

Show answer
Correct Option: C

Which command will delete all data from a table and will not write to the rollback segment?

technology databases

  1. Drop

  2. Delete

  3. Cascade

  4. Truncate

Show answer
Correct Option: D