Register

Recent questions tagged referential-integrity

1 votes
2 answers
3
NIELIT Scientific Assistant A 2020 November: 97
Domain constraints, functional dependency and referential integrity are special forms of _______ Foreign key Primary key Assertion Referential constraint
Domain constraints, functional dependency and referential integrity are special forms of _______Foreign keyPrimary keyAssertionReferential constraint
User Avatar
1 votes
1 answer
5
ER Model Self Doubt
How to represent referential integrity constraint in ER model? pls explain with diagram
How to represent referential integrity constraint in ER model?pls explain with diagram
User Avatar
4 votes
3 answers
6
NIELIT 2018-49
The following table has two attributes $X$ and $Y$ where $X$ is the primary key and $Y$ is the foreign key referencing $X$ ... $(4,3)$ and $(6,4)$ $(2,4)$ and $(7,2)$ $(3,2)$ and $(9,5)$ $(3,4), (4,5)$ and $(6,4)$
The following table has two attributes $X$ and $Y$ where $X$ is the primary key and $Y$ is the foreign key referencing $X$ with on-delete cascade.$\begin{array}{|c|c|} \h...
User Avatar
0 votes
2 answers
9
Test question
Consider the join of a relation R with a relation S. If R has 100 tuples and S has 9 tuples then the maximum and minimum sizes of the join respectively under referential integrity constraint: 9 and 0 9 and 9 9+100 and 0 9*100 and 9
Consider the join of a relation R with a relation S. If R has 100 tuples and S has 9 tuples then the maximum and minimum sizes of the join respectively under referential ...
User Avatar
0 votes
1 answer
11
Referential Integrity
Consider the join of a relation R with a relation S. If R has 100 tuples and S has 9 tuples then the maximum and minimum sizes of the join respectively under referential integrity constraint:- (A) 9 and 0 (B) 9 and 9 (C) 9+100 and 0 (D) 9*100 and 9
Consider the join of a relation R with a relation S. If R has 100 tuples and S has 9 tuples then the maximum and minimum sizes of the join respectively under referential ...
User Avatar
2 votes
1 answer
12
Self Doubt
Let R (ABCD) and S(DEF). D is the foreign key in R that references primary key in S. Which of the following will not violation? a. Insertion in R b. Insertion in S c. Deletion from R d. Deletion from S
Let R (ABCD) and S(DEF). D is the foreign key in R that references primary key in S. Which of the following will not violation?a. Insertion in Rb. Insertion in Sc. Deleti...
User Avatar
1 votes
1 answer
13
Recursive foreign key
Explain recursive foreign key with suitable example..
Explain recursive foreign key with suitable example..
User Avatar
62 votes
6 answers
14
GATE CSE 2017 Set 2 | Question: 19
Consider the following tables $T1$ and $T2.$ ... delete record $\langle 3, 8 \rangle$ from the table $T1,$ the number of additional records that need to be deleted from table $T1$ is _______
Consider the following tables $T1$ and $T2.$$$\overset{T1}{\begin{array}{|c|c|c|} \hline \textbf {P} & \textbf {Q} \\\hline \text {2} & \text{2 }\\\hline \text{3} & \te...
User Avatar
3 votes
2 answers
16
foreign key constraint
What is on delete no action,on delete cascade, on delete set null action?? explain through some eg??
What is on delete no action,on delete cascade, on delete set null action??explain through some eg??
User Avatar
5 votes
2 answers
17
Joining
User Avatar
5 votes
2 answers
19
ISRO2009-72
Purpose of 'Foreign Key' in a table is to ensure Null Integrity Referential Integrity Domain Integrity Null and Domain Integrity
Purpose of 'Foreign Key' in a table is to ensureNull IntegrityReferential IntegrityDomain IntegrityNull and Domain Integrity
User Avatar
0 votes
1 answer
22
FOERIGN KEY
what is the advantage of keeping the Foreign Key null as we know if we make the Foreign Key null we cant reference it again so thats a disadvantage ......so there must be some advantage which outweighs this disadvantage so whats that advantage
what is the advantage of keeping the Foreign Key null as we know if we make the Foreign Key null we cant reference it again so thats a disadvantage ......so there must be...
User Avatar
1 votes
3 answers
23
Relation between Intersection and natural inner join on common column
When , then the cost of computing is (A) the same as R S (B) greater the R S (C) less than R S (D) cannot say anything
When , then the cost of computing is(A) the same as R S (B) greater the R S(C) less than R S (D) cannot say anything
User Avatar
39 votes
3 answers
26
GATE CSE 2005 | Question: 76
The following table has two attributes $A$ and $C$ where $A$ is the primary key and $C$ is the foreign key referencing $A$ ... $(7, 2)$ $(5, 2), (7, 2)$ and $(9, 5)$ $(3, 4), (4, 3)$ and $(6, 4)$
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.$$\begin{array}{|c|c|} \...
User Avatar
To see more, click for the full list of questions or popular tags.