PCA103 Data Base Management System PGDCA Question Paper : tmu.ac.in

University : Teerthanker Mahaveer University
College : Teerthanker Mahaveer College of Management And Computer Applications
Degree : PGDCA (Post Graduate Diploma in Computer Application)
Subject : PCA103 Data Base Management System (DBMS)
Semester : I
Document Type : Model Question Paper
Website : tmu.ac.in

Download Previous/ Old Question Papers : https://www.pdfquestion.in/uploads/tmu.ac.in/5778-oldquestionpgdca201011.pdf

TMU Data Base Management System

PGDCA I SEMESTER EXAMINATION 2010-11
Course Code : PCA103
Paper ID: 0121101

Related / Similar Question Paper :
TMU PGDCA Foundation English Question Paper

Time : 3 Hours
Max. Marks: 75
Note : Attempt six questions in all. Q. No. 1 is compulsory.
1. Answer any five of the following (limit your answer in 50 words). (3×5=15)
a) What are the attributes of primary key-
b) Explain internal layer in data models.
c) Write syntax to represent union and minus with their respective results.

d) What are different data types in SQL-
e) Define first normal form with appropriate examples.
f) What do you mean by functional dependency-

g) What are the conditions to occur dead-lock-
h) What is concurrency and write the name of concurrency control technique-

2. What do you mean by data independence and explain physical data independence and logical data independence- (12)
3.a) What is referential integrity and entity integrity- (4)
b) What are different SQL operators- Explain generalization and aggregation. (8)

4. What is the difference between 2nd normal form and 3rd normal form with examples- (12)
5. What are the recovery algorithm from transaction failure and explain log based recovery in detail- (12)

6. Explain time stamp protocols and validation based protocol of concurrency control. (12)
7. What do you mean by data base management system also explain its architecture.
8. What is multi-value dependency and explain 5th normal form with example. (12)

PGDCA I 2013-14

Course Code : PCA103
Paper ID : 0801203
Database Management System :
Time : 3 Hours
Max. Marks : 70
Max Marks : 75
Note : Attempt six questions in all. Q. No. 1 is compulsory.
1. Answer any five of the following (limit your answer to 50 words). (4×5=20)
a) What are the differences between DBMS and RDBMS?
b) Discuss weak and strong entity.

c) Discuss rollback statement with example.
d) Name different form of normalization.
e) What do you understand by scope and visibility?

f) What do you mean by query language?
g) Discuss physical data independence.
h) Write a SQL query for inserting rows into the table.

2. Discuss different kind of services offered by DBMS. (10)
3. Discuss E-R diagram with the example of a hospital DBMS. (10)
4. Create a sample database management system for institute demonstrating various DDL and DML queries. (10)

5. Define BCNF with a detailed example. (10)
6. What do you understand by Functional dependencies? Where in the normalization process it is used? (10)
7. Define various states of transaction. (10)

8. Write short notes on any four of the following : (2.5×4=10)
a) NULL b) DCL
c) One to Many relationship d) Relational Algebra
e) Concurrency control techniques

PGDCA I 2012-13

Course Code : PCA103
Paper ID : 0801203
Database Management System
Time : 3 Hours
Max. Marks : 70
Max Marks : 75
Note : Attempt six questions in all. Q. No. 1 is compulsory.
1. Answer any five of the following (limit your answer to 50 words). (4×5=20)
a) Define RDBMS.
b) Discuss object modeling.
c) Discuss commit statement with example.
d) Define BCNF.
e) Write a SQL query to compare two dates.
f) Define data definition language with example.
g) Discuss data integrity.
h) Define concurrency control.

2. Explain the DBMS architecture with neat & clean diagram. (10)
3. What is a weak entity? How they are represented in E-R diagram? Explain its significance. (10)
4. What do you mean by relational constraints? Define it with example. (10)
5. Define third normal form with a detailed example. (10)

6. What do you mean by normalization? Discuss its advantages & disadvantages. (10)
7. What do you mean by transaction? Define its properties. (10)
8. What do you understand by Index? Discuss various types of indexes. (10)