Write the statements to:
a. Delete the record of students securing IV division.
b. Add a column REMARKS in the table with datatype as varchar with 50 characters
Question 34(iii)(Choice 2)(a)
Answer:
DELETE FROM RESULT WHERE DIV=’IV’;
Explanation:
Syntax to delete a record:
DELETE
FROM
table_name
WHERE
condition
;
Question 34(iii)(Choice 2)(a)
Answer:
ALTER TABLE RESULT ADD (REMARKS VARCHAR(50));
Explanation:
To add a column to an existing table, the alter table command is used.
Syntax to alter a table to add a column:
ALTER
TABLE
table_name
ADD
column_name datatype
;
