GATE Practice Question and Answer
8Q: The wildcard in a WHERE clause is useful when 3594 05b5cc65ee4d2b4197774be3b
5b5cc65ee4d2b4197774be3b- 1An exact match is not possible in a SELECT statement.true
- 2An exact match is necessary in a CREATE statement.false
- 3An exact match is not possible in a CREATE statement.false
- 4An exact match is necessary in a SELECT statement.false
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 1. "An exact match is not possible in a SELECT statement."
Explanation :
Answer: A) An exact match is not possible in a SELECT statement. Explanation:
Q: A batsman in his 17th innings makes a score of 85 and their by increasing his average by 3. What is his average after the 17th innings ? 3591 05b5cc6e9e4d2b4197774ee01
5b5cc6e9e4d2b4197774ee01- 134false
- 236false
- 335false
- 437true
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 4. "37"
Explanation :
Answer: D) 37 Explanation: 16x + 85 = 17(x + 3) x = 34 + 3 = 37
Q: 8 couples (husband and wife) attend a dance show "Nach Baliye' in a popular TV channel ; A lucky draw in which 4 persons picked up for a prize is held, then the probability that there is atleast one couple will be selected is : 3581 05b5cc7d0e4d2b41977751218
5b5cc7d0e4d2b41977751218- 18/39false
- 215/39true
- 312/13false
- 4None of thesefalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 2. "15/39"
Explanation :
Answer: B) 15/39 Explanation: P( selecting atleast one couple) = 1 - P(selecting none of the couples for the prize) = 1-16C1× 14C1×12C1×10C116C4=1539
Q: Re-arrange the following sentences into a meaningful paragraph. ( 3579 05b5cc6cde4d2b4197774e1f9
5b5cc6cde4d2b4197774e1f9- 1comes into effect from today. The bank's savings account rate was 3.5 per cent during March 2003 to May 2011 for all savings bank account customers (false
- 2The bank's decision comes two days ahead of RBI's monetary policy meet and is likely to trigger (false
- 3with deposits of above Rs 1 crore, it said in a statement. The two-tier savings bank account interest rate (false
- 4to 3.5 per cent, lowest in six years, a decision that will impact 90 per cent of its customers (E) The country's largest lender however will continue to pay 4 per cent interest on savings bank accounts (F) SBI today cut interest rate on savings bank account deposits up to Rs 1 crore by 0.5 per cent (G) rate war among peers. SBI's savings bank account base is of around Rs 9 lakh crore.true
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 4. "to 3.5 per cent, lowest in six years, a decision that will impact 90 per cent of its customers
(E) The country's largest lender however will continue to pay 4 per cent interest on savings bank accounts
(F) SBI today cut interest rate on savings bank account deposits up to Rs 1 crore by 0.5 per cent
(G) rate war among peers. SBI's savings bank account base is of around Rs 9 lakh crore."
Explanation :
Answer: D) FDBGECA Explanation:
Q: Happiness is to 517768399 as senipah is to 3577 05b5cc64de4d2b4197774bc57
5b5cc64de4d2b4197774bc57- 19836715false
- 29386615false
- 39386715true
- 49386517false
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 3. "9386715"
Explanation :
Answer: C) 9386715 Explanation: If each consecutive letter in "happiness" relates to the consecutive numbers in 517768399, then H=5, A=1, P=7, I=6, N=8, E=3 and S=9. Using the numbers that relate to the letters in 'senipah', you will arrive at SENIPAH = 9386715. Hence, Happiness is to 517768399 as senipah is to 9386715.
Q: What is the value of P in the following Equation ? 192.5 × 19p = 197 3575 15b5cc6bee4d2b4197774d9a6
5b5cc6bee4d2b4197774d9a6- 13.9false
- 24.1false
- 33.7false
- 44.5true
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 4. "4.5"
Explanation :
Answer: D) 4.5 Explanation: Given equation is 192.5 ×19p = 197 Here it is in the form of am × an = am+n Here m = 2.5 , n = p, m+n = 7 => 2.5 + p = 7 => p = 7 - 2.5 => p = 4.5
Q: Rajitha has a calculator, which has 10 digits. She want to clean the calculator by removing all the keys and while reassembling it, she interchanged the locations of 3 pairs of keys. For example, if she placed the key ‘3’ in the place of the key ‘7’, she placed the key ‘7’ only in the place of the key ‘3’ and not any other key. All keys that were interchanged corresponded only to numbers. Later, she input some calculations and obtained outputs as provided in the table below. The input is shown in terms of the keys that Kavitapressed, while the output is the output displayed by the calculator. Output: 1. 95 + 84=1282. 128 + 64=1953. 912 + 43=9424. 178 + 19=192 Question : Which of the following pair of digits is unchanged ? 3562 05b5cc6d2e4d2b4197774e467
5b5cc6d2e4d2b4197774e467- 19, 0, 3false
- 21, 3, 8false
- 37, 0, 1true
- 42, 4, 1false
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 3. "7, 0, 1"
Explanation :
Answer: C) 7, 0, 1 Explanation: 0 1 2 3 4 5 6 7 8 9 0 1 4 8 2 6 5 7 3 9 Here pairs interchanged are 2, 4 3, 8 5, 6 Unchanged are 0, 1, 7, 9
Q: A merchant buys two articles for Rs.600. He sells one of them at a profit of 22% and the other at a loss of 8% and makes no profit or loss in the end. What is the selling price of the article that he sold at a loss ? 3561 05b5cc71be4d2b4197774f4fe
5b5cc71be4d2b4197774f4fe- 1Rs. 404.80true
- 2Rs. 536.80false
- 3Rs.440false
- 4Rs. 160false
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 1. "Rs. 404.80"
Explanation :
Answer: A) Rs. 404.80 Explanation: Let C1 be the cost price of the first article and C2 be the cost price of the second article.Let the first article be sold at a profit of 22%, while the second one be sold at a loss of 8%. We know, C1 + C2 = 600.The first article was sold at a profit of 22%. Therefore, the selling price of the first article = C1 + (22/100)C1 = 1.22C1The second article was sold at a loss of 8%. Therefore, the selling price of the second article = C2 - (8/100)C2 = 0.92C2. The total selling price of the first and second article = 1.22C1 + 0.92C2. As the merchant did not make any profit or loss in the entire transaction, his combined selling price of article 1 and 2 is the same as the cost price of article 1 and 2. Therefore, 1.22C1 + 0.92C2 = C1+C2 = 600As C1 + C2 = 600, C2 = 600 - C1. Substituting this in 1.22C1 + 0.92C2 = 600, we get1.22C1 + 0.92(600 - C1) = 600or 1.22C1 - 0.92C1 = 600 - 0.92*600or 0.3C1 = 0.08*600 = 48or C1 = 48/(0.3) = 160.If C1 = 160, then C2 = 600 - 160 = 440.The item that is sold at loss is article 2. The selling price of article 2 = 0.92*C2 = 0.92*440 = 404.80.