GATE CSE · 2017 · CS
Question 19: Databases
Give it a try, then reveal the answer to check your work.
Question 19
CSNAT1 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 answerEXPLORE & PRACTISE
Paper and topic context
See where this question comes from and choose what to practise next.
2017CS
GATE CSE 2017 · Paper 2
Computer Science and Information Technology · Original paper archive
- Section
- Computer Science and Information Technology
- Question type
- Numerical answer (NAT)
- Marks
- 1 mark
Practise related topics
Explore more previous year questions using this question’s imported topic tags.
computer science
GATE CSE previous year questions
information technology
GATE CSE previous year questions
computing
GATE CSE previous year questions
databases
GATE CSE previous year questions
Comments
Ask a question, share your approach, or help someone understand.
Log in to view the discussion
You’re not logged in. Log in or create an account to see discussions and add comments.