Exam Details
| Subject | advanced database management system | |
| Paper | ||
| Exam / Course | mca | |
| Department | ||
| Organization | Vardhaman Mahaveer Open University | |
| Position | ||
| Exam Date | June, 2016 | |
| City, State | rajasthan, kota |
Question Paper
MCA-13
June Examination 2016
MCA IInd Year Examination
Advance Database Management System
Paper MCA-13
Time 3 Hours Max. Marks 80
Note: The question paper is divided into three sections B and C. Write answers as per given instructions.
Section A 8 × 2 16
(Very Short Answer Questions)
Note: Answer all questions. As per the nature of the question delimit your answer in one word, one sentence or maximum upto 30 words. Each question carries 2 marks.
What do you mean by transaction?
List the advantages of DBMS.
Give some examples of DBMS software.
What is Primary Key?
Define cardinality ratio in ER model.
Name some transaction control commands.
What is the use of time stamp data types in SQL?
(viii) What is a system log used for?
613
MCA-13 200 3 (P.T.O.)
MCA-13 200 3 (Contd.)
613
Section B 4 × 8 32
(Short Answer Questions)
Note: Answer any four questions. Each answer should not
exceed 200 words. Each question carries 8 marks.
What do you mean by Data Independence? Compare Logical
data independence and Physical data independence.
What do you mean by Relationship? Discuss various types of
Relationship in Database Management System.
What is SELECT, PROJECT and RENAME operation? How
is it represented? Explain with example.
Write short note on Functional dependencies.
What is the need of concurrency control? Explain with
example.
Discuss the ACID properties of a database transaction.
Give an example of an encryption algorithm and explain how
it works.
What is entity and referential integrity constraint?
MCA-13 200 3
613
Section C 2 × 16 32
(Long Answer Questions)
Note: Answer any two questions. You have to delimit your each
answer maximum upto 500 words. Each question carries
16 marks.
10) What do you mean by SQL joins? Discuss various types of
SQL joins with suitable examples.
11) What is the use of Triggers? Explain different types of
triggers with examples.
12) Define 3NF. Consider the relational schema R(ABC) with
FDs AB → C → A. show that the schema R is in 3NF but
not in BCNF.
13) Write short note on the following:
Distributed database system
DBMS Architecture
June Examination 2016
MCA IInd Year Examination
Advance Database Management System
Paper MCA-13
Time 3 Hours Max. Marks 80
Note: The question paper is divided into three sections B and C. Write answers as per given instructions.
Section A 8 × 2 16
(Very Short Answer Questions)
Note: Answer all questions. As per the nature of the question delimit your answer in one word, one sentence or maximum upto 30 words. Each question carries 2 marks.
What do you mean by transaction?
List the advantages of DBMS.
Give some examples of DBMS software.
What is Primary Key?
Define cardinality ratio in ER model.
Name some transaction control commands.
What is the use of time stamp data types in SQL?
(viii) What is a system log used for?
613
MCA-13 200 3 (P.T.O.)
MCA-13 200 3 (Contd.)
613
Section B 4 × 8 32
(Short Answer Questions)
Note: Answer any four questions. Each answer should not
exceed 200 words. Each question carries 8 marks.
What do you mean by Data Independence? Compare Logical
data independence and Physical data independence.
What do you mean by Relationship? Discuss various types of
Relationship in Database Management System.
What is SELECT, PROJECT and RENAME operation? How
is it represented? Explain with example.
Write short note on Functional dependencies.
What is the need of concurrency control? Explain with
example.
Discuss the ACID properties of a database transaction.
Give an example of an encryption algorithm and explain how
it works.
What is entity and referential integrity constraint?
MCA-13 200 3
613
Section C 2 × 16 32
(Long Answer Questions)
Note: Answer any two questions. You have to delimit your each
answer maximum upto 500 words. Each question carries
16 marks.
10) What do you mean by SQL joins? Discuss various types of
SQL joins with suitable examples.
11) What is the use of Triggers? Explain different types of
triggers with examples.
12) Define 3NF. Consider the relational schema R(ABC) with
FDs AB → C → A. show that the schema R is in 3NF but
not in BCNF.
13) Write short note on the following:
Distributed database system
DBMS Architecture
Other Question Papers
Subjects
- advanced database management system
- advanced web technology
- computer fundamentals and pc software
- computer organization and architecture
- computer programming using c
- data communication and computer networks
- data structure through c language
- design and analysis of algorithm
- digital logic
- discrete mathematics
- electronic commerce
- formal languages and automata
- fundamentals of database management system
- fundamentals of networking and web technology
- linux system administration
- management accounting
- object-oriented programming through c++
- operating system
- programming in java
- software engineering
- system programming