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
Correct answer is Option B
Correct answer is Option B
B is Correct
SQL> CREATE TABLE sales (
salesid NUMBER (4),
storeid NUMBER (4),
itemid NUMBER (4),
qty NUMBER DEFAULT 1,
slsdate DATE DEFAULT SYSDATE,
payment VARCHAR2(30) DEFAULT ‘CASH’); 2 3 4 5 6 7
Table created.
B.
Yes, the correct answer is B, please fix the error at the result
Passed 1Z0-061 exam recently!
Total 75 questions, few new questions, learned them from PassLeader 1Z0-061 dumps (http://www.passleader.com/1z0-061.html), which is 100% pass ensure now!
p.s.
Free PassLeader 1Z0-061 dumps from Google Drive:
https://drive.google.com/open?id=0B-ob6L_QjGLpZ2pPVDVMSlJ6UjA
Good Luck!
Hi Macro Vera,
do you have 1Z0-062 dumps. if you have please share with me.
Thanks in Advance
Regards,
Naga
B