Exam Details
| Subject | dbms (data base management systems) | |
| Paper | ||
| Exam / Course | pg diploma in information technology (pgdit) | |
| Department | ||
| Organization | acharya nagarjuna university-distance education | |
| Position | ||
| Exam Date | May, 2018 | |
| City, State | new delhi, new delhi |
Question Paper
Total No. of Questions 10] [Total No. of Pages 02
P.G. DIPLOMA DEGREE EXAMINATION, MAY 2018
INFORMATION TECHNOLOGY
DBMS (Data Base Management System)
Time 3 Hours Maximum Marks 70
Answer any FIVE questions
All questions carry equal marks
Q1) Discuss components of information system and also different types of information
system.
Q2) Explain about indexed sequential and direct access file organization with neat sketch.
Q3) Write about pointer types and location methods with suitable example.
Q4) Explain about network and relational data models with proper example.
Q5) State and explain about different normal forms with appropriate examples.
Q6) Write about various symbols used database action diagrams.
Q7) What is information management system Write about IMS database description.
Q8) Explain about data manipulation language of IDMS.
Q9) Discuss about relational algebra operations and relational calculus commands.
Q10) Explain about concurrency control mechanism in detail.
P.G. DIPLOMA DEGREE EXAMINATION, MAY 2018
INFORMATION TECHNOLOGY
DBMS (Data Base Management System)
Time 3 Hours Maximum Marks 70
Answer any FIVE questions
All questions carry equal marks
Q1) Discuss components of information system and also different types of information
system.
Q2) Explain about indexed sequential and direct access file organization with neat sketch.
Q3) Write about pointer types and location methods with suitable example.
Q4) Explain about network and relational data models with proper example.
Q5) State and explain about different normal forms with appropriate examples.
Q6) Write about various symbols used database action diagrams.
Q7) What is information management system Write about IMS database description.
Q8) Explain about data manipulation language of IDMS.
Q9) Discuss about relational algebra operations and relational calculus commands.
Q10) Explain about concurrency control mechanism in detail.