Karnataka State Open University (KSOU) 2011 B.C.A Computer Application- Dbms - Question Paper
II Semester B.C.A. Examination, August 2011 DATABASE MANAGEMENT SYSTEM
Time: 3 Hours ;. Max. Marks: 80
Instruction : Answer al questions in Part A, and either (a) or (b) of each question in Part B.
PART-A
I. Answer all questions : (1x10=10)
1) What is transitive dependency ?
2) Wh&t is SQL ? o> b.
3) What are the set operations in SQL ?
4) What is meant by indexing ?
5) What is concurrency control ?
6) What is a data dictionary ?
7) What is database recovery; /v-
8) What is relationship? ?!3ivSexbiples; -
9) What is DML ?
10) List out the functions of DBA, ; -
II. Ansver the questions m pagrjh: (x4=20)
11) Explain in details about the various database languages.
12) Explain detail in domain relational calculus.
13) What are the responsibilities of DBA ?
14) Difference between first normal form and second normal form.
15) Explain deadlock in detail. PTO
BCA 07
BART A
Answer the questions in detail:
(5x10=50)
1 id:4 a)s1fexpMh architecture of DBMS.
OR |
bj Write short notes : |
i) Referential Integrity
ii) Aggregation. ......
if) a) Explain Codds 12 Rules. '
OR . A A , >;.< ,:;A::'
b) Explain the commands used to retrieve, insert, delete and update tables.
18. a) Write short notes on any two of the following :
i) Entity and Attributes
ii)'Database ; v?:,,;a.-;.: v a A a " A
iii) Data Independence
iv) Data Integrity.
OR
b) What is recovery ? Explain the various techniques. ?
19) a) Explain different levels of architecture of database system.
OR
b) Explain the four forms of normalization employed in relational database with appropriate examples. A a i - y
20) a) Draw an E-R diagram for a Inventory system assume suitable attributes.
OR
b) Describe the different steps in the design of a relational database.
Attachment: |
Earning: Approval pending. |