Oracle
1Z0-082 · Question #143
Examine the description of the product_details table: Which two statements are true?
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.
SQL and PL/SQL
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.
How the community answered
(26 responses)- A85% (22)
- B8% (2)
- D4% (1)
- F4% (1)
Topics
#PRIMARY KEY#NULL values#constraints#arithmetic expressions
Community Discussion
No community discussion yet for this question.