Guru Nanak Dev University 2009 B.Sc Information Technology Database management system - Question Paper
Tuesday, 22 January 2013 05:45Web
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. |