1
GATE CSE 2005
MCQ (Single Correct Answer)
+2
-0.6
The following table has two attributes $$A$$ and $$C$$ where $$A$$ is the primary key and $$C$$ is the foreign key referencing $$A$$ with on-delete cascade. GATE CSE 2005 Database Management System - Er Diagrams Question 8 English

The set of all tuples that must be additionally deleted to preserve referential integrity. When the tuple $$(2,4)$$ is deleted is:

A
$$(3,4)$$ and $$(6,4)$$
B
$$(5,2)$$ and $$(7,2)$$
C
$$(5, 2),$$ $$(7,2)$$ and $$(9,5)$$
D
$$(3, 4),(4,3)$$ and $$(6,4)$$
2
GATE CSE 2005
MCQ (Single Correct Answer)
+2
-0.6
Let $${E_1}$$ and $${E_2}$$ be two entities in an E-R diagram with simple single-valued attributes, $${E_1}$$ and $${E_2}$$ are two relationships between $${E_1}$$ and $${E_2}$$, Where $${E_1}$$ is one-to-many and $${E_2}$$ is many-to-many. $${E_1}$$ and $${E_2}$$ do not have any attributes of their own. What is the minimum number of tables required represent this situation in the relation model?
A
$$2$$
B
$$3$$
C
$$4$$
D
$$5$$
3
GATE CSE 2005
MCQ (Single Correct Answer)
+1
-0.3
The set $$\left\{ {1,\,\,2,\,\,4,\,\,7,\,\,8,\,\,11,\,\,13,\,\,14} \right\}$$ is a group under multiplication modulo $$15$$. The inverse of $$4$$ and $$7$$ are respectively:
A
$$3$$ and $$13$$
B
$$2$$ and $$11$$
C
$$4$$ and $$13$$
D
$$8$$ and $$14$$
4
GATE CSE 2005
MCQ (Single Correct Answer)
+2
-0.6
Consider the following system of equations in three real variables $$x1, x2$$ and $$x3$$ :
$$2x1 - x2 + 3x3 = 1$$
$$3x1 + 2x2 + 5x3 = 2$$
$$ - x1 + 4x2 + x3 = 3$$
This system of equations has
A
no solution
B
a unique solution
C
more than one but a finite number of solutions
D
an infinite number of solutions
EXAM MAP