Subject – Database Management System (313302)
Chapter wise Questions
Chapter 1:
1. Define -Data, Database, Database management system. (2marks)
2. Difference between File System Vs DBMS (4 points -2 marks). IMP
3. List Applications of DBMS (2 marks)
4. List 4 DBMS software (2 marks)
5. Explain Data Abstraction with diagram (4marks)
6. What is Data Independence. What are its types (2marks). IMP
7. Define Schema and Instance (2marks)
8. Explain 4 Codd’s rules (2marks). IMP
9. Draw and Explain Overall structure of DBMS (4marks)
10. Explain Two tier architecture (2marks)
11. Explain Three tier architecture with diagram (4 marks). IMP
12. Define Data Models and list its types. (2marks)
13. Give difference between Hierarchical and Network Model (4 points - 2marks). IMP
14. Give difference between Relational and Network Model (2 marks)
15. Give difference between Relational and Hierarchical Model (2marks)
Chapter 2:
1. Explain Relational Concepts- Tables (Relations), Rows(Tuples), Domain, attribute,
Entities (4marks). IMP
2. Define Super Keys, Candidate Key. Give Example (2 marks)
3. Define Primary Key, Foreign Key. Give Example (2 marks). IMP
4. Define database constraint. list its types. (2 marks)
5. Explain not null and check constraint with example- (4 marks) IMP
6. Explain Referential Integrity Constraints with examples (4 marks)
7. Give difference between strong and weak entity set (2 marks)
8. Explain Types of Attributes with example (4 marks). IMP
9. Draw and explain Symbols of ER diagram (2 marks). IMP
10. Draw ER diagram for given system (4 marks). IMP
11. Define Normalization. Explain need of normalization (2 marks). IMP
12. Explain Functional Dependencies (2marks)
13. State and explain 1NF and 2NF with example(4marks)
Chapter 3
1. List 4 Datatypes in SQL (2marks)
2. Explain any 4 DDL commands with syntax and example (4marks)
3. Differentiate between delete and truncate command (2marks)
4. Explain uses of alter command with example (2marks). IMP
5. Explain create table command with syntax and example (2 marks)
6. Give difference between drop and delete (2 marks)
7. Explain 4 DML commands – insert, update, delete, select (4 marks)
8. Explain 2 DCL commands – grant and revoke with syntax and example (2 marks)
9. Explain TCL commands – commit, save point, rollback (4marks)
10. Write DDL, DML queries for given problem [each query – 1 mark] (4marks)
11. Explain types of join (4marks)
12. Write query using group by and having clause(2 marks)
13. Explain set operators with example. (4 marks). IMP
14. Explain any four string functions with example. (4 marks). IMP
15. Explain any four aggregate functions with example. (4marks). IMP
16. Explain any four numeric functions with example. (2marks)
17. Explain any four date functions with example. (2marks). IMP
18. Define index. Explain types of indices with proper example. (4marks). IMP
19. Define View. Write and explain create and drop view (4marks). IMP
20. Describe sequences with syntax and example. (4marks). IMP
Chapter 4
1. List 4 datatypes of PL/SQL (2marks)
2.Explain PL/SQL block structure with diagram (4marks) IMP
3. What is exception. What are its types? explain zero divide exception with code (4 marks) IMP
4. What is cursor? Explain types of cursor (4marks) IMP
5. Explain cursor with syntax for declaring, opening and closing a cursor (4marks) IMP
6. Difference between function and procedure. (2 marks) IMP
7. What is trigger, type of trigger, Give syntax and example. (4marks) IMP
Chapter 5
1.Describe database privileges. Write down the command for granting and revoking privileges on
database object to users.(4marks) IMP
2. Explain types of users (2marks)
3. list 4 functions of Database administrator (2 marks)
3. How to create, delete user? syntax and example (2marks) IMP
4. Explain Transaction Properties (ACID).( 4marks)IMP
5. Explain Transaction state diagram. IMP
6.Explain cause and types of database failure. (4 marks) IMP
7.Define Backup. What are types of Backup(2marks)
8.Write SQL command for following:
i) Create user
ii) Grant privileges to user
iii) Remove privileges from user
9. Explain Data Recovery Techniques(4marks)
10. Explain Advanced Database concepts -Data ware house, Data lake, Data Mining
11. Write short note on MongoDB and Big data
