10th Class Computers Science Database Management 2 Question Bank

done Assertion And Reason (MCQs) - Data Base Management System Total Questions - 5

• question_answer1)

  Direction: In the questions given below, there are two statements marked as Assertion (A) and Reason (R). Choose the correct option out of the choices given below in each question:

  Assertion (A): Primary key is a set of one or more attributes that identify tuples in a relation.

  Reason (R): Every table must have one primary key.

  A)
  Both (A) and (R) are correct and (R) is correct explanation of (A). done clear
  B)
  Both (A) and (R) are correct and (R) is not the correct explanation of (A). done clear
  C)
  (A) is True but (R) is False. done clear
  D)
  (A) is False but (R) is True. done clear
  View Solution play_arrow

• question_answer2)

  Direction: In the questions given below, there are two statements marked as Assertion (A) and Reason (R). Choose the correct option out of the choices given below in each question:

  Assertion (A): Foreign key is a non-key attribute whose value is derived from primary key of another table.

  Reason (R): Each foreign key refers a candidate key in a relation.

  A)
  Both (A) and (R) are correct and (R) is correct explanation of (A). done clear
  B)
  Both (A) and (R) are correct and (R) is not the correct explanation of (A). done clear
  C)
  (A) is True but (R) is False. done clear
  D)
  (A) is False but (R) is True. done clear
  View Solution play_arrow

• question_answer3)

  Direction: In the questions given below, there are two statements marked as Assertion (A) and Reason (R). Choose the correct option out of the choices given below in each question:

  Assertion (A): Data Integrity means that data is accurate and consistent in the database.

  Reason (R): Data integrity also ensures that your data is safe from any outside forces.

  A)
  Both (A) and (R) are correct and (R) is correct explanation of (A). done clear
  B)
  Both (A) and (R) are correct and (R) is not the correct explanation of (A). done clear
  C)
  (A) is True but (R) is False. done clear
  D)
  (A) is False but (R) is True. done clear
  View Solution play_arrow

• question_answer4)

  Direction: In the questions given below, there are two statements marked as Assertion (A) and Reason (R). Choose the correct option out of the choices given below in each question:

  Assertion (A): There can be multiple primary key in a table.

  Reason (R): Duplicate values cannot be entered in primary key.

  A)
  Both (A) and (R) are correct and (R) is correct explanation of (A). done clear
  B)
  Both (A) and (R) are correct and (R) is not the correct explanation of (A). done clear
  C)
  (A) is True but (R) is False. done clear
  D)
  (A) is False but (R) is True. done clear
  View Solution play_arrow

• question_answer5)

  Direction: In the questions given below, there are two statements marked as Assertion (A) and Reason (R). Choose the correct option out of the choices given below in each question:

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

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

  A)
  Both (A) and (R) are correct and (R) is correct explanation of (A). done clear
  B)
  Both (A) and (R) are correct and (R) is not the correct explanation of (A). done clear
  C)
  (A) is True but (R) is False. done clear
  D)
  (A) is False but (R) is True. done clear
  View Solution play_arrow