GATE CS 2021 (Afternoon) — Question 16

Database Management Systems (DBMS)Integrity Constraints & Functional DependenciesMCQ1 mark · −1/3 if wrongEasy

Consider the following statements \(S_1\) and \(S_2\) about the relational data model : \(S_1\) : A relation scheme can have at most one foreign key. \(S_2\) : A foreign key in a relation scheme \(R\) cannot be used to refer to tuples of \(R\). Which one of the following choices is correct?
  1. A
    Both \(S_1\) and \(S_2\) are true.
  2. B
    \(S_1\) is true and \(S_2\) is false.
  3. C
    \(S_1\) is false and \(S_2\) is true.
  4. D
    Both \(S_1\) and \(S_2\) are false.
Practise the full 2021-AN paper
Challenge a friend: WhatsApp Telegram
Recommended book · affiliate linkDatabase System Concepts (Korth)Normalisation, SQL, transactions and indexing — the DBMS syllabus in one book.
Practise more on Integrity Constraints & Functional DependenciesTimed, in the real exam interface · free to start

A GATE question every morning

One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.

Join
Stuck? Ask in the student group