Sample Question No. 3 for IP - Informatics Practices ( AISSCE 2014 ) _ B
[2+2+1+1+2+2]
(a) What is the purpose of ALTER TABLE command?
(b) Why do we use ROLLBACK statement? Explain in brief
with the help of an example.
(c) After creating the “school” database you want to
use it. Write the command that you should give.
(d) Explain the two wildcard character – and % used
with the LIKE clause.
(e) What are joins? Why are they used?
(f) What is the importance of group function in MySQL?