Question

    Which of the following is a characteristic feature of a Relational Database Management System (RDBMS)?

    A It supports unstructured data storage Correct Answer Incorrect Answer
    B It enforces data integrity through constraints like primary keys and foreign keys Correct Answer Incorrect Answer
    C It uses a hierarchical model for data representation Correct Answer Incorrect Answer
    D It does not support multi-user environments Correct Answer Incorrect Answer
    E It lacks ACID properties. Correct Answer Incorrect Answer

    Solution

    One of the fundamental characteristics of a Relational Database Management System (RDBMS) is its ability to enforce data integrity through the use of constraints such as primary keys, which ensure that each row is uniquely identified, and foreign keys, which maintain referential integrity between related tables. This feature helps prevent data anomalies and ensures consistency within the database. Why Other Options are Wrong: a) RDBMS is designed for structured data, not unstructured data. c) RDBMS uses a relational model, not a hierarchical one. d) RDBMS is designed to support multi-user environments with concurrent access. e) RDBMS strictly follows ACID (Atomicity, Consistency, Isolation, Durability) properties, which guarantee reliable transactions.

    Practice Next