Guru Nanak Dev University 2009 B.Sc Information Technology Database management system - Question Paper

b.sc(it) part second
data base management system and oracle(DBMS)
paper-5
note-attempt any 5 ques.. every ques. carry 20 marks.

1) How are feilds, records, files, and databases related ? discuss with an example.

2) elaborate the advantages and disadvantages of database management system ?

3) discuss the tyerms: association, relationship, aggrecation, specilization.

4) provide any 4 main responsibilities of a DBA. elaborate the fallouts if a DBA do not live up to these responsibilities ?

5) Let C be a certain club, and let relvar R (A,B) be such that the tuple (a,b) appears in R if and only if a and b are both members o C. elaborate FDs, MVD,s and JD,s does R satisfy ? what normal is it in ?

6) elaborate the various join methods available in oracle ?

7) discuss the subsequent example. which kind of cursor is being used in the example ? Justify your ans. start
for x in (select * from emp) loop
..........................................
.........................................
end loop;
end;

8) write short notes on any 2 of the following:-
a) er-diagrams
b) recovery of databases
c) database triggers.

Earning:   Approval pending.