Oracle
1Z0-071 · Question #262
Examine the description of the PRODUCT_DETAILS table: Which two statements are true? (Choose two.)
The correct answer is B. PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it. D. PRODUCT_ID can be assigned the PRIMARY KEY constraint. See the full explanation below for the reasoning.
Question
Examine the description of the PRODUCT_DETAILS table:
Which two statements are true? (Choose two.)
Exhibit
Options
- APRODUCT_PRICE contains the value zero by default if no value is assigned to it.
- BPRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it.
- CEXPIRY_DATE cannot be used in arithmetic expressions.
- DPRODUCT_ID can be assigned the PRIMARY KEY constraint.
- EEXPIRY_DATE contains the SYSDATE by default if no date is assigned to it.
- FPRODUCT_NAME cannot contain duplicate values.
How the community answered
(30 responses)- A3% (1)
- B73% (22)
- C3% (1)
- E7% (2)
- F13% (4)
Community Discussion
No community discussion yet for this question.
