DMS (313302)
Chapter 01:
1. State any four advantages of DBMS over file processing system.
2. Distinguish between Network and Hierarchical model.
3. Explain overall structure of DBMS with the help of diagram.
4. Explain data abstraction,
5. Define: (i) Instance (ii) Schema
Chapter 02:
1. Draw an E-R diagram of library management system considering issue and
return, fine calculation facility, also show primary key, weak entity and
strong entity
2. State and explain 3NF with example.
3. State any four E.F. Codd’s rule for RDBMS.
4. Define Normalization and list its types
5. State and explain 2NF with example.
Chapter 03:
1. Explain range searching operation ‘between’ and pattern matching operator
‘like’ with example.
2. Define the term : i) Candidate key ii) Primary key iii)foreign key iv)super key
3. Explain any four joins with example. ( inner join , left,right,full outer join)
4. Describe Views and write a command to create view.
5. Explain sequence with example.
6. Explain group by and having with example.
Chapter 04:
1. Explain explicit cursors with example .
2. Explain Exception handling with it’s types
3. Define database trigger and use . How to create and delete trigger ?
4. Explain function in PL/SQL with example.
5. Draw the block structure of PL/SQL . List advantages of PL/SQL.
6. Write and explain syntax for creating procedure
Chapter 05:
1. Explain ACID properties of transaction.
2. Describe database backups with it’s types.
3. Describe database privileges. Write down the procedure for granting &
revoking privileges in database objects to the users.
4. Explain state of transaction with the help of diagram.
5. Explain recovery techniques with example.
6. Explain the four roles of database administrator.
