Computer Sciences > GATE 2014 SET-1 > Relational Database
Given the following statements:
S1: A foreign key declaration can always be replaced by an equivalent check assertion in SQL.
S2: Given the table R(a, b, c) where a and b together form the primary key, the following is a valid table definition.
CREATE TABLE S(
d INT,
e INT,
PRIMARY KEY (d),
FOREIGN KEY (a) REFERENCES R
)
Which one of the following statements is CORRECT?
S1: A foreign key declaration can always be replaced by an equivalent check assertion in SQL.
S2: Given the table R(a, b, c) where a and b together form the primary key, the following is a valid table definition.
CREATE TABLE S(
d INT,
e INT,
PRIMARY KEY (d),
FOREIGN KEY (a) REFERENCES R
)
Which one of the following statements is CORRECT?
Correct : d
Similar Questions
Consider the relation scheme R = (E, F, G, H, I, J, K, L, M, N) and the set of functional dependencies {{E, F} → {G}, {F} → {I, J}, {E, H} → {K,...
A palindrome is a word that reads the same forwards and backwards. In a game
of words, a player has the following two plates painted with letters.
From...
Which number does not belong in the series below?
2, 5, 10, 17, 26, 37, 50, 64
Total Unique Visitors
Loading......