Monday, September 2, 2013

DATA BASE MANAGEMENT SYSTEM MAY 2011 QUESTION PAPER

                             II semester  B.C.A Degree Examination,May 2011
                                                   (Y2K8 Scheme)
                                             (2008-09 & Onwards)
                                        Computer Science (BCA 205)
                                DATABASE MANAGEMENT SYSTEM

TIME:3hours                                                                                                        Max Marks 60

Instruction: Answer all sections

SECTION-A

Answer any ten question ,Each question carries one mark .                   10 X 1 =10

1.what is data model?

2.what is data inconsistency?

3.Define specialization?

4.what is Ordering?

5.what is Heap file?




6.Define second normal form?

7.what is generalization?

8.what is primary key?

9.what is SQL?

10.what is procedure in PL/SQL?

11.what are the types of trigger?

12.write the syntax of CREATE command?

SECTION-B

Anwer any 5 questions each  question carries three marks.        5X3=15

13. what are the functions of DBMS?

14.write a note on Data manipulation language?

15.Explain the various types of Attributes?

16.Differentiate between primary and secondary storage?

17.what are the properties of normalizatoin?

18.Explain JOIN operation in relation alegebra?

19.what are the advantages of PL/SQL?

20.what is database trigger? what are its uses?

SECTION-C

Answer any 5 questions.Each question carries seven marks each.

21)  i) Explain the responsibilities of DBA .     4marks
     
       ii) what is data independence? Name the two types of data independence. 3marks

22) Explain Tuple, domain and attribute with an example?

23) Explain hashing in detail.

24). i) what is functional dependency? Give example. 4marks
      ii) Explain transitive dependency.      3marks

25. Explain Relational model constraints.

26. Explain numeric and aggregate functions in SQL

27.Explain if then statement,if-then-else and if-then-elseif with examples.

28.Explain various transaction operations.

No comments:

Post a Comment