Computer Science - Class 12
Solutions to CBSE Sample Paper - Computer Science Class 12

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 ;

Learn in your speed, with individual attention - Teachoo Maths 1-on-1 Class

Ask a doubt
Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 13 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.