Punjab Technical University 2006 M.Sc Information Technology -(IT) 11nd Semester RDBMS - Question Paper

MSI-202
RDBMS
M.Sc (I.T) 11nd Semester (2006)

Time: 3 hours maximum marks: 75

Note: attempt all ques. to part –a and 9 ques. from part-b every ques. to part –a &part-b carry 2&5 marks respectively.
Part-a
1. Marks the foreign key in the relations of your option.
2 .what is meant by transitive dependency?
3 .give an example of many to 1 relationship.
4...what is the advantage of defining view?
5 .illustrate a non evil join operation.
6 .give 2 advantages of indexes.
7 .why do we use literals?
8 .give 2 examples of user described exceptions.
9 .what are sequences used for?
10 .how is a trigger various form function?
11 .why do we use varying arrays?
12 .why are the roles being created for an application?
13 .what is a schema?
14 .how do we use loop cursors?
15 .how is a package various form procedure?

Part-b
16 .discuss data base system architecture.
17 .What are the date momalies in 2nf&3nf?
18 . Show procedure of normalization of an er model with an example.
19 .What is the various kinds of data constraints?
20 .How is interconversions of data formats done in sql?
21 .Differentiate ranging from subquery and correlated query.
22 .How is partitioned views created?
23 .Eaht ae the various data kinds supported in pl/sql
24 .What are the various kinds of cursors available in pl/sql
25 .Give examples of (i) row trigger (ii) after trigger.
26 .When do you need to have user described data type? Show by an example.
27 .What is the roles and responsibility of database administrator?

Earning:   Approval pending.