Exam Details
| Subject | database management system | |
| Paper | paper 14 | |
| 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-II
PAPER-XIV
(Database Management System)
Annual Examination, 2018
Time 3 Hours. Full Marks 80
Answer any Five Questions.
All questions carry equal marks.
1. What is a data model? Describe different types of data model.
2. Describe the architecture of DBMS with a diagram.
3. Discuss the twelve Codd's rule defined for relational model of database.
4. Write at least ten queries in SQL with their complete syntax and meaning.
5. What is Normalization? Explain second normal form and third normal form with an example.
6. Define cost estimation. What are different components that effect cost optimization of a
query?
7. What is a transaction? Discuss the ACID properties of a transaction.
8. Discuss the different granularity levels used for locking.
9. Differentiate between primary and secondary storage. How multilevel indexing improve the
efficiency of searching an index file?
10. Write short notes on the following
Specialization.
Generalization.
Master of Computer Application Part-II
PAPER-XIV
(Database Management System)
Annual Examination, 2018
Time 3 Hours. Full Marks 80
Answer any Five Questions.
All questions carry equal marks.
1. What is a data model? Describe different types of data model.
2. Describe the architecture of DBMS with a diagram.
3. Discuss the twelve Codd's rule defined for relational model of database.
4. Write at least ten queries in SQL with their complete syntax and meaning.
5. What is Normalization? Explain second normal form and third normal form with an example.
6. Define cost estimation. What are different components that effect cost optimization of a
query?
7. What is a transaction? Discuss the ACID properties of a transaction.
8. Discuss the different granularity levels used for locking.
9. Differentiate between primary and secondary storage. How multilevel indexing improve the
efficiency of searching an index file?
10. Write short notes on the following
Specialization.
Generalization.
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