MCQs
Total Questions : 97
| Page 7 of 10 pages
Question 61. An automobile plant contracted to buy shock absorbers from two suppliers X and Y. X supplies 60% and Y supplies 40% of the shock absorbers. All shock absorbers are subjected to a quality test. The ones that pass the quality test are considered reliable. Of X's shock absorbers, 96% are reliable. Of Y's shock absorbers, 72% are reliable. The probability that a randomly chosen shock absorber, which is found to be reliable, is made by Y is
Answer: Option B. -> 0.334
-NA-
Answer: Option C. -> ÆŽx (real(x) á´§ rational(x))
-NA-
Answer: Option C. -> In a row of a relational table, an attribute can have more than one value
-NA-
Answer: Option D. -> T(n) = 2T(n − 1) + 1
-NA-
Question 65. Which of the following statements are TRUE about an SQL query? P : An SQL query can contain a HAVING clause even if it does not have a GROUP BY clause Q: An SQL query can contain a HAVING clause only if it has a GROUP BY clause R : All attributes used in the GROUP BY clause must appear in the SELECT clause S : Not all attributes used in the GROUP BY clause need to appear in the SELECT clause
Answer: Option C. -> Q and R
-NA-
Answer: Option C. -> TCP
-NA-
Answer: Option C. -> 221
-NA-
Answer: Option C. -> 1, 2 and 4
-NA-
Question 69. Fetch_And_Add(X,i) is an atomic Read-Modify-Write instruction that reads the value of memory location X, increments it by the value i, and returns the old value of X. It is used in the pseudo code shown below to implement a busy-wait lock. L is an unsigned integer shared variable initialized to 0. The value of 0 corresponds to lock being available, while any non-zero value corresponds to the lock being not available.AcquireLock(L){while (Fetch_And_Add(L,1))L = 1;}ReleaseLock(L){L = 0;}This implementation
Answer: Option B. -> fails as L can take on a non-zero value when the lock is actually available
-NA-
Answer: Option B. -> 3
-NA-