nerdexam
Oracle

1Z0-047 · Question #233

View the Exhibit and examine the ORDERS table. The ORDERS table contains data and all orders have been assigned a customer ID. Which statement would add a NOT NULL constraint to the CUSTOMER_ID…

The correct answer is B. ALTER TABLE orders. See the full explanation below for the reasoning.

Question

View the Exhibit and examine the ORDERS table. The ORDERS table contains data and all orders have been assigned a customer ID. Which statement would add a NOT NULL constraint to the CUSTOMER_ID column?

Exhibit

1Z0-047 question #233 exhibit

Options

  • AALTER TABLE orders
  • BALTER TABLE orders
  • CALTER TABLE orders
  • DALTER TABLE orders

How the community answered

(44 responses)
  • A
    9% (4)
  • B
    84% (37)
  • C
    2% (1)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice