Exam Details
| Subject | advanced database design | |
| Paper | paper 22 | |
| Exam / Course | m.c.a | |
| Department | ||
| Organization | Nalanda Open University | |
| Position | ||
| Exam Date | April, 2018 | |
| City, State | bihar, patna |
Question Paper
N A L A N D A O P E N U N I V E R S I T Y
Master of Computer Application Part-III
PAPER-XXII
(MCS-043 Advanced Database Design)
Annual Examination, 2018
Time 3 Hours. Full Marks 80
Answer any Five Questions.
All questions carry equal marks.
1. Discuss classification as a tool in Data Mining. Describe the ID 3 algorithm for classifying data
sets with a suitable example.
2. What is Data Dictionary? What is the significance of creating Data Dictionary in DBMS? Explain
the statistics stored in the Data D.
3. What are views? What is the significance of views in DBMS? How are views managed in SQL?
Explain with an example.
4. Explain any Two of the following
OLAP and its types
Spatial Databases
Dynamic SQL.
5. Discuss the following with suitable examples
UML Class Diagram
Query Optimization
6. What do you mean by Multi-versioning? What are the various schemes available for multiversioning?
Describe any two schemes in detail.
7. Describe the phases of Query processing by using a block diagram. Discuss the process of
Query optimization, by using suitable example.
8. Compare and contrast the following
Inclusion dependencies and Template dependencies
Centralized 2PL and Distributed 2PL
K-Means clustering and Nearest Neighbours clustering
9. What is multivalued dependency? How is 4 NF related to multivalued dependency? Is 4 NF
decomposition dependency preserving? Justify your answer.
10. Write short notes on any Two of the following
Semantic Databases
Temporal Databases
Embedded SQL
Master of Computer Application Part-III
PAPER-XXII
(MCS-043 Advanced Database Design)
Annual Examination, 2018
Time 3 Hours. Full Marks 80
Answer any Five Questions.
All questions carry equal marks.
1. Discuss classification as a tool in Data Mining. Describe the ID 3 algorithm for classifying data
sets with a suitable example.
2. What is Data Dictionary? What is the significance of creating Data Dictionary in DBMS? Explain
the statistics stored in the Data D.
3. What are views? What is the significance of views in DBMS? How are views managed in SQL?
Explain with an example.
4. Explain any Two of the following
OLAP and its types
Spatial Databases
Dynamic SQL.
5. Discuss the following with suitable examples
UML Class Diagram
Query Optimization
6. What do you mean by Multi-versioning? What are the various schemes available for multiversioning?
Describe any two schemes in detail.
7. Describe the phases of Query processing by using a block diagram. Discuss the process of
Query optimization, by using suitable example.
8. Compare and contrast the following
Inclusion dependencies and Template dependencies
Centralized 2PL and Distributed 2PL
K-Means clustering and Nearest Neighbours clustering
9. What is multivalued dependency? How is 4 NF related to multivalued dependency? Is 4 NF
decomposition dependency preserving? Justify your answer.
10. Write short notes on any Two of the following
Semantic Databases
Temporal Databases
Embedded SQL
Other Question Papers
Subjects
- (internet concepts and web design
- accounting & financial management
- advanced database design
- advanced discrete mathematics
- advanced internet technologies
- advanced internet technologies and computer graphics set-i
- advanced internet technologies and computer graphics set-ii
- application development with .net framework
- artificial intelligence and knowledge management
- c and assembly language programming
- communication skill
- communication skills
- computer graphics and multimedia
- computer networking
- computer organization
- computer organization and assembly language programming
- data and file structures
- data communication and computer networks
- database management system
- design and analysis of algorithm
- discrete mathematics
- internet concepts and web design
- introduction to database management systems
- lab (for data and file structures, networking and java programming)
- laboratory course
- management and information system
- mcs-041 : operating systems
- numerical and statistical computing
- object oriented analysis and design
- object oriented programming using java
- object oriented technologies and java programming
- operating system
- operating system concepts and networking management
- operating systems
- principles of management and information systems
- problem solving and programming
- problem solving using c
- software engineering
- system analysis and design
- systems analysis and design
- unix and oracle
- unix and oracle set-i
- unix and oracle set-ii