Bright Tutorials Bright Tutorials
CBSE Class 11 Informatics Practices Question 1 of 87

Structured Query Language (SQL) — Question 1

Back to all questions
1
Question

Question 1

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

Reasoning (R): If a piece of data is stored in two places in the databases, then storage space is wasted.

  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.