Tag: databases

Questions Related to databases

  1. CELL_OFFLOAD_PLAN_DISPLAY parameter determines whether the SQL EXPLAIN PLAN command displays the predicates that can be evaluated by Exadata Cell as STORAGE predicates for a given SQL command
technology databases

  1. True

  2. False

Show answer
Correct Option: A

AI Explanation

To answer this question, we need to understand the purpose of the CELL_OFFLOAD_PLAN_DISPLAY parameter and its effect on the SQL EXPLAIN PLAN command.

The CELL_OFFLOAD_PLAN_DISPLAY parameter determines whether the SQL EXPLAIN PLAN command displays the predicates that can be evaluated by Exadata Cell as STORAGE predicates for a given SQL command.

Option A) True - This option is correct. The CELL_OFFLOAD_PLAN_DISPLAY parameter does determine whether the SQL EXPLAIN PLAN command displays the predicates that can be evaluated by Exadata Cell as STORAGE predicates for a given SQL command. If the parameter is set to true, the predicates that can be offloaded to the Exadata storage cells are displayed in the EXPLAIN PLAN output.

Option B) False - This option is incorrect. The CELL_OFFLOAD_PLAN_DISPLAY parameter does determine whether the SQL EXPLAIN PLAN command displays the predicates that can be evaluated by Exadata Cell as STORAGE predicates for a given SQL command.

The correct answer is A) True. This option is correct because the CELL_OFFLOAD_PLAN_DISPLAY parameter does have an effect on whether the SQL EXPLAIN PLAN command displays the predicates that can be evaluated by Exadata Cell as STORAGE predicates for a given SQL command.

CELL_OFFLOAD_ PLAN_DISPLAY parameter can be changed at system or session level

technology databases

  1. True

  2. False

Show answer
Correct Option: A

The valid values of CELL_OFFLOAD_ PLAN_DISPLAY are

technology databases

  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

Show answer
Correct Option: B

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

  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

Show answer
Correct Option: A,B,D

For heavily partitioned tables, do not use SQL*Loader to load data. Instead put the data in a flat file and use parallel INSERT direct load from the flat file using the external table features of database.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

disk_repair_time parameter is used to do following
technology databases

  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

Show answer
Correct Option: B
  1. The disk_repair_time attribute does not change the repair time for disks currently offline
technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

  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

Show answer
Correct Option: A,B,C

If you want to change the disk repair time value for the disk that is offline, you should use command “ALTER DISKGROUP data OFFLINE DISK data_CD_06_cell11 DROP AFTER 20h”
technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

Show answer
Correct Option: A,C,D