CAF-3 · Chapter 5 · Question 4 of 15
Once an online order is confirmed by the DBMS, the changes are permanently saved in the database. Even if a sudden power failure occurs immediately afterward, the order record will not be lost. This is an example of:
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: D) Durability
Explanation
Durability guarantees that once a transaction is committed, its effects are permanently saved and recoverable, even in the event of a system crash or power failure . --------------------------------------------------------------------------------
More Types of DBMS MCQs
- Q6Which level of the DBMS architecture acts as the global logical view of the entire database, defining entities, attributes, and…
- Q7The 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…
- Q8The ability to modify the physical storage mechanisms (like changing hard drives or compressing data) without impacting the logical…
- 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…