DBMS UNIT-4 TEST
TIME DURATION: 1 HOUR
MARKS: 30
1. What is SQL? (1 mark)
2. How does SQL do its work. Explain it with the help of
diagram. (4 marks)
3. Explain DDL language with its various commands. (3
marks)
4. Write an SQL Query to add a new column in Student
Table. (2 marks)
5. How DML command manage the data inside tables.
Explain it in detail. (3 marks)
6. Write an SQL Query retrieve student data aged from 20
to 25. (2 marks)
7. Write an SQL Query to fetch student data whose name
fourth letter is ‘h’. (2 marks)
8. Explain different types of aggregate functions with the
help of an example of each. (5 marks)
TIME DURATION: 1 HOUR
MARKS: 30
1. What is SQL? (1 mark)
2. How does SQL do its work. Explain it with the help of
diagram. (4 marks)
3. Explain DDL language with its various commands. (3
marks)
4. Write an SQL Query to add a new column in Student
Table. (2 marks)
5. How DML command manage the data inside tables.
Explain it in detail. (3 marks)
6. Write an SQL Query retrieve student data aged from 20
to 25. (2 marks)
7. Write an SQL Query to fetch student data whose name
fourth letter is ‘h’. (2 marks)
8. Explain different types of aggregate functions with the
help of an example of each. (5 marks)
