CAF-3 · Chapter 5 · Question 7 of 15
The IT department decides to re-index the database and move the data files to a new, faster SSD storage drive. This change does not affect how the users query the data. This represents which level of the DBMS architecture?
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: C) Internal Level
Explanation
The Internal Level (or Physical Level) deals with the physical storage of the database on disks, including the use of file structures, data blocks, and indexing strategies . --------------------------------------------------------------------------------
More Types of DBMS MCQs
- Q9A database administrator adds a new column, "Customer_Age", to an existing table. This modification to the schema does not break the…
- Q10In an Entity-Relationship model, an attribute such as 'FullName' that can be further broken down into 'FirstName' and 'LastName' is…
- 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?