You want to create a sales table with the following column specifications and data types:
SALESID: Number
STOREID: Number
ITEMID: NumberQTY: 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?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Explanation:
To specify the default value of payment field you must use DEFAULT ‘CASH’.
https://docs.oracle.com/database/121/SQLRF/statements_7002.htm#SQLRF01402