Get premium membership and access revision papers, questions with answers as well as video lessons.

Database Management Systems Question Paper

Database Management Systems

Course:Diploma In Information Communication Technology Module Ii

Institution: Masai Technical Training Institute question papers

Exam Year:2016

MASAI TECHNICAL TRAINING INSTITUTE
DIPLOMA
MODULE II
ICT/DBMS
2016 Term III – 19th SEPTEMBER 2016.
54 Minutes
1. Define the following terms
a) Database b) DBMS c) Program & Data independence d) end user e)DBA f) Data model g) Database schema h) DDL
i) External schema j) conceptual schema k) DML l) VDL
2. Explain: i) Logical data independence ii) Physical data independence
3. Describe the role of DBA in DBMS
4. Define Schema and instance.
5. What are the elements of a database?
6. Why do we need DBMS?
7. Explain each of the following with advantage and disadvantage of its own?
i) Hierarchical data base model.ii) Network database mode.iii) Object Oriented database model.
8. Discuss some types of database utilities and their functions. 06
9. Discuss the different classifications of DBMS. 06
10. What is a database schema? What is the difference between external and internal schema?
11. What are the characteristics of a data in a database? 06
12. With a neat diagram, explain Three-Schema-Architecture. 06*
13. Discuss the main characteristics of the database approach. 08
14. What are the responsibilities of the DBA and the database designers? 08
15. What is the difference between logical data independence and physical data independence? Which is easier to accomplish? Why?
Define the following terms
a) Entity
b) Attribute
c) Relationship instance
d) Multi valued Attribute.
16. How is traditional file processing different from database approach? 08*
17. Explain the types of software components which constitute a DBMS and the types of computer system software with which
DMBS interacts.
18. Discuss the main characteristics of the database approach. 08
19. What are the responsibilities of the DBA and the database designers? 08
20. Discuss some types of database utilities and their functions. 08
21. What do you mean by Database Management System? Explain the various advantages of using a Database management
System?
22. With a neat figure explain the database system. 10
23. Who are the different types of database end users? Discuss the main activities of each of them.
24. What is a database? Why do we need a database? Describe the organization of database?
25. Explain the advantages of database approach over file processing.
26. Who are the different types of database end users? Discuss the main

Database Management Systems question paper

Database Management Systems Question Paper

More Question Papers

Popular Exams