Karnataka State Open University (KSOU) 2011 B.C.A Computer Application- Rdbms - Question Paper
IV Semester B.C.A. Examination, August 2011 RDBMS i:
Time : 3 Hours Max. Marks : 80
Instruction : Answer all questions in Part - A and either (a) or (b) of &ach quesifah m Part -2?.
PART-A ..............
I. Answer all questions : . - * , . (1x10=10)
1) Define query language. . , , ,
2) Define the following terms : bboin
a) Field b) Record :>i; ; (
3) What is lossless join decomposition ? > U -
4) What are the responsibilities of DBA ?
5) What is equi-join 1
6) What do you mean by index ? '
7) What is meant by normalization of data ?
|
8) What are the uses of functional dependencies ? |
 |
II. Answer the questions in a paragraph : ; (5x4=20)
11) What are the advantages of a DBMS ?
12) Write short notes on database security.
13) Write short notes on Boyce Codd Normal Form (BCNF).
14) Write short notes on oracle privileges and rules.
15) Write short notes on PL/SQL explicit cursors.
|
Attachment: |
| Earning: Approval pending. |
