CAF-3 · Chapter 5 · Question 9 of 15
A database administrator adds a new column, "Customer_Age", to an existing table. This modification to the schema does not break the existing front-end software applications. This is an example of:
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: A) Logical Data Independence
Explanation
Logical data independence means that changes to the logical schema (e.g., adding a column) do not affect the external views or the application layer . --------------------------------------------------------------------------------
More Types of DBMS MCQs
- Q11A university database shows that one student can enroll in multiple courses, and each course can have multiple students enrolled in it…
- Q12What term is used in database design to specify the maximum number of relationship instances in which an entity can participate (such as…
- Q13Which type of Database Management System organizes data in a strict tree-like structure where each child record can have only one parent?
- Q14Oracle, MySQL, and Microsoft SQL Server are highly popular systems that organize data into tables containing rows and columns. These are…
- Q15Which type of DBMS supports concepts like 'Inheritance' and 'Polymorphism', storing data as entities that contain both the data and the…