Saurastra University 2006 B.Sc Information Technology Database Management System - Question Paper

B. Sc. (IT) (Sem. IV) exam
April / May – 2006
Database Management System
(Oracle - 8.0)
Time : three Hours] [Total Marks : 100

1 (i) discuss the subsequent : (any three) six
(a) Initialization parameter
(b) User data
(c) Import and Export
(d) Control files.
(ii) discuss in brief : (any three) nine
(a) Memory structure
(b) Rollback Tablespace
(c) Archivelog Mode
(d) DBWR.

2 discuss the subsequent : (any three) 15

(a) Package
(b) Procedure v/s. Function
(c) PL/SQL tables v/s. Varrays.
3 Attempt any 2 : 20

(a) explain views in Oracle.
(b) discuss different constraints in Oracle.
(c) What is transaction? discuss transaction control commands.
4 discuss in detail with example : (any two) 20

(a) Implicit cursor v/s Explicit cursor.
(b) DML v/s DDL.
(c) Join.
SP-1975] one [Contd.
.




5 describe the subsequent term : (any five)
10

(a) % Rowtype
(b) Distinct
(c) Like
(d) Commit
(e) Revoke
(f)
PL/SQL.
6
Attempt the subsequent : (any four) 20

(a)
Input Exam_no, name and marks of 5 subjects for a
learner and compute total, percentage and display
grade using procedure.
(b)
discuss composite datatypes of PL/SQL.
(c)
discuss Group by.......Having with example.
(d)
discuss E-R diagram.
(e)
discuss Subquery with example.
SP-1975]
2
[ 200
]

Earning:   Approval pending.