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
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 : 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 : 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 : _____ 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 : 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 : 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 : 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 : Given a Non-deterministic Finite Automation (NFA) with states p and r as initial and final states respectively transition table as given below The minimum number of states required in Deterministic Finite Automation (DFA) equivalent to NFA is (A) 5 (B) 4 (C) 3 (D) 2
Last Answer : (C) 3
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 : 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 : In RSA public key cryptosystem suppose n=p*q where p and q are primes. (e,n) and (d,n) are public and private keys respectively. Let M be an integer such that 0
Last Answer : (2) I and III
Description : Consider a source computer(S) transmitting a file of size 106 bits to a destination computer (D)over a network of two routers (R1 and R2) and three links(L1, L2, and L3). L1connects S to R1; L2 connects R1 to ... file from S to D? a. 1005 ms b. 1010 ms c. 3000 ms d. 3003 ms Answer: Option(a)
Last Answer : a. 1005 ms
Description : An ER Model includes I. An ER diagram portraying entity types. II. Attributes for each entity type III. Relationships among entity types. IV. Semantic integrity constraints that reflects the business rules about data not ... ; IV (B) I&IV (C) I, II & IV (D) I & III
Last Answer : (A) I, II, III & IV
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 : Consider the following Entity-Relationship (E-R) diagram and three possible relationship sets (I, II and III) for this E-R diagram: If different symbols stand for different values (e.g., t1 is definitely not equal to t2 ... diagram ? (A) I only (B) I and II only (C) II only (D) I, II and III
Last Answer : (A) I only
Description : Consider the fractional knapsack instance n = 4, (p1, p2, p3, p4) = (10, 10, 12, 18), (w1, w2, w3, w4) = (2, 4, 6, 9) and M = 15. The maximum profit is given by (Assume p and w denotes profit and weight of objects respectively) (A) 40 (B) 38 (C) 32 (D) 30
Last Answer : (B) 38
Description : Images tend to be very large collection of data. The size of memory required for a 1024 by 1024 image in which the colour of each pixel is represented by a n-bit number, (in an 8 bit machines) is (A) n × 8 MB (B) n / 8 MB (C) (1024 × 1024) / 8 MB (D) 1024 MB
Last Answer : (B) n / 8 MB
Description : The number of distinct binary images which can be generated from a given binary image of right M × N are (A) M + N (B) M × N (C) 2M + N (D) 2MN
Last Answer : (D) 2MN
Description : A t-error correcting q-nary linear code must satisfy: Where M is the number of code words and X is (1) qn (2) qt (3) q-n (4) q-t
Last Answer : (1) qn
Description : Consider the following ORACLE relations: R(A,B,C) = {, , , , ,< 3,1,4>} S(B,C,D) = {, , , , } Consider the following two SQL queries SQ1 and SQ2: SQ1: SELECT R.B, AVG(S.B) FROM R, S WHERE R.A = S.C AND S.D ... tuples returned by SQ2 then (A) M=4, N=2 (B) M=5, N=3 (C) M=2, N=2 (D) M=3, N=3
Last Answer : (A) M=4, N=2
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
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 : 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 : 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
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 : 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
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
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
Description : What power would be consumed by the series resistor of the circuit shown in the illustration if the source is 30 volts, the resistance of 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
Description : What power would be consumed in EACH of the branch resistors of the circuit shown in the illustration if the source is 30 volts, 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
Description : What is the current through R2 of the circuit illustrated if the resistances of R1 is 2 ohms, R2 is 4 ohms, and R3 is 4 ohms with a 6 volt battery? EL-0021 A. 0.5 amp B. 1.5 amps C. 3.0 amps D. 6 amps
Description : What would be the voltage drop across the series resistor of the circuit shown in the illustration if the source is 30 volts, the resistance of R1 is 10 ohms, R2 is 10 ohms and R3 is 10 ohms? EL-0032 A. 5 volts B. 10 volts C. 20 volts D. 30 volts
Description : What is the voltage across 'R3' of the illustrated circuit if the supply is 24 volts and the resistance of R1 is 3 ohms, R2 is 4 ohms, and R3 is 5 ohms? EL-0020 A. 2 volts B. 6 volts C. 8 volts D. 10 volts
Description : What would be the voltage drop across the parallel branches of the circuit shown in the illustration if the source is 30 volts the resistance for R1 is 10 ohms, R2 is 10 ohms and R3 is 10 ohms? EL-0032 A. 5 volts B. 10 volts C. 20 volts D. 30 volts
Description : What would be the total current flowing in the circuit shown in the illustration if the source is 30 volts, the resistance of R1 is 10 ohms, R2 is 10 ohms and R3 is 10 ohms? EL-0032 A. 1 amp B. 2 amps C. 5 amps D. 15 amps
Description : What is the voltage across 'R2' of the illustrated circuit if the supply is 24 volts and the resistance of R1 is 3 ohms, R2 is 4 ohms, and R3 is 5 ohms? EL-0020 A. 2 volts B. 6 volts C. 8 volts D. 10 volts
Description : What is the current flowing through R1 of the illustrated circuit with a 6 VDC battery if the resistance of R1 is 2 ohms, R2 is 4 ohms and R3 is 4 ohms? EL-0021 A. 0.5 amps B. 1.5 amps C. 3.0 amps D. 6 amps
Description : What is the power consumed by 'R3' in the circuit illustrated if the supply is 24 volts and resistance of R1 is 3 ohms, R2 is 4 ohms, and R3 is 5 ohms? EL-0020 A. 12 watts B. 20 watts C. 24 watts D. 48 watts
Description : What is the voltage across 'R1' of the illustrated circuit if the supply is 24 volts and resistance of R1 is 3 ohms, R2 is 4 ohms, and R3 is 5 ohms? EL-0020 A. 2 volts B. 6 volts C. 8 volts D. 10 volts
Description : How much current will flow in the illustrated circuit if the supply is 24 volts and the resistances of R1 is 3 ohms, R2 is 4 ohms, and R3 is 5 ohms? EL-0020 A. 2 amps B. 6 amps C. 8 amps D. 10 amps
Description : What is the power consumed by 'R2' in the circuit illustrated, if the supply is 24 volts and the resistance of R1 is 3 ohms, R2 is 4 ohms, and R3 is 5 ohms? EL-0020 A. 16 watts B. 20 watts C. 24 watts D. 28 watts
Description : What is the power consumed by 'R1' in the circuit illustrated if the supply is 24 volts and the resistance of R1 is 3 ohms, R2 is 4 ohms, and R3 is 5 ohms? EL-0020 A. 2 watts B. 3 watts C. 6 watts D. 12 watts
Description : What is the total power consumed by the illustrated circuit if the supply is 24 volts and the resistances of R1 is 3 ohms, R2 is 4 ohms, and R3 is 5 ohms? EL-0020 A. 2 watts B. 12 watts C. 48 watts D. 288 watts
Description : In a circuit such as that shown in figure 3-15, if R1 has a value of 100 ohms and R2 has a value of 1 kilohm and the input signal is at a value of + 5 millivolts, what is the value of the output signal?
Last Answer : 50 millivolts.
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 : Consider the following conditions : (a) The solution must be feasible, i.e. it must satisfy all the supply and demand constraints. (b) The number of positive allocations must be equal to m+n-1, where m is the number of rows and n is ... B) (a) and (c) only (C) (b) and (c) only (D) (a), (b) and (c)
Last Answer : (D) (a), (b) and (c)
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