Exam 1z0-071 All QuestionsBrowse all questions from this exam
Go to Exam
Question 50

Examine the description of the PRODUCT_DETAILS table:

Which two statements are true? (Choose two.)

    Correct Answer: B, F

    PRODUCT_ID can be assigned the PRIMARY KEY constraint since it is NOT NULL and using it as a primary key will uniquely identify records in the table, ensuring there are no duplicate values. Additionally, PRODUCT_PRICE can indeed be used in arithmetic expressions even if it has no value stored in it; however, the result of the arithmetic operation with a NULL value will itself be NULL and won't trigger any error. The other options are incorrect because EXPIRY_DATE cannot be assumed to have a default SYSDATE, PRODUCT_NAME can contain duplicate values unless explicitly constrained, and EXPIRY_DATE can indeed be used in arithmetic expressions such as adding or subtracting days.

Discussion
lucemqyOptions: BF

You can add NULL to a number it will result in NULL

SbabloOptions: CF

B is wrong, absence of data means null. An arithmetic operation with a null value always yields null

Marko_1991

what about nvl?

zouve

BF PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it, but the result will be NULL

HassanMkhlalati

But it doesn't send an error message

dexdinh91Options: BF

BF are correct

HassanMkhlalatiOptions: BF

BF correct

TheOracleWasTakenOptions: BD

We dont know if there's any duplicate values for the id column so how do we know if it can be a PK

NSilva

D. EXPIRY_DATE cannot be used in arithmetic expressions. False. You can use Arithmetic expressions in Dates, just not all of them. SELECT DATE'2023-05-20' - 1 AS expire_date, DATE'2023-05-20' + 1 AS extra_day FROM DUAL; I agree that the primary key could contain duplicated values, but is the one that seems most feasible out of the remaining options.

yanoolthecoolOptions: BF

B's correct, so is F

CMjerOptions: BF

BF correct, see discussion on same question: https://www.examtopics.com/discussions/oracle/view/8221-exam-1z0-071-topic-1-question-229-discussion/

SantiBZ_07032022_1744

Expiry_DATE cannot be used in arithmetic expressions -> FALSE.

KizTine

yes it's possible. Foe example : SELECT expiry_date + 3 FROM product_details; (to add 3 days) SELECT expiry_date + interval '1' month FROM product_details; (to add 1 month)

JCKOMI

why expiry date can not be used in arithmetic expressions ?

karols32

EXPIRY_DATE cannot be used in arithmetic expressions. - FALSE Because on date data type you can use a "MINUS" arithmetic expressions.

TheOracleWasTaken

But can you multiply a date or divide it?