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

1 Answer

Answer :

Answer: 2

Related questions

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 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 : 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 : _____ produces the relation that has attributes of R1 and R2 (A) Cartesian product (B) Difference (C) Intersection (D) Product

Last Answer : A) Cartesian product

Description : Let R and S be two fuzzy relations defined as: Then, the resulting relation, T, which relates elements of universe x to elements of universe z using max-min composition is given by

Last Answer : Answer: C

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 : 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 : 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 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 : 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 : Consider the formula in image processing RD = 1 - (1/CR) Where CR = n1/n2 CR is called as compression ratio n1 and n2 denotes the number of information carrying units in two datasets that represent ... . (A) Data Compression (B) Data Redundancy (C) Data Relation (D) Data Representation

Last Answer : (B) Data Redundancy

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 : A relation R={A,B,C,D,E,F,G} is given with following set of functional dependencies: F={AD→E, BE→F, B→C, AF→G} Which of the following is a candidate key? (A) A (B) AB (C) ABC (D) ABD

Last Answer : Answer: D

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 : 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 : A series circuit consisting of three resistors has a current of 3 amps. If R1 = 20 ohms, R2= 60 ohms, and R 3 = 80 ohms, what is the (a) total resistance and (b) source voltage of the circuit?

Last Answer : (a) 160 ohms. (b) 480 ohms

Description : Since the pK values for aspartic acid are 2.0, 3.9 and 10.0, it follows that the isoelectric (pH) is (A) 3.0 (B) 3.9 (C) 5.9 (D) 6.0

Last Answer : Answer : A

Description : Since the pK values for aspartic acid are 2.0, 3.9 and 10.0, it follows that the isoelectric (pH) is (A) 3.0 (B) 3.9 (C) 5.9 (D) 6.0

Last Answer : (A) 3.0

Description : A set of processors P1, P2, ......, Pk can execute in parallel if Bernstein's conditions are satisfied on a pair wise basis; that is  P1 || P2 || P3 || ..... || Pk if and only if: (A) Pi || Pj for all i ≠ j (B) Pi || Pj for all i = j+1 (C) Pi || Pj for all i ≤ j (D) Pi || Pj for all i ≥ j

Last Answer : (A) Pi || Pj for all i ≠ j Explanation: Bernstein's Condition: 1. If process Pi writes to a memory cell Mi, then no process Pj can read the cell Mi. 2. If process Pi read from a memory ... Mi. 3. If process Pi writes to a memory cell Mi, then no process Pj can write to the cell Mi.

Description : A fuzzy set A on R is ................. iff A(λx1 + (1 – λ)x2) ≥ min [A(x1), A(x2)] for all x1, x2 ∈ R and all λ ∈ [0, 1], where min denotes the minimum operator. (A) Support (B) α-cut (C) Convex (D) Concave 

Last Answer : (C) Convex 

Description : ey to represent relationship between tables is called (A) Primary key (B) Secondary Key (C) Foreign Key (D) None of these

Last Answer : (C) Foreign Key

Description : Which of the following statements is FALSE about weak entity set ? (A) Weak entities can be deleted automatically when their strong entity is deleted. (B) Weak entity set avoids the data ... weak entity set are not partitioned according to their relationship with tuples in a strong entity set.

Last Answer : (D) Tuples in a weak entity set are not partitioned according to their relationship with tuples in a strong entity set.

Description : Which one is correct w.r.t. RDBMS? (1) primary key ⊆ super key ⊆ candidate key (2) primary key ⊆ candidate key ⊆ super key (3) super key ⊆ candidate key ⊆ primary key (4) super key ⊆ primary key ⊆ candidate key

Last Answer : Answer: 2

Description : In the relation ( T/J = Gθ/L = τ/ R), the letter G denotes modulus of ______ a. elasticity b. plasticity c. rigidity d. resilience

Last Answer : c. rigidity

Description : A three dimensional array in C' is declared as int A[x][y][z]. Here, the address of an item at the location A[p][q][r] can be computed as follows (where w is the word length of an integer): (A) &A[0][0][0]+w(y*z*q+z*p+r) (B) &A ... *q+r) (C) &A[0][0][0]+w(x*y*p+z*q+r) (D) &A[0][0][0]+w(x*y*q+z*p+r)

Last Answer : Answer: B

Description : Consider a system with seven processes A through G and six resources R through W. Resource ownership is as follows: process A holds R and wants T process B holds nothing but wants T process C holds nothing but wants S process D holds U ... No (B) Yes, A, B, C (C) Yes, D, E, G (D) Yes, A, B, F

Last Answer : (C) Yes, D, E, G

Description : Let the time taken to switch between user mode and kernel mode of execution be T1 while time taken to switch between two user processes be T2. Which of the following is correct? (A) T1 < T2 (B) T1 > T2 (C) T1 = T2 (D) Nothing can be said about the relation between T1 and T2.

Last Answer : (A) T1 < T2

Description : Let L be the language generated by regular expression 0*10* and accepted by the deterministic finite automata M. Consider the relation RM defined by M. As all states are reachable from the start state, RM has ................ equivalence classes. (A) 2 (B) 4 (C) 5 (D) 6

Last Answer : (D) 6

Description : Consider the relations R(A,B) and S(B,C) and the following four relational algebra queries over R and S: I. πA,B(R⋈S) II. R⋈πB(S) III. R∩(πA(R) Χ πB(S)) IV. πA,R.B(R Χ S) where R.B refers to ... IV are the same query. (C) I, II and IV are the same query. (D) I, III and III are the same query.

Last Answer : (D) I, III and III are the same query.

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 : ………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs. A) Instance B) Schema c) Program D) Super Key

Last Answer : B) Schema

Description : The Relation Vendor Order (V_no, V_ord_no, V_name, Qty_sup, unit_price) is in 2NF because : (A) Non key attribute V_name is dependent on V_no which is part of composite key (B) ... Qty_sup is dependent on primary_key unit price (D) key attribute V_ord_no is dependent on primary_key unit price

Last Answer : (A) Non key attribute V_name is dependent on V_no which is part of composite key

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 : A series circuit consists of two resistors in series. R1 = 25 ohms and R2 = 30 ohms. The circuit current is 6 amps. What is the (a) source voltage, (b) voltage dropped by each resistor, (c) total power, and (d) power used by each resistor?

Last Answer : (a) 330 volts. (b) E1 = 150 volts. E2 = 180 volts. (c) 1.98 kilowatts. (d) P1 = 900 watts. P2 = 1.08 kilowatts component but in a parallel circuit total current divides among the available paths.

Description : Two resistances R1 and R2 give combined resistance of 4.5 ohms when in series and 1 ohm when in parallel. The resistances are

Last Answer : Two resistances R1 and R2 give combined resistance of 4.5 ohms when in series and 1 ohm when in parallel. The resistances are 1.5 ohms and 3 ohms.

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 : 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 : 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