Question

(a) Answer the question based on the table given below:
TABLE: Student
20
7
15
1
Column Name
Data Type
Size
Constraint
Roll No
NUMBER
PRIMARY KEY
Name
VARCHAR
Not full
Stipend
NUMBLR
stipend is greater than
Stream
VARCHAR
NotNull
Grace
VARCHAR
(i) Write the SQL command to create the above table with constraints.
(ii) Insert 2 records with relevant information, in the table student,
(111) Display all the records of the table Student,
(iv) Delete the Student Whose Roll no is 100.
(v) Change the Stream of Student to 'Computer' Whose Roll no. is 536.
(vi) Add one column email of data type VARCHAR and size 30 to the table student.​

Answer 1

Answer:

PLEASE SEND YOUR QUESTION AGAIN AS THE TABLE IS NOT CLEAR..

Regards