Question

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

A) It has high scalability and performance that can enable almost unlimited growth
B) It has flexible data models that make it easy to store and combine
data of any structure and allow dynamic changes to the schema.
C) It is designed for highly available systems that should provide a consistent, high-quality experience for all users globally
D) It uses primary keys and foreign keys as a means to provide
efficient access to data and is supported directly in the database
rather than maintained in the application code.

Answer 1

It uses primary keys and foreign keys as a means to provide efficient access to data and is supported directly in the database rather than maintained in the application code.

Explanation: Relational databases use an expressive query language, make efficient use of indexes within the database, ensure strong consistency, and fit well within an enterprise management system. Non-relational databases have a flexible data model, have high scalability, and performance, and have always-on global deployments.