Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 6 of 103

Review of Database Concepts & SQL — Question 6

Back to all questions
6
Question

Question 6

Assertion (A): A database can have only one table.

Reasoning (R): If a piece of data is stored in two places in a database, then it leads to wastage of storage space.

  1. Both A and R are true and R is the correct explanation of A.
  2. Both A and R are true but R is not the correct explanation of A.
  3. A is true but R is false.
  4. A is false but R is true.
Answer

A is false but R is true.

Explanation
A database can have multiple tables. Data redundancy, which occurs when the same data is repeated in multiple places within a database, leads to wastage of storage space. A DBMS eliminates data redundancy by integrating files, ensuring that multiple copies of the same data are not stored.