Saurastra University 2006 M.C.A Database Management System (New ) - Question Paper

SX-7812    Seat    Seat No.

Illllllllllllllllllllllllll

*SX-7812*

M. C. A. - 3 Examination April/May - 2006 Database Management System

(New Course)

[Total Marks : 75

1 Attempt any four of the following :

(1)    Explain hierarchical, network and relational model in short.

(2)    What is E-R diagram ? Draw ER diagram for entities and their relationship of a Bank.

(3)    Explain the major function performed by DBMS.

(4)    List advantages of database system.

(5)    What is normalization ? Explain 1NF.

2    Attempt any four of the following :    20

(1)    Explain the steps involved in construction of ERD.

(2)    State and explain the purpose of recovery.

(3)    Write short note on ACID.

(4)    Describe three concurrency problems and explain any one.

(5)    Describe different categories of integrity rules.

3    Attempt any four :    25

(1)    What is cursor ? Explain explicit cursor with suitable example.

(2)    Explain :old and :new with respect to a trigger.

(3)    Discuss : Package

(4)    Explain the following function :

(i)    translate ( )

(ii)    round ( )

(iii)    to-date ( )

(iv)    ceil ( )

(5)    What is stored procedure ? Briefly explain in Oracle.

(a) What is join ? List and explain different types of join 5 in Oracle.

(b) Consider the following :

emp
Field name	Type	Description
eno	number (2)	employee no.
inm	varcher2 (20)	employee name
Desig	varchar2 (10)	Designation
mno	number (2)	Manager no, is the eno of the manager

(1)    Create above table with appropriate constrains.

(2)    List the eno, ename and corresponding manager

name.

[300]

duoed by dei    d http:    .dooudei

SX-7812]    2

Attachment: saurastra-university-2006-m-c-a--25890-1.pdf

Earning:   Approval pending.