Question No. 1

Which three statements are true about table data storage in an Oracle Database? (Choose three.)

AData block headers contain their own Data Block Address (DBA)

BA table row piece can be chained across several database blocks

CMultiple row pieces from the same row may be stored in different database blocks

DMultiple row pieces from the same row may be stored in the same block

EData block free space is always contiguous in the middle of the block

FIndex block free space is always contiguous in the middle of the block

Show Answer

Correct Answer: A, B, C

https://antognini.ch/2016/10/whats-the-difference-between-row-migration-and-row-chaining/

Question No. 2

Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

Adump files

Bcontrol files

Cpassword files

Dbad files

Einput files

Show Answer

Correct Answer: B, D, E

Question No. 3

You execute this query:

SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd ''Monday for'' fmMonth rrrr')

What is the result?

AIt executes successfully but does not return any result

BIt returns the date for the first Monday of the next month

CIt generates an error

DIt returns the date for the last Monday of the current month

Show Answer

Correct Answer: B

Question No. 4

Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1.

Some sales data is duplicated in both tables.

You want to display the rows from the SALES1 table which are not present in the SALES2 table.

Which set operator generates the required output?

AINTERSECT

BUNION ALL

CUNION

DSUBTRACT

EMINUS

Show Answer

Correct Answer: E

Question No. 5

Examine the description of the PROMOTIONS table:

You want to display the unique promotion costs in each promotion category.

Which two queries can be used? (Choose two.)

ASELECT promo_cost, promo_category FROM promotions ORDER BY by 1;

BSELECT DISTINCT promo_cost || ' in ' || DISTINCT promo_category FROM promotions ORDER BY 1;

CSELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;

DSELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;

ESELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

Show Answer

Correct Answer: C, E

Free Oracle 1Z0-082 Exam Actual Questions

The questions for 1Z0-082 were last updated On Dec 20, 2024