Computer Science and Information Technology
2017 · Paper 2
Take it one question at a time. Try an answer, then check your understanding.
Complete GATE CSE 2017 Paper 2 overview, original pages and practice · Timed previous-paper practice
Questions 19–21 of 65. Imported answers require review unless explicitly marked reviewed.
Question 19
Open questionCSNAT1 markNeeds review
Consider the following tables T1 and T2.
T1:
P | Q |
|---|---|
2 | 2 |
3 | 8 |
7 | 3 |
5 | 8 |
6 | 9 |
8 | 5 |
9 | 8 |
T2:
R | S |
|---|---|
2 | 2 |
8 | 3 |
3 | 2 |
9 | 7 |
5 | 7 |
7 | 2 |
In table T1, P is the primary key and Q is the foreign key referencing R in table T2 with on-delete cascade and on-update cascade. In table T2, R is the primary key and S is the foreign key referencing P in table T1 with on-delete set NULL and on-update cascade. In order to delete record (3, 8) from table T1, the number of additional records that need to be deleted from table T1 is __________.
Log in to check the answer
You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answerQuestion 20
Open questionCSNAT1 markNeeds review
The maximum number of IPv4 router addresses that can be listed in the record route (RR) option field of an IPv4 header is __________.
Log in to check the answer
You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answerQuestion 21
Open questionCSNAT1 markNeeds review
Consider the set
under the partial ordering
.
The Hasse diagram of the partial order
is shown below. 
The minimum number of ordered pairs that need to be added to
to make
a lattice is __________.Log in to check the answer
You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answer