GATE DA 2025 — Question 56

Database Management and Warehousingintegrity constraints, normal formMSQ2 marksEasy

Consider the following two relations, named Customer and Person, in a database:
sql
1Person (
2    aadhaar CHAR(12) PRIMARY KEY,
3    name VARCHAR(32));
4Customer (
5    name VARCHAR(32),
6    email VARCHAR(32) PRIMARY KEY,
7    phone CHAR(10),
8    aadhaar CHAR(12),
9      FOREIGN KEY (aadhaar) REFERENCES Person(aadhaar));
10
Which of the following statements is/are correct?
  1. A
    aadhaar is a candidate key in the Customer relation
  2. B
    phone can be NULL in the Customer relation
  3. C
    aadhaar is a candidate key in the Person relation
  4. D
    aadhaar can be NULL in the Person relation
Practise the full 2025 paper
Challenge a friend: WhatsApp Telegram
From RENYXERAFree All-India Mock — every SundayA full GATE CS paper, exactly 180 minutes, ranked across India with your GATE score.
Practise more on integrity constraints, normal formTimed, 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