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
354k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow