Oracle
1Z0-071 · Question #115
You must create a SALES table with these column specifications and data types: (Choose the best answer.) SALESID: Number STOREID: Number ITEMID: Number QTY: Number, should be set to 1 when no value…
The correct answer is D. CREATE TABLE sales(. See the full explanation below for the reasoning.
Question
You must create a SALES table with these column specifications and data types: (Choose the best answer.) 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?
Options
- ACREATE TABLE sales(
- BCREATE TABLE sales(
- CCREATE TABLE sales(
- DCREATE TABLE sales(
How the community answered
(17 responses)- A6% (1)
- B12% (2)
- C6% (1)
- D76% (13)
Community Discussion
No community discussion yet for this question.