ఐబిపిఎస్ ఆర్ఆర్ బి సిడబ్ల్యూఇ మోడల్ పేపర్
100. The options like Relationship, SQL Server etc. are found in ___
1) External data tab
2) Database tools tab 3) Create tab
4) Home tab 5) Format tab
101. A Database Language Concerned with the Definition of the Whole Da-tabase Structure and Schema is ____
1) DCL 2) DML 3) DDL
4) DCO 5) DDI
102. A ____ Enables You To View Data From A Table Based On A Specific Criterion
1) Form 2) Query 3) Macro
4) Report 5) Bug
103. A ____ normal form normalization will be needed where all attributes in relation tuple are not functi-onally dependent only on the key attribute.
1) First 2) Second 3) Third
4) Fourth 5) Fifth
104. An outstanding functionality of SQL is its support for automatic ____ to the target data.
1) programming 2) functioning
3) navigation 4) notification
5) none of these
105. The hardware component used to control the operation of a computer system is:
1) Ram 2) Processor
3) Keyboard 4) Hard disk
5) Monitor
106. Which output device is suited to presenting information that is likely to change very frequently?
1) Sound card 2) Monitor
3) Plotter 4) Printer 5) COM
107. Which is the most difficult environmentally to dispose of?
1) Floppy drives 2) Hard drives
3) Power supplies 4) CRTs
5) System boards
108. Which type of system hoard is the MOST likely candidate for proce-ssor upgrading if you want maxi-mum performance and future com-patibility?
1) ML 2) PCI 3) ISA
4) EISA 5) ISO
109. Which of the following is a type of preventative maintenance used on a hard drive?
1) Disk check diagnostics
2) Head alignment diagnostics
3) Initializing
4) Uninstalling programs
5) None of the above
110. How many IRQs does a chain of USB devices require?
1) 1 2) 2 3) 3 4) 4 5) 5
111. Which of the following addressing modes, facilitates access to an operand whose location is defined relative to the beginning of the data structure in which it appears?
1) ascending 2) sorting
3) index 4) indirect 5) direct
112. Which command will be used with vi editor to replace text from cursor to right?
1) r 2) R 3) s 4) S 5) Q
113. Which of the following is not a filter?
1) cat 2) grep 3) wc 4) sort
5) None of the above
114. Which of the following commands is used to view your file 24 lines at a time?
1) pg 2) cat 3) //p 4) /p 5) ///p
115. The rise time of a pulse waveform is the time required for the voltage to rise:
1) from zero to its rms value
2) from zero to its peak value
3) from 10% of the peak value to 70.7% of the peak value
4) from 10% of the peak value to 90% of the peak value
5) from 10% of the peak value to 80% of the peak value
116. Holes are the minority carriers in which type of semiconductor?
1) Extrinsic 2) Intrinsic
3) n-type 4) p-type 5) m-type
117. While working with MS-DOS, which command is used to restore files that were backed up using the BACKUP command?
1) COPY 2) DISKCOPY
3) RESTORE 4) STORE
5) DELETE
118. Which of the following commands will take you directly to the root directory no matter what subdirectory you are currently in?
1) CD \root 2) CD\ 3) CD\..
4) CD.. 5) CD\\..
119. Batch files contain a group of MS-DOS commands that are run in successive order. What filename extension identifies batch files?
1) COM 2) BAT 3) EXE
4) SYS 5) DOC
120. The _____ command allows you to modify the default prompt to provide other information
1) prompt 2) windows
3) cursor 4) click 5) double click
Quantitative Aptitude and Data Interpretation
121. {522 + 452} ÷ ? = 8
1) 611.345 2) 487.225
3) 591.125 4) 372.425
5) None of these
122. 72% of 752.6 = 48% of ?
1) 1128.9 2) 1332.7
3) 1536.5 4) 1742.3
5) None of these
123. ?% of 658 + 40% of 845 = 568.3
1) 46 2) 42 3) 38
4) 35 5) None of these
124. (15.5% of 1245) –
(12.5 % of 1458) = ?
1) 10.725 2) 10.735
3) 10.745 4) 10.755
5) None of these
125. 644 ÷ 85 = ?
1) 812 2) 88 3) 84 4) 82 5) None of these
126. 99.752 – 2250.0625 = ?
1) 9900.625 2) 7700 3) 6545.625
4) 8875 5) None of these
127. 12.252 –= ?
1) 235.1625 2) 125.0625
3) 375.2625 4) 465.3625
5) None of these
128. 383 ´ 38 ´ 3.8 = ?
1) 58305.8 2) 57305.6
3) 56305.4 4) 55305.2
5) None of these
129. 43.231 – 12.779 – 6.542
– 0.669 = ?
1) 27.341 2) 25.242
3) 23.241 4) 21.342
5) None of these
130. 572 + 38 ´ 0.50 – 16 = ?
1) 289 2) 305 3) 448
4) 565 5) None of these
Directions (Q.131-135): Study the table carefully to answer the questions that follow.
The number of persons visiting six diff-erent Super markets and the per-centage of Men, Women and Children visiting those Super markets
131. The number of men visiting Super market D forms approximately what percent of the total number of persons visiting all the Super markets together?
1) 11 2) 5.5 3) 13
4) 9 5) 7.5
132. The number of children visiting Super market C forms what per cent of the number of children visiting Super market F? (Rounded off to two digit after decimal)
1) 91.49 2) 49.85
3) 121.71 4) 109.30
5) None of these
133. What is the total number of children visiting Super markets B and D together?
1) 18515 2) 28479
3) 31495 4) 22308
5) None of these
134. What is the average of women visiting all the Super markets together?
1) 24823.5 2) 22388.5
3) 26432.5 4) 20988.5
5) None of these
135. What is the ratio of the number of women visiting Super market A to that of those visiting Super market C?
1) 35 : 37 2) 245 : 316
3) 352 : 377 4) 1041 : 1156
5) None of these
136. The sum of two numbers is 528 and their HCF is 33. How many such pairs of numbers are possible?
1) 2 2) 3 3) 4
4) 5 5) None of these
137. Two numbers are there in the ratio 2 : 3. After subtracting 4 from both the numbers its ratio will become 5 : 8. Then find initial numbers?
1) 20, 30 2) 24, 36
3) 30, 45 4) None of these
138. In an election between two candidates, 75 % of the voters cast their votes, out of which 2% of the votes were declared invalid. A candidate got 9261 votes which were 75% of the total valid votes. Find the total number of votes.
1) 16800 2) 15800
3) 16700 4) 15700
5) None of these
139. If the price of petrol is increased by 30%, by how much percent a car owner must reduce his consumption in order to maintain the same budget?
1) 21% 2)
3) 4) 33%
5) None of these
140. The selling price of 8 articles is equal to cost price of 10 articles. Find profit or loss percentage?
1) 10% 2) 20% 3) 25% 4) 32% 5) None of these
141. Rs. 700 is divided among A, B, C so that A receives half as much as B and B half as much as C. Then C's share is ___
1) Rs. 200 2) Rs. 400
3) Rs. 300 4) Rs. 600
5) None of these
142. A tourist bus covers a distance of 522 km at the speed of 58 km/hr in 11 hours. If the bus halted at a tourist spot in the middle of the journey, for how much time did it halt?
1) 30 min 2) 1 hour
3) 1 hr 30 min 4) 2 hours
5) None of these
143. X, Y and Z can do a piece of work in 48, 60 and 80 days viz., They began the work together but Z left 8 days before the completion of work. The work was done in ____ days
1) 10 2) 12 3) 13
4) 14 5) 22
144. A person borrows Rs.5000 for 2 years at 4% p.a. at simple interest. He immediately lends it to another person at 6 % p.a. for 2 years. Then his gain in the transaction per year is
1) Rs. 225 2) Rs. 125
3) Rs 112.50 4) Rs.167.50
5) None of these
145. Three cubes of edge 3 cm 4 cm and 5 cm are melted to form a single cube. Find the surface area of new cube.
1) 216 cm2 2) 64 cm2
3) 125 cm2 4) 512 cm2 5) None
Directions (Q 146 - 150): Study the given graph carefully to answer the questions that follow.
Number of people (in thousands) using three different types of mobile services over the years.
146. What is the average number of people using mobile service M for all the years together?
1) 2)
3) 4)
5) None of these
147. The total number of people using all the three mobile services in the year 2007 is what percent of the total number of people using all the three mobile services in the year 2008? (Rounded off to two digits after decimal)
1) 80.72 2) 93.46
3) 88.18 4) 91.67
5) None of these
148. The number of people using mob-ile service N in the year 2006 forms approximately what percent of the total number of people using all the three mobile services in that year?
1) 18 2) 26 3) 11
4) 23 5) 29
149. What is the ratio of the number of people using mobile service L in the year 2005 to that of those using the same service in the year 2004?
1) 8 : 7 2) 3 : 2 3) 19 : 13
4) 15 :11 5) None of these
150. What is the total number of people using mobile service M in the years 2008 and 2009 together?
1) 35,000 2) 30,000
3) 45,000 4) 25,000 5) None
Directions (Q 151-155): Study the following graph carefully to answer these questions.
Profit earned by seven companies during 2003 and 2004 (in Rs crore)
(Profit = Income - Expenditure)
151. What is the ratio between the profit earned by Company A in 2004 and Company B in 2003?
1) 4 : 3 2) 3 : 2 3) 3 : 4
4) 2 : 3 5) None of these
152. What is difference between total profit earned by Company E, F and G together in 2003 and 2004 (in Rs Crore)?
1)70 2) 75 3) 78
4) 82 5) None of these
153. What is the ratio between the profit earned by Company C in 2003 and 2004 together and the profit earned by Company E in the same two years mentioned above?
1) 11 : 9 2) 9 : 10 3) 10 : 11
4) 11 : 10 5) None of these
154. What is the average profit earned by all the companies in the years 2003 (in Rs Crore, correct up to two digits after decimal point)?
1) 52.75 2) 53.86 3) 52.86
4) 53.55 5) None of these
155. Profit earned by the Company B in 2004 is what percent of the profit earned by the same Company in 2003?
1) 133.33 2) 75 3) 67.66
4) 75.25 5) None of these
Directions (156 to 160): Study the following Pie-chart and answer the questions given below:
Total number of Passengers in six different trains = 4800
Percentage wise distribution of passengers
156. What was the average number of passengers travelling in Train-A, Train-C and Train-F together?
1) 816 2) 826 3) 824
4) 812 5) None of these
157. If cost of one ticket is Rs. 124. What is the total amount paid by passengers of Train-B? (Assuming all the passengers purchased ticket and cost of each ticket is equal)
1) Rs. 53,658 2) Rs. 53,568
3) Rs. 53,558 4) Rs. 53,468 5) None of these
158. Number of passenger in Train-E is approximately what percentage of the total number passengers in Train-B and Train-D together?
1) 64 2) 69 3) 75
4) 54 5) 79
159. What is the difference between the number of passengers in Train-C and number of passenger in Train-A?
1) 280 2) 250 3) 230
4) 260 5) None of these
160. What is the total number of passengers in Train-D, Train-E and Train-F together?
1) 2796 2) 3225 3) 2976
4) 3125 5) None of these
ENGLISH LANGUAGE
Directions (Q. 161-170): Read the following passage carefully and answer the questions given below it. Certain words have been printed in bold to help you locate them while answering some of the questions.
The right to information act (RTI) had been passed by both the Houses of Parliament and given assent to by the president on June 15, 2005. It had come into force on 13 October 2005 and India had joined the group of 55 countries to have such legislation.
The RTI Act entitles citizens to seek information controlled by public authorities. Thus it obligates every public auth-ority to provide information. The objective is to provide a high degree of transparency and accountability in the working of public authorities and by implication to curb, if not eliminate corruption and inefficiency in these organizations, and the Act has helped citizens to obtain official documents and to have access to government records without paying bribe or using undue influence.
The seeds were sown in as early as 1975 in a case "state of UP V Raj Narain". The Supreme Court had said that the people had a right to know every public act. In 1992 and 1995 the court reiterated the right to know as implicit in the right to speech and expression guaranteed under Article 19(1) (a).
The movement -RTI- grew from the grassroots in Rajasthan, The National Campaign for people's Right to Inform-ation (NCRI) and the Press Council of India sent in 1996 a draft of RTI law to the Government of India. In the meantime, the campaign for RTI by NCPRI continued and spread through the country, nine states passed RTI laws. Though the Government of India introduced the freedom of information bill in Parliament in 2002 and got the presidential assent in 2003, no commencement was ever notified and was thus a non-starter, so the campaign continued to press for an effective RTI.
These efforts found support in the common minimum programme of the United Progressive Alliance (UPA) which promised to make the FOI more "progressive, participatory and meaningful". The National Advisory Council, set up by the Congress party and of which Aruna Roy and Jean Dreze were members, discussed the issue and submitted to the prime minister's office a set of recommendations for amending the FOI act after considering the suggestions from CHRI, the NCPRI and other civil society groups. An RTI Bill was introduced by the government of India in Parliament on 22 December 2004, it became the RTI Act, 2005.
161. The passage is essentially about __.
1) the RTI act
2) the debate on file noting
3) pressure on the government
4) public involvement in making laws
5) UPA government
162. The best inference from the passage is ___
1) very few countries in the world have RTI laws.
2) Citizens can now ask for information they want.
3) the government will function far better.
4) power lies with the act
5) power ultimately rests with the people.
163. Who set the ball rolling for the RTI act?
1) Governor 2) President
3) Supreme court
4) National advisory council
5) RTI
164. ___ was just a paper tiger.
1) FOI bill 2) The supreme court
3) The UPA government
4) Governor 5) President
165. The RTI act was possible because of ___
1) UPA government, CMP, NCPRI, the supreme Court, NAC
2) CMP, NAC, UPA, the supreme court, NCPRI, activists
3) The supreme court, NCPRI, activists, NAC, UPA government
4) Aruna Roy, Anna Hazare, Sonia Gandhi, Dr Manmohan Singh
5) Aruna Roy, Jean Dreze
Directions (Q. 166-168): Choose the word which is MOST SIMILAR in meaning to the word printed in bold as used in the passage.
166. TRANSPARENCY
1) Unclear 2) Precision
3) Ambiguity 4) Haziness
5) Muddle
167. REITERATE
1) Repeat 2) Refresh
3) Refurbish 4) Resurrect
5) Replenish
168. OBLIGATE
1) Compel 2) Constitute
3) Conspire 4) Conquer
5) Conjure
Directions (Q. 169-170): Choose the word which is MOST OPPOSITE in meaning to the word printed in bold as used in the passage.
169. ASSENT
1) Consent 2) Accept
3) Except 4) Excuse
5) Disagree
170. PROGRESSIVE
1) Dynamic 2) Avant-garde
3) Modern 4) Radical
5) Intermittent
Directions (Q. 171-175): Each question below has two blanks, each blank indicating that something has been omitted. Choose the set of words from the five options for each blank that best fits the meaning of the sentence as a whole.
171. According to Stress Management, ___ is a physiological response to an internal or ___ stimulus that triggers the fight-or flight reaction.
1) pressure, inward
2) strain, terminal
3) thrust, exterior
4) stress, external
5) steep, external
172. Nobel prize is to be awarded to a person for ___ contribution, and the nationality of the candidates being considered should not be a ___ factor for awarding the prize.
1) exceptional, restraining
2) extraordinary, refrain
3) except, restore
4) accept, reinstate
5) extracurricular, resuming
173. ____ politicians are always respected.
1) Conscious 2) Conscientious
3) Cautious 4) Carefree
5) Clumsy
174. As a teacher of English literature he would draw from the literary critical ___ of the West employing them in the most ____ way.
1) tradition, critics
2) traditional, criticism
3) traditions, critical
4) trade, cryptic
5) traditionally, critical
175. We were watching a movie on television when the light ___ off.
1) came 2) put 3) went
4) took 5) gave