Deemed University 2011 B.C.A Computer Application University: Lingayas University Term: III Title of the : Database Management System - Question Paper

Roll No. ..

 

Lingayas University

BCA 1^st Year (Term II)

Examination Feb 2011

Database Management System (CA - 1103)

 

[Time: 3 Hours] [Max. Marks: 100]

 

Before answering the question, candidate should ensure that they have been supplied the correct and complete question paper. No complaint in this regard, will be entertained after examination.

 

Note: Attempt five questions in all. All questions carry equal marks. Question no. 1 is compulsory. Select two questions from Section B and two questions from Section C.

Section A

 

Q-1. Part A

Select the correct answer of the following multiple choice questions. [10x1=10]

(i) Which of the following is the set-oriented operation?

(a) Select (b) Difference

(c) Division (d) Project

(ii) Which of the following is the binary operation?

(a) Union (b) Join

(c) Cartesian Product (d) All of these

(iii) Which of these levels deals with the physical representation of the database on the computer?

(a) External Level (b) Conceptual Level

(c) Internal Level (d) None of these

(iv) Which of these constraints ensures that the foreign key value in the referencing relation must exist in the primary key attribute of the referenced relation?

(a) Primary Key (b) Reference Key

(c) Foreign Key (d) Unique Key

(v) Which of these is not an advantage of database systems?

(a) Data Redundancy (b) Program-data independence

(c) Centralized data management (d) Data abstraction

(vi) The information about data in a database is called__________?

(a) Metadata (b) Hyper data

(c) Tera data (d) None of these

(vii) What does C stands for in transaction ACID properties?

(a) Correctness (b) Committed

(c) Consistency (d) Completeness

(viii) Which of these individuals plays an important role in defining and maintaining a database for an organization?

(a) System analyst (b) Application programmer

(c) Database administrator (d) All of these

(ix) Which of these data models is an extension of relational data model?

(a) Object-oriented data model

(b) Object-relational data model

(c) Semi structured data model

(d) None of these

(x) In an E-R diagram a relationship is represented by a ___________?

(a) Square (b) Rectangle

(c) Diamond-shaped box (d) Ellipse

 

Part B

 

Explain the following terms:

(i) Functional Dependency

(ii) Complex Attributes

(iii) Composite and Simple Attributes

(iv) Database Management System

(v) Primary Key [5x2=10]

 

Section B

 

Q-2. Write short notes on the following (any four):

(i) Network Model

(ii) Database users

(iii) Database Languages

(iv) Hierarchical Model

(v) Advantages of Database Approach [4x5=20]

 

Q-3. (a) What is normalization? Explain 1NF, 2NF and 3NF with examples.

(b) What is File organization? Explain various file organization techniques? [2x10=20]

 

Q-4. Explain the three schema architecture of DBMS? What is data independence? How is logical data independence different from physical data independence? [20]

 

Section C

 

Q-5. What is Transaction processing? What are the desirable properties of Transactions? Discuss the types of problems we may encounter if two transactions run concurrently? Also discuss the locking techniques for concurrency control? [20]

 

Q-6. Explain the various operators used in Relational Algebra with examples. [20]

 

Q-7. Write short notes on the following:

(i) Database Recovery

(ii) Views

(iii) Characteristics of DBMS

(iv) ER-Diagram [4x5=20]

 

Q-8. (a) Explain Database Recovery and its various techniques?

(b) Explain the various access control techniques?

[2x10=20]