Question: Please answer the SQL queries for this question Thank you 4. Write SQL statements for the following: Create a table sub with following information: columns

Please answer the SQL queries for this question Thank you
4. Write SQL statements for the following: Create a table sub with following information: columns and data types: name varchar(8), age number(5), mark1 number(4), mark2 number(4), mark3 number(4); Enter at least five tuples for the given relation. b. Add one more column with field name as total with data type as number(5). c. Update the age of sub for a particular student. d. Deleting a row from the table. e. Drop column mark3. f. Modify the table by changing the data type of mark3 to number(6) g. Delete all the data from the sub table. h. Delete the table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
