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.
(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