hamburger menu
All Coursesall course arrow
adda247
reward-icon
adda247
    arrow
    arrow
    arrow
    How does a relational database ensure data integrity?
    Question



    How does a relational database ensure data integrity?

    A.

    By encrypting all data stored

    B.

    By enforcing rules defined in the schema

    C.

    By compressing data for efficient storage 

    D.

    By allowing unrestricted access to all users

    Correct option is B

    Data integrity in relational databases is upheld through schema constraints, which include primary keys, foreign keys, and other validation rules that enforce accurate and reliable data entry.
    Information Booster:
    · Schema Constraints: Ensure that data complies with set rules, preventing anomalies.
    · Foreign Key Constraints: Ensure referential integrity across tables.
    Additional Knowledge:
    · Encryption secures data but does not enforce integrity rules.
    · Compression is for storage efficiency, unrelated to integrity.
    · Unrestricted Access is contrary to controlled data integrity.

    Free Tests

    Free
    Must Attempt

    Basics of Education: Pedagogy, Andragogy, and Hutagogy

    languageIcon English
    • pdpQsnIcon10 Questions
    • pdpsheetsIcon20 Marks
    • timerIcon12 Mins
    languageIcon English
    Free
    Must Attempt

    UGC NET Paper 1 Mock Test 1

    languageIcon English
    • pdpQsnIcon50 Questions
    • pdpsheetsIcon100 Marks
    • timerIcon60 Mins
    languageIcon English
    Free
    Must Attempt

    Basics of Education: Pedagogy, Andragogy, and Hutagogy

    languageIcon English
    • pdpQsnIcon10 Questions
    • pdpsheetsIcon20 Marks
    • timerIcon12 Mins
    languageIcon English

    Similar Questions

    test-prime-package

    Access ‘UGC NET Computer Science’ Mock Tests with

    • 60000+ Mocks and Previous Year Papers
    • Unlimited Re-Attempts
    • Personalised Report Card
    • 500% Refund on Final Selection
    • Largest Community
    students-icon
    368k+ students have already unlocked exclusive benefits with Test Prime!
    Our Plans
    Monthsup-arrow