Question: Fill in the SQL keywords to be able to perform the tasks as listed below. Please do not add any unnecessary spaces before or after
Fill in the SQL keywords to be able to perform the tasks as listed below. Please do not add any unnecessary spaces before or after the keywords.
Create a table named Student that has three fields:
studentid with characters
studentname with variable length of characters upto
studentgrade with a single character.
Student
studentid
studentname
studentgrade
;
Add a new column major of type that stores text of variable length up to characters
Student
major
;
Add new data with following values:
Studentid: SX
Studentname: Runi Sharma
Studentgrade: A
Major: BioTech
Student
SX 'Runi Sharma', A 'BioTech';
Change the students major from BioTech to BioScience for the student show studentid is SX
Student
major 'BioScience'
studentid SX;
Delete the student table
student;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
