Barkatullah University Last Year Paper

Hello sir I am doing my BCA from Barkatullah University and preparing for exams. Can you please provide me sample paper of DBMS of BCA 3rd sem of Barkatullah University?

[Arun Vats]

As per your request I am providing you the sample paper of DBMS of BCA 3rd sem of Barkatullah University.

Sample paper of DBMS:

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?

Contact:

Barkatullah Vishwavidyalaya
Hoshangabad Road, Habib Ganj, Bhopal, Madhya Pradesh 462026 ‎
0755 251 7100 ‎

[MAP][MAP]Barkatullah Vishwavidyalaya[/MAP][/MAP]