Exam Details
| Subject | database management systems | |
| Paper | ||
| Exam / Course | m.sc. information technology | |
| Department | ||
| Organization | acharya nagarjuna university-distance education | |
| Position | ||
| Exam Date | May, 2018 | |
| City, State | new delhi, new delhi |
Question Paper
Total No. of Questions 18] [Total No. of Pages 2
M.Sc. DEGREE EXAMINATION, MAY 2018
First Year
INFORMATION TECHNOLOGY
DBMS (Database Management Systems)
Time 3 Hours Maximum Marks 70
SECTION A × 15 45)
Answer any THREE questions
Q1) Discuss about features of conventional file system and describe its limitations.
Q2) Explain about hierarchical and network data models with neat diagrams.
Q3) What is normalization? Discuss different normal forms with example.
Q4) Discuss various IMS data manipulation commands with syntax.
Q5) Explain about concurrency control mechanism with suitable example.
SECTION B × 4 20)
Answer any five questions
Q6) Describe association between fields.
Q7) Write about physical address pointer and relative address pointer.
Q8) Briefly explain about multi list data structure with example.
Q9) Describe various database design steps.
Q10) Write about symbols used in database action diagram.
Q11) Briefly explain about data description language.
Q12) Explain UNION and INTERSECT commands of interactive SQL with example.
Q13) What is timestamp? Explain about time stamp protocol.
SECTION C × 1
Answer all questions
Q14) What is expert system?
Q15) Define meta data.
Q16) What is pointer?
Q17) What is conceptual data model?
Q18) What is database recovery?
M.Sc. DEGREE EXAMINATION, MAY 2018
First Year
INFORMATION TECHNOLOGY
DBMS (Database Management Systems)
Time 3 Hours Maximum Marks 70
SECTION A × 15 45)
Answer any THREE questions
Q1) Discuss about features of conventional file system and describe its limitations.
Q2) Explain about hierarchical and network data models with neat diagrams.
Q3) What is normalization? Discuss different normal forms with example.
Q4) Discuss various IMS data manipulation commands with syntax.
Q5) Explain about concurrency control mechanism with suitable example.
SECTION B × 4 20)
Answer any five questions
Q6) Describe association between fields.
Q7) Write about physical address pointer and relative address pointer.
Q8) Briefly explain about multi list data structure with example.
Q9) Describe various database design steps.
Q10) Write about symbols used in database action diagram.
Q11) Briefly explain about data description language.
Q12) Explain UNION and INTERSECT commands of interactive SQL with example.
Q13) What is timestamp? Explain about time stamp protocol.
SECTION C × 1
Answer all questions
Q14) What is expert system?
Q15) Define meta data.
Q16) What is pointer?
Q17) What is conceptual data model?
Q18) What is database recovery?
Subjects
- artificial intelligence
- basics of information technology
- computer networks
- computer organisation
- cryptography & network security
- data mining and techniques
- data structures with c
- database management systems
- operating systems
- programming with c++
- software engineering
- tcp / ip