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:
student_id with 10 characters
student_name with variable length of characters upto 25
student_grade with a single character.
Student (
student_id
,
student_name
,
student_grade
);
Add a new column major of type that stores text of variable length up to 25 characters
Student
major
;
Add new data with following values:
Student_id: S0192X9069
Student_name: Runi Sharma
Student_grade: A
Major: BioTech
Student
(
'S0192X9069', 'Runi Sharma', 'A', 'BioTech');
Change the students major from BioTech to BioScience for the student show student_id is S0192X9069
Student
major = 'BioScience'
student_id ='S0192X9069';
Delete the student table
student;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!