Examice

Exam 1z0-082 All QuestionsBrowse all questions from this exam

Go to Exam

Question 136

Examine the description of the PRODUCT_DETAILS table:

Which two statements are true? (Choose two.)

PRODUCT_ID can be assigned the PRIMARY KEY constraint.

EXPIRY_DATE cannot be used in arithmetic expressions.

PRODUCT_NAME cannot contain duplicate values.

EXPIRY_DATE contains the SYSDATE by default if no date is assigned to it.

PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it.

PRODUCT_PRICE contains the value zero by default if no value is assigned to it.

Correct Answer: A, E

PRODUCT_ID can be assigned the PRIMARY KEY constraint because it is not null and can uniquely identify each row in the table. PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it, because a NULL value in arithmetic operations typically results in NULL, but it does not prevent the expression from being used.

Discussion

Juv07Options: AE

A E is the good answers

ivanadjOptions: AE

The same question as 1z0-071 Question #: 229

Oracle2020Options: AE

I AGREE AE

auwiaOptions: AE

Provided answer are wrong. The base! :-) part VII