Oracle
1Z0-082 · Question #143
1Z0-082 Question #143: Real Exam Question with Answer & Explanation
The correct answer is A. PRODUCT _ic can be assigned the PRIMARY KEY constraint. C. PRODUCT _price can be used in an arithmetic expression even if it has no value stored in it.. See the full explanation below for the reasoning.
Question
Examine the description of the product_details table: Which two statements are true?
Exhibit
Options
- APRODUCT _ic can be assigned the PRIMARY KEY constraint.
- BPRODUCT _price contains the value zero by default if no value is assigned to it.
- CPRODUCT _price can be used in an arithmetic expression even if it has no value stored in it.
- DEXPIRY_ DATE contains the sysdate by default if no date is assigned to it.
- EPRODUCT_NAKE cannot contain duplicate values.
- FEXPIRY_ DATE cannot be used in arithmetic expressions.
Community Discussion
No community discussion yet for this question.