Maharashtra State Board of Technical Education 2008 Diploma Computer Engineering RDBMS - Question Paper

Sample ques. Paper – I
Course Name :- Computer Engineering Group
Course code :- CO/CM/CD/ IF
Semester :- Third
Subject :- RDBMS
Duration :- three hours Marks: 80

Instructions :

1] All ques. are compulsory
2] Figures to the right shows full marks
3] Use of non programmable calculator is permissible


Q1: Attempt any 8 of the subsequent [Marks:(8x2=16)]

1. describe data independency and its kinds.

2. describe attribute and entity.

3. List various levels of which security can be maintained.

4. describe data models and list various kinds of data models.

5. What is functional dependency.

6. List the steps for deadlock prevention.

7. How to defect dead lock in system.

8. What is recoverable schedule?

9. List the functions of DBA.

10. Define- i) Identifying Relationship ii) Partial Key.


Q2: Attempt any 3 of the subsequent [Marks:(3x4=12)]

1. elaborate various kinds of diet server Architecture discuss any 2 of them.

2. Compare N/W model and Hierarchical model.

3. Draw E-R diagram of Hospital management. The Hospital should maintain the data about employees, doctors and patients.

4. List and discuss kinds of DBMS users.


Q3: Attempt any 3 of the subsequent [Marks:(3x4=12)]

1. With suitable example discuss various kinds of attribute in E-R model.

2. Consider the structure as
Product- Muster = {Prod.id, prod. name, rate}
Purchase- details = {prod.id, quantity, dept.no purchase. date}

(1) Write relational algebra expression for subsequent
i) Get product.id, product-name and volume for all purchased products.
ii) Get the products with rates ranging from 100 4500.

3. How to grant & Revoke permission from user.

4. What is the use of group by and having clause? discuss with example.


Q4: Attempt any 4 of the subsequent [Marks:(4x4=16)]

1. List and discuss set operators in SQL with example.

2. Consider the structure for Book. Table as book-master
= {Book-id, Book name, Sub-code, Author, No. of copies, price}.
Write SQL queries for subsequent.
i) Display total number of books for subject code ‘DBM’
ii) Get writer wise list of all books.
iii) Get the list of books which are written by identical writer as of book programming in C.
iv) Display all books with details whose name begin with ‘S’

3. Write a program using while loop to display n even numbers.

4. List kinds of cursors and discuss every with example.

5. With suitable example discuss before and after insert trigger.


Q5: Attempt any 3 of the subsequent [Marks:(4x3=12)]

1. Consider the structure of relation as
Employee Details= {emp_id, emp_name, address, designation, salary, Dept-no, deptname,location, joining-date}
obtain all functional dependencies and normalize the structure up to 2NF

2. How to access records using index sequential access methods.

3. Draw ER diagram of car accident consider the data about car details, person details

4. What is decomposition and loss-less join decomposition

5. What is byte string representation? discuss with example.


Q 6: Attempt any 3 of the subsequent [Marks:(4x3=12)]

1. Consider the structure for account table as
{Acc_no, balance, acc_name} and customer table as
{Cust_name, cust_add, state, city, phone_no} apply primary key, foreign key and check constraint that balance should not be less than 500

2. What is cascade less schedule? discuss with example.

3. What is equivalence expression .Explain with example?

4. elaborate 2 phase locking protocols? discuss with example.

Earning:   Approval pending.