_____ produces the relation that has attributes of R1 and R2 (A) Cartesian product (B) Difference
(C) Intersection (D) Product

1 Answer

Answer :

A) Cartesian product

Related questions

Description : Let E1 and E2 be two entities in E-R diagram with simple single valued attributes. R1 and R2 are two relationships between E1 and E2 where R1 is one-many and R2 is many-many. R1 and R2 do not have any ... are required to represent this situation in the Relational Model? (A) 4 (B) 3 (C) 2 (D) 1

Last Answer : (B) 3 

Description : Let M and N be two entities in an E-R diagram with simple single vale attributes. R1 and R2 are two relationship between M and N, whereas R1 is one-to-many and R2 is many-to-many. The minimum number of tables required to ... and R2 in the relational model are .......... (1) 4 (2) 6 (3) 7 (4) 3

Last Answer : Answer: 4

Description : The relation schemas R1 and R2 form a Lossless join decomposition of R if and only if: (a) R1⋂R2→(R1-R2) (b) R1→R2 (c) R1⋂R2→(R2-R1) (d) R2→R1⋂R2 (A) (a) and (b) happens (B) (a) and (d) happens (C) (a) and (c) happens (D) (b) and (c) happens

Last Answer : (C) (a) and (c) happens 

Description : Let pk(R) denotes primary key of relation R. A many-to-one relationship that exists between two relations R1 and R2 can be expressed as follows: (1) pk(R2)→pk(R1) (2) pk(R1)→pk(R2) (3) pk(R2)→R1∩R2 (4) pk(R1)→R1∩R2

Last Answer : Answer: 2

Description : Consider the following ER diagram:  The minimum number of tables required to represent M, N, P, R1, R2 is (A) 2 (B) 3 (C) 4 (D) 5

Last Answer : (A) 2 

Description : Which of the following statements is TRUE? D1: The decomposition of the schema R(A,B,C) into R1(A,B) and R2(A,C) is always lossless. D2: The decomposition of the schema R(A,B,C,D,E) having AD→B, C→DE, B→AE, AE→C ... ,D,E) is lossless. (A) Both D1 and D2 (B) Neither D1 and D2 (C) Only D1 (D) Only D2

Last Answer : (D) Only D2

Description : Suppose that R1 and R2 are reflexive relations on a set A. Which of the following statements is correct? (A) R1∩R2 is reflexive and R1UR2 is irreflexive. (B) R1∩R2 is irreflexive and R1UR2 is reflexive. (C) Both R1∩R2 and R1UR2 are reflexive. (D) Both R1∩R2 and R1UR2 are irreflexive.

Last Answer : (C) Both R1∩R2 and R1UR2 are reflexive.

Description : Consider following schedules involving two transactions: S1: r1(X); r1(Y); r2(X); r2(Y); w2(Y); w1(X) S2: r1(X); r2(X); r2(Y); w2(Y); r1(Y); w1(X) Which of the following ... . (3) S1 is not conflict serializable and S2 is conflict serializable. (4) Both S1 and S2 are not conflict serializable.

Last Answer : S1 is not conflict serializable and S2 is conflict serializable.

Description : Consider a schema R(MNPQ) and functional dependencies M→N, P→Q. Then the decomposition of R into R1(MN) and R2(PQ) is ............. (1) Dependency preserving but not lossless ... and lossless join (3) Lossless join but not dependency preserving (4) Neither dependency preserving nor lossless join. 

Last Answer : Answer: 1

Description : For the same draw down in two observations wells at distances r1 and r2, the times after start of  pumping are t1 and t2 hours respectively. The relation which holds good is  (A) t2 = r2/r1 × t1 (B) t2 = (r2/r1)² × t1 (C) t2 = (r2/r1)3  × t1 (D) t2 = (r2/r1) × t1 2

Last Answer : (B) t2 = (r2/r1)² × t1

Description : ………………….. operator is basically a join followed by a project on the attributes of first relation. A) Join B) Semi-Join C) Full Join D) Inner Join

Last Answer : B) Semi-Join

Description : Select operator is not a unary operator. ii) Project operator chooses subset of attributes or columns of a relation. A) i-True, ii-False B) i-True, ii-True C) i-False, ii-True D) i-False, ii-False

Last Answer : C) i-False, ii-True

Description : A .................. normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute. A) First B) Second C) Third D) Fourth

Last Answer : C) Third

Description : The number of attributes in relation is called as its ..................... A) Cardinality B) Degree C) Tuples D) Entity

Last Answer : B) Degree

Description : The number of tuples in a relation is called its …………. While the number of attributes in a relation is called it’s ……………….. A) Degree, Cardinality B) Cardinality, Degree C) Rows, Columns

Last Answer : B) Cardinality, Degree

Description : Select the ‘False’ statement from the following statements about Normal Forms: (A) Lossless preserving decomposition into 3NF is always possible (B) Lossless preserving decomposition into BCNF is always possible (C) Any relation with two attributes is in BCNF (D) BCNF is stronger than 3NF

Last Answer : (B) Lossless preserving decomposition into BCNF is always possible

Description : Cartesian product in relational algebra is (A) a Unary operator. (B) a Binary operator. (C) a Ternary operator. (D) not defined.

Last Answer : (B) a Binary operator.

Description : Let R1 and R2 be the remainders when the polynomials x^3 + 2x^2 – 5ax – 7 and x^2 + ax^2 – 12x + 6 are divided by (x + 1) and (x – 2) respectively. -Maths 9th

Last Answer : answer:

Description : What is the Voltage drop of R1 If V 10 Volts R1 500 Ohms and R2 1500 Ohms?

Last Answer : You need to mention whether the resistors are in series or parallel to get the right answer

Description : What is the total current is V is 10 Volts R1 is 500 Ohms and R2 is 1500 ohms?

Last Answer : We need to find R equivalent at first then divide V from it to find the total current.Case 1: If resistances are connected in series.Then, R(eq.) = R1 + R2 = 500 + 1500 = 2000 ohmSo, Total current, I = V/R(eq.) = ... (500 + 1500) = 400 ohmSo, Total current, I = V/R(eq.) = 10/400 = 1/40 or 0.025 A.

Description : What is the total resistance is V is 10 volts R1 is 1000 ohms and R2 is 1000 Ohms?

Last Answer : If they're connected in series the total resistance is 2000 ohms. If they're connected in parallel the resistance is 500 ohms.

Description : Two planets have the same density of matter, such that their masses are proportional to the cube of their radii. The ratio of their acceleration due to gravity on their surfaces is (a) r2/r1 (b) (r1/r2)2 (c) r1/r2 (d) (r2/r1)2

Last Answer : Ans:(d) Direction: In the following question, a statement of Assertion (A) is given followed by corresponding Reason (R), just below it. Read the statements carefully and mark the correct answer: (a) If both A and ... true but R is not the correct explanation of A. (c) If A is true but R is false

Description : weight of water, the hydraulic mean depth of the sewer and the bed slope w is the unit of the sewer, then the tractive force exerted by flowing water, is A. w r S S B. w r1/2 C. w r S D. w r2/3

Last Answer : ANS: A

Description : What is the total current of the illustrated circuit if the battery is 12 VDC and the resistance of R1 is 2 ohms, R2 is 3 ohms and R3 is 6 ohms? EL-0021 A. 2 amps B. 4 amps C. 6 amps D. 12 amps

Last Answer : Answer: D

Description : In the illustrated circut, if the resistance of R1 is 10 ohms, R2 is 10 ohms, and R3 is 10 ohms. What is the total resistance? EL-0032 A. 15 ohms B. 20 ohms C. 25 ohms D. 30 ohms

Last Answer : Answer: A

Description : The electrical diagram shown in the illustration shows _____________. EL-0021 A. 'R1', 'R2', and 'R3' are connected is series B. 'R1', 'R2', and 'R3' are connected in parallel C. the voltages measured across ... if 'R1', 'R2' and 'R3' have different values D. the total resistance equals R1 + R2 + R3

Last Answer : Answer: B

Description : Which of the following statements is correct for the illustrated circuit? EL-0020 A. 'R1', 'R2', and 'R3' are connected in series. B. 'R1', 'R2', and 'R3' are connected in parallel. C. The voltages measured across 'R1', 'R2', and 'R3' are equal. D. The total resistance equals 1/R1 + 1/R2 + 1/R

Last Answer : Answer: A

Description : As shown in the illustration, if 'R1' and 'R2' have unequal values, the ____________. EL-0019 A. voltage drop across 'R1' will not be equal to the voltage drop across 'R2' B. current flow ... energy dissipated in 'R2' D. current flow through 'R1' will differ from the current flow through 'R2'

Last Answer : Answer: D

Description : If coils 'R1-R2-R3' at the receiver of figure 'B' shown in the illustration turned opposite of those in the transmitter by design, what corrective action should be taken? EL-0092 A. Reverse the 60 Hz supply ... is needed. C. Interchange leads 'R1' and 'R3'. D. Interchange leads 'R2' and 'R3'.

Last Answer : Answer: B

Description : As shown in the illustration if the applied voltage is 12 VDC, the resistance of R1 is 24 kohms, and R2 is 3610 ohms what is the current flowing through R1? EL-0036 A. .434 milliamps B. .005 amp C. 6.00 amps D. 2.4 milliamps

Last Answer : Answer: A

Description : As shown in the illustration if the applied voltage is 12 VDC, the resistance of R1 is 10 ohms, and R2 is 10 ohms what is the total power consumed by R1? EL-0036 A. 3.6 watts B. 72 watts C. 7.2 watts D. 36 watts

Last Answer : Answer: A

Description : As shown in the illustration if the applied voltage is 12 VDC, the resistance of R1 is 10 ohms, and R2 is 10 ohms what is the total power consumed by the circuit? EL-0036 A. 3.6 watts B. 72 watts C. 7.2 watts D. 36 watts

Last Answer : Answer: C

Description : As shown in the illustration if the applied voltage is 12 VDC, the resistance of R1 is 10 ohms, and R2 is 10 ohms what is the current flowing through R1? EL-0036 A. 0.6 amp B. 0.833 amp C. 1.2 amps D. 2.4 amps

Last Answer : Answer: A

Description : In the illustration, 24 volts is applied to the circut where the resistance for R1 is 3 ohms, R2 is 4 ohms, and R3 is 5 ohms. What is the power consumed in R3? EL-0020 A. 12 watts B. 20 watts C. 24 watts D. 48 watts

Last Answer : Answer: B

Description : In the illustration, 24 volts is applied to the circuit where the resistance for R1 is 3 ohms, R2 is 4 ohms, and R3 is 5 ohms. What is the power consumed in R2? EL-0020 A. 16 watts B. 20 watts C. 24 watts D. 28 watts

Last Answer : Answer: A

Description : As shown in the illustration if the applied voltage is 12 VDC, the resistance of R1 is 10 ohms, and R2 is 10 ohms what is the total current in the circuit? EL-0036 A. 0.6 amp B. 0.833 amp C. 1.2 amps D. 2.4 amps

Last Answer : Answer: A

Description : In the illustration, 12 volts is applied to the circuit where the resistance of R1 is 10 ohms and R2 is 10 ohms. what is the voltage across R2? EL-0036 A. 1.2 volts B. 2 volts C. 6 volts D. 12 volts

Last Answer : Answer: C

Description : In the illustration, 24 volts is applied to the circuit where the resistance of R1 is 3 ohms, R2 is 4 ohms, and R3 is 5 ohms. What is the power consumed in R1? EL-0020 A. 2 watts B. 3 watts C. 6 watts D. 12 watts

Last Answer : Answer: D

Description : As shown in the illustration if the applied voltage is 12 VDC, the resistance of R1 is 110 ohms, and R2 is 10 kohms what is the total power consumed by the circuit? EL-0036 A. 3.6 watts B. 72 watts C. .0011286 watts D. .014243 watts

Last Answer : Answer: D

Description : As shown in the illustration if the applied voltage is 12 VDC, the resistance of R1 is 110 ohms, and R2 is 10 kohms what is the voltage measured across R1 EL-0036 A. 11.86 volts B. .131 volts C. 12 volts D. .673 volts

Last Answer : Answer: B

Description : In the illustrated circuit, what is the voltage of the battery if the resistance of R1 is 150 ohms, the total resistance is 250 ohms and the current though R2 is 25 milliamps? EL-0036 A. 12 volts B. 24 volts C. 1.5 volts D. 6.25 volts

Last Answer : Answer: D

Description : In the illustrated circuit, what is the resistance across R2 if the battery voltage is 32 VDC, the resistance of R1 is 1.2 kohms and the current through R2 is 18.82 milliamps? EL-0036 A. 500 ohms B. 1,200 ohms C. 10 ohms D. The answer can not be found with the information given.

Last Answer : Answer: A

Description : In the illustrated circuit, what is the voltage measured across R1 if the battery is 24 volts, the resistance of R1 is 34 ohms, and the resistance of R2 is 126 ohms? EL-0036 A. 24 volts B. 18.9 volts C. 5.1 volts D. 150 millivolts

Last Answer : Answer: C

Description : What is the total resistance of the electrical circuit illustrated if the resistance of R1 is 2 ohms, R2 is 4 ohms, and R3 is 4 ohms with a 6 volt battery? EL-0021 A. 0.01 ohms B. 0.10 ohms C. 1.00 ohms D. 10.00 ohms

Last Answer : Answer: C

Description : The illustrated circuit is a wheatstone bridge. If the meter 'G' reads 0 with the switch closed then ________. EL-0024 A. the current through R1 - R2 is equal to the current through R3 - Rx B. the voltage ... of E C. the resistance of Rx is equal to the resistance of R2 D. all the above are true

Last Answer : Answer: A

Description : If a voltage of 125 VDC is applied to the illustrated circuit where the resistance of R1 is 12 ohms, and R2 is 115 ohms, the current will be_______. EL-0019 A. 11.5 amps B. 12.5 amps C. 115 amps D. 125 amps

Last Answer : Answer: A

Description : In the illustrated circuit, what is the resistance of R2 if the total current is .75 amps, the voltage is 12 VDC and the resistance of R1 is 24 ohms? EL-0019 A. 24 ohms B. 16 ohms C. 48 ohms D. the answer can not be determined from the information given

Last Answer : Answer: C

Description : In the illustrated circuit, what is the total current if the voltage is 12 VDC, the resistance of R1 is 15 ohms, and the resistance of R2 is 10 ohms? EL-0019 A. .8 amps B. 1.5 amps C. .55 amps D. 2 amps

Last Answer : Answer: D

Description : In the illustrated circuit, if the battery is 24 VDC, the resistance of R1 is 24 ohms, and the resistance of R2 is 24 ohms, the total current is _________. EL-0019 A. 2 amps B. 1 amp C. 1/2 amp D. 2.4 amps

Last Answer : Answer: A

Description : What would be the power consumed in the combined parallel section of the circuit shown in the illustration if the source were 30 volts and the resistance for R1 is 10 ohms, R2 is 10 ohms, and R3 is 10 ohms? EL-0032 A. 5 watts B. 10 watts C. 20 watts D. 40 watts

Last Answer : Answer: C