Barkatullah University 2010-3rd Sem B.C.A Computer Application (ester) , 2009-10, DATABSE MANAGEMENT SYSTEM AND DESIGN, --302, - Question Paper

AS-179
B.C.A. (Third Semester) EXAMINATION, 2009-10
DATABSE MANAGEMENT SYSTEM AND DESIGN
Paper-BCA-302
Time: 3 Hours
Maximum Marks : 35
Note : Attempt all questions, internall options are provided
Section-A 1-each
(Objective kind Questions)
Q.1. Attempt any 5 questions:
(i) Which of the subsequent describes the stored data structures in terms of the database model used:
a. Internal schemas
b. External schema
c. Conceptual schema
d. None of the above
(ii) Which of the subsequent is an attributeis that holds a single value for a single entity:
a. Simple
b. Compositive
c. Derived
d. Single-valued
(iii) Which is the symbol used to denote the choose operation?
a. Sigma
b. Rho
c. Pi
d. None of these
(iv) Which of the subsequent is a valid SQL data type:
a. Character
b. Numeric
c. FLOAT
d. All of the above
(v) Which of the subsequent is a cursor operation:
a. Open & Fetch
b. Declare
c. Close
d. All of the Above

part –B
Short ans kind ques. 5x2=10
Q.II. What do you understand by data dictionary?
Or
discuss the terms with example:
i. Data
ii. Information
iii. Database
Q.III. discuss different kinds of relationship.
Or
What is key? Differentiate ranging from super key and primary key.
Q.IV. What is specialization? discuss with example.
Or
Differentiate ranging from Relational algebra and SQL.
Q.V. How are data retrieved using views?
Or
elaborate the uses of indexes?
Q.VI Write the syntax of SQL and discuss it with example.
Or
What do you understand by locks?
Section-C
Long ans kind ques.
Q.VII. define Dataware house and knowledge discovery in database.
Or
discuss in architecture of a database system.
Q.VIII. What do you understand by normalization? discuss different kinds of normalization.
Or
discuss the subsequent terms with example:
i. Functional dependency
ii. Multi valued dependency
Q.IX. What is a Cartesian product? How is it represented? discuss with an example.
Or
discuss different oracle data kinds with example.
Q.X. Write down the syntax of insertion, update and delete operation. discuss every operation with example.
Or
Differentiate ranging from simple query and subqueries with example. elaborate the benefits of joins compared to subqueries?
Q.XI. What is locking? elaborate the various kinds of locks?
Or
elaborate user described transactions and elaborate they used for?

Earning:   Approval pending.