Which of the following is independent of the choice of a DBMS?
A) Entity Relationship Diagrams
B) Distribution Schema
C) Internal Schema
D) Index files

Question

Quizplus · Accepted Answer

Entity Relationship Diagrams are a high-level conceptual modeling technique to represent data entities, their attributes, and the relationships between them. They are not dependent on any specific DBMS technology and can be used in designing data models for various DBMS systems.

Answer: D
 Index files are used to optimize query performance by providing quick access to the data stored in the database. They are specific to each DBMS vendor, but the concept of indexing and its usage is common across all DBMS technologies. Therefore, they are partially dependent on the DBMS, but not entirely independent like Entity Relationship Diagrams.

Which of the Following Is Independent of the Choice of a DBMS