Home »
MCQs »
DBMS MCQs
DBMS Data Independence Multiple-Choice Questions (MCQs)
DBMS Data Independence MCQs: This section contains DBMS Data Independence Multiple-Choice Questions (MCQs) and Answers.
Submitted by Anushree Goswami, on January 09, 2022
1. The ______ can be used to explain data independence.
- One-schema architecture
- Two-schema architecture
- Three-schema architecture
- Four-schema architecture
Answer: C) Three-schema architecture
Explanation:
The three-schema architecture can be used to explain data independence.
Discuss this Question
2. An independent database is a system that permits __________ modifications on one level without affecting the ____________ on the next level up.
- Instance
- Schema
- Both a and b
- None
Answer: B) Schema
Explanation:
An independent database is a system that permits schema modifications on one level without affecting the schema on the next level up.
Discuss this Question
3. How many types of data independence are there?
- 1
- 2
- 3
- 4
Answer: B) 2
Explanation:
There are 2 types of data independence.
Discuss this Question
4. Which of the following is not the type of data independence?
- Logical Data Independence
- Physical Data Independence
- Both A and B
- None
Answer: D) None
Explanation:
Logical Data and Physical Data Independence are both types of data independence.
Discuss this Question
5. An independent conceptual schema can be changed without having to change an ____ schema.
- Internal
- External
- Both A and B
- None
Answer: B) External
Explanation:
An independent conceptual schema can be changed without having to change an external schema.
Discuss this Question
6. Separating external data from ____ data is achieved using logical data independence.
- Logical
- Conceptual
- Analytical
- Physical
Answer: B) Conceptual
Explanation:
Separating external data from conceptual data is achieved using logical data independence.
Discuss this Question
7. What is TRUE about Logical Data Independence?
- We wouldn't impact the user view of the data if we changed the conceptual view of the data.
- User interfaces are logically independent of data.
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
In logical data independence –
- We wouldn't impact the user view of the data if we changed the conceptual view of the data.
- User interfaces are logically independent of data.
Discuss this Question
8. It is possible to change the internal schema without affecting the conceptual schema to achieve ___ data independence.
- Logical
- Physical
- Analytical
- Conceptual
Answer: B) Physical
Explanation:
It is possible to change the internal schema without affecting the conceptual schema to achieve physical data independence.
Discuss this Question
9. What is TRUE about Physical Data Independence?
- The Conceptual Structure of the database will not be affected by any changes made to the storage size of the database server.
- Separating conceptual levels from internal levels is achieved using physical data independence.
- The logical interface is where physical data independence occurs.
- All of the above
Answer: D) All of the above
Explanation:
In Physical Data Independence –
- The Conceptual Structure of the database will not be affected by any changes made to the storage size of the database server.
- Separating conceptual levels from internal levels is achieved using physical data independence.
- The logical interface is where physical data independence occurs.
Discuss this Question
10. What is the difference between logical data independence and physical data independence?
- The user interface is where physical data independence occurs whereas the logical interface is where logical data independence occurs.
- The logical interface is where physical data independence occurs whereas the user interface is where logical data independence occurs.
- The user interface is where physical and logical data independence occurs.
- The logical interface is where physical and logical data independence occurs.
Answer: B) The logical interface is where physical data independence occurs whereas the user interface is where logical data independence occurs
Explanation:
The logical interface is where physical data independence occurs whereas the user interface is where logical data independence occurs.
Discuss this Question