Lec 50: GATE 2024 Preparation | GATE 2017 PYQ By Jayesh Umre
54 بار بازدید -
7 ماه پیش
-
GATE 2017 PYQConsider the following
GATE 2017 PYQ
Consider the following tables T1 and T2.
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 ______.
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
WebSite: www.EasyExamNotes.com
Our FB page: Facebook: EasyExamNotesDotCom
Lectures Library:
1) Analysis & Design of Algorithm: Video
2) Data Structure Lectures: Video
3) Computer Organization Architecture: Computer Organization Architecture
4) Operating System Lectures: Fragmentation (Hindi) | OS | Jayesh Umre
5) Theory Of Computation Lectures: Lec-4 Draw a DFA accepting strings s...
6) DBMS Lectures: RDBMS (Hindi) | Jayesh Umre
7) Principles Of Programming Languages: Language Evaluation Criteria | PPL | ...
8) Internet Of Things: IOT Conceptual Framework in Hindi | J...
9) Discrete Structures: Prove set G= {1, 2, 3, 4, 5, 6} is ab...
10) Cloud Computing Lectures: RAID-Redundant Array of Independent D...
11) Software Engineering: RAD model | SDLC | Jayesh Umre
12) Digital Circuits: Half Adder | Jayesh Umre
13) Number System: 10's Complement | Jayesh Umre
14) GATE Mathematics: GATE | Adjoint of a Matrix | Jayesh Umre
15) Management Information System: MIS in Hindi
16) Computer Network: Computer Networks in Hindi
====================================================
Consider the following tables T1 and T2.
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 ______.
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
WebSite: www.EasyExamNotes.com
Our FB page: Facebook: EasyExamNotesDotCom
Lectures Library:
1) Analysis & Design of Algorithm: Video
2) Data Structure Lectures: Video
3) Computer Organization Architecture: Computer Organization Architecture
4) Operating System Lectures: Fragmentation (Hindi) | OS | Jayesh Umre
5) Theory Of Computation Lectures: Lec-4 Draw a DFA accepting strings s...
6) DBMS Lectures: RDBMS (Hindi) | Jayesh Umre
7) Principles Of Programming Languages: Language Evaluation Criteria | PPL | ...
8) Internet Of Things: IOT Conceptual Framework in Hindi | J...
9) Discrete Structures: Prove set G= {1, 2, 3, 4, 5, 6} is ab...
10) Cloud Computing Lectures: RAID-Redundant Array of Independent D...
11) Software Engineering: RAD model | SDLC | Jayesh Umre
12) Digital Circuits: Half Adder | Jayesh Umre
13) Number System: 10's Complement | Jayesh Umre
14) GATE Mathematics: GATE | Adjoint of a Matrix | Jayesh Umre
15) Management Information System: MIS in Hindi
16) Computer Network: Computer Networks in Hindi
====================================================
7 ماه پیش
در تاریخ 1402/11/13 منتشر شده
است.
54
بـار بازدید شده