Register
Filter

Questions by dhairya

0 votes
0 answers
1
GATE CS-2008
(P + Q’) (PQ’ + PR) (P'Q’+PR) (P’R’ + Q’) simplifies to (A) PQ’ (B) PQ’+ R (C) PR’ (D) PR’ + Q
(P + Q’) (PQ’ + PR) (P'Q’+PR) (P’R’ + Q’) simplifies to(A) PQ’(B) PQ’+ R(C) PR’(D) PR’ + Q
1 votes
1 answer
2
GATE EC-2006
A probability density function density function is of form P(x)= k e ^(-a |x|) , the value of k is A)0.5 B)1 C) 0.5 a D) a
A probability density function density function is of form P(x)= k e ^(-a |x|) , the value of k isA)0.5B)1C) 0.5 aD) a
1 votes
1 answer
4
Which phase of compiler will give error ?
a = b + " cde " ; Which phase of compiler will give error ?
a = b + " cde " ;Which phase of compiler will give error ?
2 votes
1 answer
5
First and follow
S-> AB / Ɛ A-> AC / 0C B->0S C->1 What is the first (A)..??
S- AB / ƐA- AC / 0CB->0SC->1What is the first (A)..??
2 votes
1 answer
6
First and follow
Find first and follow... S→ABa / bCA A→cBCD / є B→CdA / ad C→eC / є D→bsf / a
Find first and follow...S→ABa / bCAA→cBCD / єB→CdA / adC→eC / єD→bsf / a
1 votes
1 answer
7
Database
Consider 3 relation R(A, B, C) WITH 20 TUPLES and S(A,D , E) With 30 tuples and T(D,F,G ) with 40 tuples. What is the max no. of tuples in natural joint of R S T Plz explain
Consider 3 relation R(A, B, C) WITH 20 TUPLES and S(A,D , E) With 30 tuples and T(D,F,G ) with 40 tuples.What is the max no. of tuples in natural joint of R S TPlz exp...
0 votes
0 answers
10
ER Diagram
Consider the following ER diagram: If A has 100 entities, B has 1000 entities, and C has 10 entities, what is the maximum number of triples of entities that could be in the relationship set for R?
Consider the following ER diagram: If A has 100 entities, B has 1000 entities, and C has 10 entities, what is the maximum number of triples of entities that could be in ...
0 votes
2 answers
11
3NF
Consider the following F.D. ab -> cd ; e->c ; b->ef Which options show the relations normalized to 3NF of R(A,B,C,D,E,F) 1) R(A,B,C,D) , R(C,E) , R(E,F,B) 2) R(A,B,D) , R(E,C) , R(B,E,F) 3) R(A,B,C,D) , R(C,E) , R(B,E,F) 4) R(A,B,C,D,E,F) , R(E,C) , R(B,E,F) Ans is C
Consider the following F.D.ab - cd ; e->c ; b->efWhich options show the relations normalized to 3NF of R(A,B,C,D,E,F)1) R(A,B,C,D) , R(C,E) , R(E,F,B)2) R(A,B,D) , R(E...
0 votes
0 answers
12
BCNF
R(A,B,C,D) is a relation. Which of the following does not have a lossless join, dependency preserving BCNF decomposition? a)A->B, B->CD b)A->B, B->C, C->D c) AB->C, C->AD d)A ->BCD Plz explain as well...!!!!
R(A,B,C,D) is a relation. Which of the following does not have a lossless join, dependency preserving BCNF decomposition? a)A->B, B->CDb)A->B, B->C, C->Dc) AB->C, C->ADd)...
0 votes
2 answers
13
super key / candidate key
R (A, B, C ,D ,E ) F={ A->B, BC-> D, D->BC, B->E, B->A } Check whether BD is C.Key or S.key . Also find the candidate key.
R (A, B, C ,D ,E )F={ A->B, BC- D, D->BC, B->E, B->A }Check whether BD is C.Key or S.key . Also find the candidate key.
0 votes
3 answers
14
super key
R ( A, B, C, D) A & B are the candidate keys . what are the possible Super keys and there no ..??
R ( A, B, C, D)A & B are the candidate keys .what are the possible Super keys and there no ..??
0 votes
3 answers
15
Super key
R (A, B, C) Functional dependency= { A -> B, B -> C , C -> A } No of super keys are...??
R (A, B, C)Functional dependency= { A - B, B - C , C - A }No of super keys are...??
2 votes
5 answers
16
candidate key
Q1) R(A1,A2,A3,..................An) having A1A2 as its candidate key. Find the no of super key..? Q2) R(A1,A2,A3,..................An) having A1 and A2 as its candidate key. Find the no of super key..?
Q1) R(A1,A2,A3,..................An) having A1A2 as its candidate key. Find the no of super key..?Q2) R(A1,A2,A3,..................An) having A1 and A2 as its candid...
0 votes
1 answer
17
Find the cardinality..
Find the cardinality of --- 1) $\phi$ 2) { $\phi$} 3) { $\phi$ , { $\phi$} } 4) { $\phi$, { $\phi$} , { $\phi$, { $\phi$ } } }
Find the cardinality of -1) $\phi$2) { $\phi$}3) { $\phi$ , { $\phi$} }4) { $\phi$, { $\phi$} , { $\phi$, { $\phi$ } } }
1 votes
1 answer
18
equality of sets
For 2 sets to be equal..is it necessary to have same no of elements as well..? ex- A={1,2,3} B={1,1,3,3,2}.. Are they equal.?
For 2 sets to be equal..is it necessary to have same no of elements as well..? ex- A={1,2,3} B={1,1,3,3,2}.. Are they equal.?
0 votes
1 answer
19
tuple relation
consider the relation r1(P,Q,R) and r2(R,S,T) with primary key P and R respectively. r1 contain 2000 tuples and r2 2500 tuples. max size of natural joint of r1 and r2..? plz explain..
consider the relation r1(P,Q,R) and r2(R,S,T) with primary key P and R respectively. r1 contain 2000 tuples and r2 2500 tuples. max size of natural joint of r1 and r2..? ...
0 votes
1 answer
20
for composite attribute we require an extra table..?
Page: