nerdexam
Oracle

1Z0-061 · Question #159

You want to create an ORD_DETAIL table to store details for an order placed having the following business requirement: 1) The order ID will be unique and cannot have null values. 2) The order date…

The correct answer is C. CREATE TABLE ord_details. See the full explanation below for the reasoning.

Question

You want to create an ORD_DETAIL table to store details for an order placed having the following business requirement: 1) The order ID will be unique and cannot have null values. 2) The order date cannot have null values and the default should be the current date. 3) The order amount should not be less than 50. 4) The order status will have values either shipped or not shipped. 5) The order payment mode should be cheque, credit card, or cash on delivery (COD). Which is the valid DDL statement for creating the ORD_DETAIL table?

Options

  • ACREATE TABLE ord_details
  • BCREATE TABLE ord_details
  • CCREATE TABLE ord_details
  • DCREATE TABLE ord_details

How the community answered

(30 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    83% (25)
  • D
    10% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice