WorksheetsDBMS UNIT 1 - Test 3
Total questions: 10
Worksheet time: 6mins
A ...................... is a collection of interrelated data and a set of programs that allow users to access and modify these data.
Database system
Concurrent System
Record
File
The process of hiding irrelevant details from the user is called as (a)
The main purpose of data abstraction is
Achieving logical independence
Achieving data dependence
Achieving logical dependence
Achieving data independence
Which level tells us that where the data is actually stored?
Logical
Physical
External
Conceptual
.....................is a very low-level representation of the entire database.
View Schema
Logical Schema
Internal Schema
None
Data Independence means
Users and data should directly interact with each other.
Users and data should not directly interact with each other.
Data only should directly interact with each other.
Users only should directly interact with each other.
A major purpose of a database system is to provide users with an ............................ view of the data.
Logical
Internal
External
Abstract
• If we want to access any mail from our Gmail then we don't know where that data is physically stored i.e is the data present in India or USA or what data model has been used to store that data? We are not concerned about these things. We are only concerned with our email. So, information like these i.e. location of data and data models are irrelevant to us.
The above is an example of
Data Independence
Data Abstraction
Data Dependence
None of these
..................... is the highest level from the three levels of data abstraction.
View Schema
Physical Schema
Logical Schema
External Schema
Choose the correct order of levels of abstraction:
Physical, External, Conceptual
Physical, Conceptual, External
External, Physical, Conceptual
Conceptual, External,Physical
