Exam Details
| Subject | fundamentals of 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-07
June Examination 2016
MCA Ist Year Examination
Fundamentals of Database Management System
Paper MCA-07
Time 3 Hours Max. Marks 80
Note: The question paper is divided into three sections B and C with marking scheme.
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 Data dictionary?
Define foreign key.
Write the syntax of UPDATE query.
What is the mean of BCNF?
Write the syntax of ORDER By clause.
In E-R diagram relations are represented by .
What is DML?
(viii) What is Database Administrator?
453
MCA-07 100 3 (P.T.O.)
MCA-07 100 3 (Contd.)
453
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.
Describe different Database schemes in the detail and also
explain the difference between physical and logical Data
Independence.
What do you mean by E-R diagram? Explain its components.
What is normalization? How is it useful in a good Database
Design?
Explain the structure of DBMS. How it is different from
RDBMS?
Differentiate between:
Ternary relationship and Aggregation.
Entity and attribute
What is cardinality? Explain various types of mapping of
cardinality.
What is hash file organization? What is hash index?
Discuss the various types of keys that are used in relational
model.
MCA-07 100 3
453
Section C 2 × 16 32
(Long Answer Questions)
Note: Answer any two questions. You have to delimit each
answer maximum upto 500 words. Each question carries
16 marks.
10) What do you mean by records? Explain fixed length records
and variable length records in detail.
11) Discuss the difference between five join operation: Theta join,
Equi join, Natural join, Outer join and Semi join.
12) What is SQL? Write its characteristics and design basic
structure of SQL.
13) Explain network and object oriented model. What are the role
of these models in database design?
June Examination 2016
MCA Ist Year Examination
Fundamentals of Database Management System
Paper MCA-07
Time 3 Hours Max. Marks 80
Note: The question paper is divided into three sections B and C with marking scheme.
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 Data dictionary?
Define foreign key.
Write the syntax of UPDATE query.
What is the mean of BCNF?
Write the syntax of ORDER By clause.
In E-R diagram relations are represented by .
What is DML?
(viii) What is Database Administrator?
453
MCA-07 100 3 (P.T.O.)
MCA-07 100 3 (Contd.)
453
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.
Describe different Database schemes in the detail and also
explain the difference between physical and logical Data
Independence.
What do you mean by E-R diagram? Explain its components.
What is normalization? How is it useful in a good Database
Design?
Explain the structure of DBMS. How it is different from
RDBMS?
Differentiate between:
Ternary relationship and Aggregation.
Entity and attribute
What is cardinality? Explain various types of mapping of
cardinality.
What is hash file organization? What is hash index?
Discuss the various types of keys that are used in relational
model.
MCA-07 100 3
453
Section C 2 × 16 32
(Long Answer Questions)
Note: Answer any two questions. You have to delimit each
answer maximum upto 500 words. Each question carries
16 marks.
10) What do you mean by records? Explain fixed length records
and variable length records in detail.
11) Discuss the difference between five join operation: Theta join,
Equi join, Natural join, Outer join and Semi join.
12) What is SQL? Write its characteristics and design basic
structure of SQL.
13) Explain network and object oriented model. What are the role
of these models in database design?
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