Questions Search

This website covers previous years question papers of various universities and colleges in India. Moreover, the information on admission to various courses from various universities/institutes/colleges are also available. Research paper questions are also updated from time to time. Also the latest teaching faculty plus teachers jobs, Government jobs, Banking Jobs, and other jobs are regularly updated to help jobless candidates. Admit cards of various recruitment of Govt organisation are updated. Search your terms using the sejavascript:void(0)arch box provided.
Are you student / faculty of Vikram University Ujjain? We are collecting old question papers. If you have latest question papers 2016 / 2015 / 2014 years, then contact us through email [email protected] / [email protected] . We will give you money for your question papers you send to us.

TNPSC Group IV 2016 Model Questions AnswersTNPSC Group IV

Anna Univ B.E Civil Engineering Previous Years Question PapersBE Civil Anna Univ

Anna Univ B.E EEE Previous Years Question PapersB.E EEE Anna Univ Questions

Anna Univ B.E Mechanical Engineering Previous Years Question PapersMechanical B.E Questions

Anna Univ B.E CSE Previous Years Question PapersMechanical B.E Questions

Anna Univ B.E ECE Previous Years Question PapersMechanical B.E Questions

VTU Question PapersLatest News

Dharmsinh Desai University Previous Years Question PapersLatest News

NEW: Last 05+ Years Question Papers of CE6451 Fluid Mechanics and Machinery

NEW: ME6502 Heat and Mass Transfer AU Chennai Last 10 Set of Question Papers

NEW: CE2027 Housing Planning and Management 2014 Question Paper

Himachal Pradesh University (HPU) Previous Years Question Papers

ME2027 PPCE All Previous Years Question Papers [NEW]

GNDU Previous Years Question Papers [NEW]

Teachers TGT, PGT, PRT jobs in New Delhi Schools


Follow by Email

Monday, December 28, 2015

BCA-302 Database Management System and Design BU Bhopal 2010 Question Paper

Looking for BCA Barkatullah University Old Question Papers ? You can here download 2010 old question paper BCA 3rd Semester Database Management System and Design of this university, Check out more details below:

Barkatullah University QP
Question Paper Code : AS-179
B.C.A. (Third Semester) EXAMINATION, 2009-10
Time: Three Hours
Maximum Marks : 35
Note : Attempt all questions, internall choices are given
Section-A 1-each
(Objective Type Questions)
Q.1. Attempt any five questions:
(i) Which of the following defines 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 following 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 select operation?
a. Sigma
b. Rho
c. Pi
d. None of these
(iv) Which of the following is a valid SQL data type:
a. Character
b. Numeric
d. All of the above
(v) Which of the following is a cursor operation:
a. Open & Fetch
b. Declare
c. Close
d. All of the Above

Section –B
Short Answer Type Question 5x2=10
Q.II. What do you understand by data dictionary?
Explain the terms with example:
i. Data
ii. Information
iii. Database
Q.III. Explain various types of relationship.
What is key? Differentiate between super key and primary key.
Q.IV. What is specialization? Explain with example.
Differentiate between Relational algebra and SQL.
Q.V. How are data retrieved using views?
What are the uses of indexes?
Q.VI Write the syntax of SQL and explain it with example.
What do you understand by locks?
Long Answer Type Question
Q.VII. Describe Dataware house and knowledge discovery in database.
Explain in architecture of a database system.
Q.VIII. What do you understand by normalization? Explain various types of normalization.
Explain the following terms with example:
i. Functional dependency
ii. Multi valued dependency
Q.IX. What is a Cartesian product? How is it represented? Explain with an example.
Explain various oracle data types with example.
Q.X. Write down the syntax of insertion, update and delete operation. Explain each operation with example.
Differentiate between simple query and subqueries with example. What are the benefits of joins compared to subqueries?
Q.XI. What is locking? What are the different types of locks?
What are user defined transactions and what are they used for?

No comments:

Post a Comment

Pen down your valuable important comments below