nerdexam
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

1Z0-071 question #262 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)
  • A
    3% (1)
  • B
    73% (22)
  • C
    3% (1)
  • E
    7% (2)
  • F
    13% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice