2023 2024 Student Forum > Management Forum > Entrance Exams

 
  #2  
19th July 2018, 09:05 PM
Unregistered
Guest
 
Re: Barkatullah university papers

I want the previous year question paper of Databse Management System And Design of B.C.A of Barkatullah University so can you provide me?
  #3  
19th July 2018, 09:07 PM
Super Moderator
 
Join Date: Aug 2012
Re: Barkatullah university papers

I am providing you the previous year question paper of Databse Management System And Design of B.C.A of Barkatullah University

Barkatullah University B.C.A Databse Management System And Design question paper

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. 5 2=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 University
Barkatullah University, Habib Ganj, Bhopal, Madhya Pradesh 462026
0755 249 1744


Quick Reply
Your Username: Click here to log in

Message:
Options

Thread Tools Search this Thread



All times are GMT +5. The time now is 10:27 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
SEO by vBSEO 3.6.0 PL2

1 2 3 4