Which statement would create the table?

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?

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?

A.
Option A

B.
Option B

C.
Option C

D.
Option D

Show Hint

Leave a Reply 7

Your email address will not be published. Required fields are marked *

MKR

MKR

Correct answer is

C.
Option C

Reply

shape

shape

Option B is correct.
It is tested.

Reply

Adeel

Adeel

Obviously B.

Reply

Livia

Livia

Agree with Shape. Thank you for your contribution on the comment section! It is very helpful.
C cannot be correct, because cash needs to be included in ”. When you include sysdate in ”, it is treated like a character string, not a function.

Reply

Surersh

Surersh

B is correct

Reply

Shivi

Shivi

What is the difference between option A and option D ?

Reply