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 6 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)
+1
-0.3
Consider the entities 'hotel room', and 'person' with a many to many relationship 'lodging' as shown below GATE CSE 2005 Database Management System - Er Diagrams Question 5 English

If we wish to store information about the rent payment to be made by person(s) occupying different hotel rooms, then this information should appear as an attribute of

A
Person
B
Hotel Room
C
Lodging
D
None of these
3
GATE CSE 2005
MCQ (Single Correct Answer)
+1
-0.3
A table has fields, $$F1, F2, F3, F4, F5,$$ with the following functional dependencies:
$$F1 \to F3.\,F2 \to F4.\,\,\,\left( {F1\,.\,F2} \right) \to F5$$ in terms of Normalization, this table is in
A
$$1NF$$
B
$$2NF$$
C
$$3NF$$
D
None of these
4
GATE CSE 2005
MCQ (Single Correct Answer)
+1
-0.3
Which one of the following statements about normal forms is FALSE?
A
$$BCNF$$ is stricter than $$3NF$$
B
Lossless, dependency $$-$$ preserving decomposition into $$3NF$$ is always possible
C
Lossless, dependency - preserving decomposition into $$BCNF$$ is always possible
D
Any relation with two attributes is in $$BCNF$$
EXAM MAP
Medical
NEET
Graduate Aptitude Test in Engineering
GATE CSEGATE ECEGATE EEGATE MEGATE CEGATE PIGATE IN
CBSE
Class 12