Question

Which of the following is a key feature of a relational database?

O It ensures strong consistency such that applications should be able to read what has been written to the database immediately.

O It has flexible data models that make it easy to store and combine data of any structure and allow dynamic changes to the schema.

O It has a broad umbrella of a variety of approaches with data storage and manipulation.

O It is designed for highly available systems that should provide a consistent, high-quality experience for all users globally.

Answer 1

A key feature of a relational database is strong consistency.

Therefore, the correct answer is: option 'It ensures strong consistency such that applications should be able to read what has been written to the database immediately.'

Step-by-step explanation:

A relational database is a collection of information that organizes data in predefined relationships where data is stored in one or more tables (or "relations") of columns and rows, making it easy to see and understand how different data structures relate to each other.

The key feature of a relational database is that it ensures strong consistency, meaning that applications can read what has been written to the database immediately. This ensures that the data is up to date and accurate for all users.

Relational databases also have a flexible data model, making it easy to store and combine data of any structure. This allows for dynamic changes to the schema, such as adding or modifying tables, without affecting existing data.

Lastly, relational databases are designed for highly available systems that provide a consistent and high-quality experience for all users globally. This means that the database is accessible to users at any time and can handle large amounts of incoming data.