Question

Consider the following STUDENT table and write the queries ​

Answer 1

Answer:

1) select * from student where city='Delhi'

term inside quote is case sensitive

2) Insert into STUDENT values (nnnnnnnnnnnnnnnn)

nnnnnnnnnn= exactly the same thing given in bracket

3)

Update STUDENT set class='XII' where name='Nanda'    

bad approach - two student having same name will get their class updated.

Update STUDENT set clas='XII' where rollno=1

good approach - but in this case you need to know the roll no of the student prior.