GATE CS 2017 (Afternoon) — Question 19

Database Management Systems (DBMS)Integrity Constraints & Functional DependenciesNAT1 markMedium

Consider the following tables \(T_1\) and \(T_2\).
Question image
In table \(T_1\), \(P\) is the primary key and \(Q\) is the foreign key referencing \(R\) in table \(T_2\) with on-delete cascade and on-update cascade. In table \(T_2\), \(R\) is the primary key and \(S\) is the foreign key referencing \(P\) in table \(T_1\) with on-delete set NULL and on-update cascade. In order to delete record (3,8) from table \(T_1\), the number of additional records that need to be deleted from table \(T_1\) is ________.
Practise the full 2017-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