nerdexam
Oracle

1Z0-061 · Question #32

You want to create a sales table with the following column specifications and data types: SALESID: Number STOREID: Number ITEMID: Number QTY: Number, should be set to 1 when no value is specified…

The correct answer is B. Option B. See the full explanation below for the reasoning.

Question

You want to create a sales table with the following column specifications and data types:

SALESID: Number STOREID: Number ITEMID: Number QTY: Number, should be set to 1 when no value is specified SLSDATE: Date, should be set to current date when no value is specified PAYMENT: Characters up to 30 characters, should be set to CASH when no value is specified Which statement would create the table?

Exhibit

1Z0-061 question #32 exhibit

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D

How the community answered

(56 responses)
  • A
    7% (4)
  • B
    75% (42)
  • C
    14% (8)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice