22319--Sample-question-paper--Data-Base-Management-System I scheme Computer 3rd Semester Computer Group

Q.1) Attempt any FIVE of the following.			10 Marks
a)  List any four applications of DBMS. b)  State the four database users. c)  Define normalization. Enlist its type. d)  Enlist DDL and DML commands. e)  Define   the following      i) Primary Key
ii) Foreign Key f)   Enlist four aggregate functions. g)  Draw PL/SQL block structure.
Q.2) Attempt any THREE of the following.			12 Marks

a)   Write and explain syntax for creating procedure.

b)  Explain aggregate function with syntax and example.

c)   Explain grant and revoke command with syntax and example.

d)  Distinguish any four points between network model and hierarchical model.

Q.3) Attempt any THREE of the following.                                                         12 Marks

a)   Explain create and rename command with syntax and example.

b)  Write and explain the syntax for creating and dropping synonyms with an example.

c)   Explain predefined and user defined exception handling with the help of example.

d)  Explain ACID properties of transaction.

Q.4) Attempt any THREE of the following.                                   a)   List and explain DCL commands b)  Write and explain syntax for creating function. c)   Explain steps of cursor implementation with syntax and example. d)  Explain 2NF with example. e)   Explain the four roles of database administrator.		12 Marks
Q.5) Attempt any TWO of the following.		12 Marks

a) Draw ER diagram for Hospital Management System 

   (Use DOCTOR,PATIENT,HOSPITAL and MEDICAL_RECORD Entity).

    Identify Primary Key and Foreign Key. 

b) Normalize database

Employee(emp_id,emp_name,phone,skill,salary,deptno,dept_name,jobno,jo b_title) upto 3NF

c) Write SQL query for following consider table

    EMP(empno , deptno, ename ,salary, Designation, joiningdate, DOB,city)

1. i) Display names of employees whose experience is more than 10 years 
2. ii) Display age of employees 
3. iii) Display average salary of all employee
4.  iv) Display name of employee who earned highest salary

Q.6) Attempt any TWO of the following.                                        12 Marks 

a) Create  table

 EMP(   empno , deptno, ename ,salary, Designation, joiningdate, DOB,city).

1. i) Insert one row into the table
2.  ii) Save the data 
3. iii) Insert second row into the table i
4. v) Undo the insertion of second row v) Insert two rows into the table 
5. vi) Create Savepoint s1 
6. vii) Insert one row into the table 
7. viii) Undo upto savepoint s1

b)  Write a PL/SQL program to check whether specified employee is present in EMP table or not. Accept empno from user. If employee does not exist display message using exception handling.

c)   Write SQL query for following consider table

    EMP(empno , deptno, ename ,salary, Designation, joiningdate, DOB,city) 

1. i) Display employees name and number in an increasing order of salary
2.  ii) Display employee name and employee number dept wise 
3. iii) Display total salary of all employee 
4. iv) Display number of employees dept wise
5. v) Display employee name having experience more than 3 years 
6. vi) Display employee name staring with “S” and working in deptno 1002