Saurastra University 2006 M.C.A Database Management System (New ) - Question Paper
SX-7812 Seat Seat No.
*SX-7812*
M. C. A. - 3 Examination April/May - 2006 Database Management System
[Total Marks : 75
Time : 3 Hours]
1 Attempt any four of the following :
20
(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
[Contd.
1
SX-7812]
(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.
4
(b) Consider the following :
5
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.
duoed by dei d http: .dooudei
SX-7812] 2
Attachment: |
Earning: Approval pending. |