Question

4. For the given table do as directed:
STUDENT
105)
Data type
Column name
ROLLNO
SNAME
GENDER
DOB
FEES
Integer
Varchar
Char
Size
4
25
1
Constraint
Primary Key
Not Null
Date
Decimal
6,2
a) Write SQL query to create the above table.
b) Write SQL query to increase the size SNAME to hold 30 characters.
c) Write SQL query to insert a row in the table with any values of your choice that
can be accommodated there.
d) Write SQL query to delete the GENDER column.​

Answer 1

Answer:

ok laduchand majchebc zkdhc the class of 60 km on the