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
None of these
B
Complete
C
Abstract
D
Partial
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 Abstraction
B
Data Integrity
C
Data Isolation
D
None of these
Question 3
There are _________ levels of data abstraction.
A
3
B
2
C
4
D
1
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
Conceptual Level
B
Physical Level
C
None of these
D
View Level
Question 5
_______ of abstraction explains how data is actually stored and describes the Data Structure and Access methods used by database.
A
Physical Level
B
View Level
C
Conceptual 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.