DBMS MCQ : Levels of Abstraction (Multiple Choice Questions)


Congratulations - you have completed Database Management System.

You scored %%SCORE%% out of %%TOTAL%%.

Your performance has been rated as %%RATING%%


Your answers are highlighted below.
Question 1
A main purpose of DBMS is to provide ____________ view of data to user.
A
Complete
B
Partial
C
Abstract
D
None of these
Question 1 Explanation: 
Complexity of Database and its implementation details are hidden from the user.
Question 2
____________ means to hide certain details of how data is stored and maintain.
A
Data Isolation
B
None of these
C
Data Abstraction
D
Data Integrity
Question 3
There are _________ levels of data abstraction.
A
2
B
1
C
4
D
3
Question 3 Explanation: 
3 Levels of abstraction are : Physical Level, Conceptual Level and View Level.
Question 4
In data abstraction which is lowest level of abstraction ?
A
View Level
B
Physical Level
C
Conceptual Level
D
None of these
Question 5
_______ of abstraction explains how data is actually stored and describes the Data Structure and Access methods used by database.
A
View Level
B
Conceptual Level
C
Physical Level
Once you are finished, click the button below. Any items you have not completed will be marked incorrect. Get Results
There are 5 questions to complete.