Exam Details
| Subject | advanced database management system | |
| Paper | ||
| Exam / Course | mca | |
| Department | ||
| Organization | Vardhaman Mahaveer Open University | |
| Position | ||
| Exam Date | December, 2016 | |
| City, State | rajasthan, kota |
Question Paper
MCA-13
December 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.
Name some aggregate functions in SQL.
What is super key?
What do you mean by Roll back transaction?
Define transaction.
List the ACID properties.
When does Insert anamolies occurs?
Give an example of Equi-Join.
(viii) What is tuple?
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.
List the Lodd's rules to qualify a database as relational.
Compare 3NF and BCNF.
What is Primary key, Foreign key and Composite key? How
you identify these keys, also give the difference among them.
Write short note on cursor in PL/SQL.
Discuss the role of various types of Database users.
Describe the advantages of SQL. Also explain various datatype
in SQL.
Why E-R diagram is used in DBMS? Explain various symbol
used in E-R diagram.
Discuss how we can control concurrency based on time stamp
ordering with suitable example.
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 is the need of security in Database? Discuss various
issues of Database security.
11) What are the significance of Relational Algebra? Discuss
various operations in Relational Algebra.
12) Define DBMS. Explain 3-tier architecture of DBMS with its
advantages over 2-tier architecture.
13) What is schedule? Define serial, serializable and nonserializable
schedule. Give example when two schedule said
to be equivalent. How to detech equivalance of two schedule?
December 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.
Name some aggregate functions in SQL.
What is super key?
What do you mean by Roll back transaction?
Define transaction.
List the ACID properties.
When does Insert anamolies occurs?
Give an example of Equi-Join.
(viii) What is tuple?
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.
List the Lodd's rules to qualify a database as relational.
Compare 3NF and BCNF.
What is Primary key, Foreign key and Composite key? How
you identify these keys, also give the difference among them.
Write short note on cursor in PL/SQL.
Discuss the role of various types of Database users.
Describe the advantages of SQL. Also explain various datatype
in SQL.
Why E-R diagram is used in DBMS? Explain various symbol
used in E-R diagram.
Discuss how we can control concurrency based on time stamp
ordering with suitable example.
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 is the need of security in Database? Discuss various
issues of Database security.
11) What are the significance of Relational Algebra? Discuss
various operations in Relational Algebra.
12) Define DBMS. Explain 3-tier architecture of DBMS with its
advantages over 2-tier architecture.
13) What is schedule? Define serial, serializable and nonserializable
schedule. Give example when two schedule said
to be equivalent. How to detech equivalance of two schedule?
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