Which statement adds a column called salary to the employees table having 100 rows, which cannot contain
null?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
which cannot contain null?
Which statement adds a column called salary to the employees table having 100 rows, which cannot contain
null?
C. > alter table employees add salary number(8,2) default 0 not null ;
ไม่มีเงินเดือนให้ใส่ 0฿ (ค่าdefault)
It’s C.
HelloWorld
September 5, 2015 at 10:12 pm
No, default value is not necessary for a column.
The ans is A.
0
0
Reply
dames
September 15, 2015 at 10:37 am
If the table is empty.
However, as the table has already 100 rows of data, DEFAULT is required.
Therefore C.