Table of Content

DBMS MCQ : Instance and Schema (Multiple Choice Questions)


Question 1
Ability to modify schema of database in one level without affecting the schema definition in higher level is called as __________.
A
Data Isolation
B
Data Abstraction
C
Data Migration
D
Data Independance
Question 2
There are _________ levels of data independence.
A
3
B
1
C
2
D
4
Question 2 Explanation: 
Two Levels of data independence are - Physical and Logical data independence.
Question 3
Physical Data Independence is ability to modify _____________ without causing application program to rewrite.
A
Physical Schema
B
Conceptual Schema
C
Logical Schema
Question 4
Logical Data independence is ability to modify ____________ without causing application program to rewrite.
A
Logical Schema
B
Physical Schema
C
Conceptual Schema
Question 5
Data independence is the type of data transparency that matters for a centralized DBMS.
A
True
B
False
There are 5 questions to complete.

Pages: Page 1, Page 2, Page 3