0

databases Online Quiz - 54

Description: databases Online Quiz - 54
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

The valid values of CELL_OFFLOAD_ PLAN_DISPLAY are

  1. True and False

  2. b. AUTO, ALWAYS and NEVER with default as AUTO

  3. Yes and No

  4. b. AUTO, ALWAYS and NEVER with default as NEVER

  5. None of the above


Correct Option: B
  1. 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

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

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

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


Correct Option: A,B,D
  1. a. Specifies the repair time in hours for any failed disk

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

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

  4. None of the above


Correct Option: B
  1. The disk_repair_time attribute does not change the repair time for disks currently offline
  1. True

  2. False


Correct Option: A

Which of the following statement(s) is (are) true?

  1. 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

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

  3. c. It can have values NONE, DEFAULT and KEEP

  4. None of the above


Correct Option: A,B,C
  1. The CELL_OFFLOAD_PROCESSING parameter is set to FALSE.

  2. The CELL_OFFLOAD_PROCESSING parameter is set to TRUE

  3. The table or partition being scanned is small.

  4. The optimizer does not use direct path read.


Correct Option: A,C,D
  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.


Correct Option: A,C,D,E

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

  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.


Correct Option: A,B,C,D,E
  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


Correct Option: A,B,D
  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


Correct Option: A,B,D

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

  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.


Correct Option: A,B,C,D
  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


Correct Option: D
  1. Column

  2. 1966_Invoices

  3. Catch_#22

  4. #Invoices


Correct Option: C

What types of indexes are supported by SQL Server 2005?

  1. Clustered and non clustered

  2. Unique

  3. XML index

  4. All the Above


Correct Option: D
- Hide questions