Institute of Banking Personnel Selection IT officer previous year question papers

Will you please share with me the Institute of Banking Personnel Selection IT officer previous year question papers?

[Raman Vij]

As you want to get the Institute of Banking Personnel Selection IT officer previous year question papers so here it is for you:

A special type gateway that can keep external users from accessing resources on the LAN users access the external info is called:
Repeater
Firewall
Encryption
Hub
None of these

What is the name given to the exchange of control signals which is necessary for establishing a connection between a modem and a computer at one end of a line and another modem and computer at the other end?
Handshaking
Modem options
Protocol
All of these
None of these

In SQL, which command is used to changes data in a data table?
UPDATE
INSERT
BROWSE
APPEND
None of these

In SQL, which of the following is not a data definition language command?
RENAME
REVOKE
GRANT
UPDATE
None of these

Which command(s) is (are) used to redefine a column of the table in SQL ?
ALTER TABLE
DEFINE TABLE
MODIFY TABLE
ALL of the these
None of these

In a relational schema, each tuple is divided into fields called
Relations
Domains
Queries
All of the these
None of these

An indexing operation
Sorts a file using a single key
Sorts file using two keys
Establishes an index for a file
Both (1) and (3)
None of these

Data security threats include
Hardware failure
Privacy invasion
Fraudulent manipulation of data
All of these
None of these

The language used in application programs to request data from the DBMS is referred to as the
DML
DDL
Query language
DCL
None of these

A ___ contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.
File structures
Records
Fields
Database
None of these

A ___ means that one record in a particular record type is related to only one record of another record type.
One to one relationship
One to many relationship
Many toone relationship
Many to many relationship
None of these

Through linked list one can implement
Stack
Graph
Queue
All of these
None of these

A heap allows a very efficient implementation of a
Doubled ended queue
Priority queue
Stack
Trees
None of these

In files, there is a key associated with each record which is used to differentiate among different records. For every file there is at least one set of keys that is unique. Such a Key is called
Unique key
Prime attribute
Index key
Primary Key
Null key

____ is primarily used for mapping host names and email destinations to IP address but can also be used for other purposes.
TCP(transfer control protocol)
DNS(Domain Name System)
SHA (Secure Hash Algorithm)
Simple Network Management Protocol (SNMP)
None of these

Override is a method
For an operation that replaces an inherited method for the same operation
For a data that replaces an inherited method for the same operation
For an operation that takes arguments form library function
All of these
None of these

Local variables
Are created outside a block
Are known only to that block
Continue to exist when their block ends
Are illegal in C++
None of these

____ is virus that inserts itself into a system’s memory. Then it take number of actions when an infected file is executed.
Web scripting virus
Polymorphic virus
Macro virus
Boot sector virus
Resident virus

This ___ data mining technique derives rules from real world case examples.
Waterfall model
RAD
White Box
Spiral model
Case based reasoning

The ___ remains operative until the software is required.
Waterfall model
Incremental model
Spiral model
Prototyping model
Incremental model

Data mining evolve as a mechanism to cater the limitations of ___ systems to deal massive data sets with high dimensionality, new data type, multiple heterogeneous data resource etc.
OLTP
OLAP
DSS
DWH
None of these

An important application of cryptography, used in computerized commercial and financial transaction
Data mining
Data warehousing
Digital signature
Media convergence
None of these

Rows of a relation are called:
Relation
Tuples
Data structure
An entity
None of these

The drawbacks of the binary tree sort are remedied by the
Linear sort
Quick Sort
Heap Sort
Insertion Sort
None of these

Which layer of OSI determines the interface of the system with the user?
Network
Application
Data link
Session
None of these

Contact Details:
Institute of Banking Personnel Selection
IBPS House,
Western Express Hwy,
Asha Nagar,
Kandivali East,
Mumbai,
Maharashtra 400066 ‎
1800 22 2366
India

Map Location:

[MAP][MAP]https://www.google.co.in/maps?q=Institute+of+Banking+Personnel+Selection,+W estern+Express+Highway,+Asha+Nagar,+Mumbai,+Mahara shtra&hl=en&ll=19.216466,72.864761&spn=0.010232,0. 013046&sll=18.579692,73.76679&sspn=0.164342,0.2087 4&oq=Institute+of+Banking+Personnel+Selection++&t= m&z=16&iwloc=A[/MAP][/MAP]

I will appear in IBPS Specialist Officer IT Examination 2016. So I want to do preparation now. So I want to download question papers of IT officer Exam. So can any one provide question papers of IBPS SO IT Officer Exam?

[Quick Sam]

Here you want to download question papers of IBPS SO IT Officer Exam, so here I am giving following question papers:

IBPS SO IT Officer Exam Question Paper
1. How many such pairs of letters are there in the word SOUTHERN each of which has as
many letters between them in the word as in the English alphabet?
A. None B. One C. Two D. Three E. More than three
2. If the letters the word COMPARE are rearranged in such that first the vowels within the
word are rearranged alphabetically followed by the consonants arranged alphabetically,
which of following will be the fifth letter from the right end after the rearrangement?
A. O B. E. C. M. D. P E. None of these
3. If every alternate letter in the word SOLITARY starting from the first letter is replaced by
the previous letter in the English alphabet and each of the remaining letters is replaced by
the next letter in the English alphabet, which of the following will be the third letter from
the right end after the substitution ?
A. B B. S C. Z D. K E. None of these
4. The letters in the word DOSE are changed in such a way that each vowel is replaced by
the previous letter in the English alphabet and each consonant is replaced by the next letter
in the English alphabet. How many meaningful words can be formed with the new set of
letters using each letter only once in each word?
A. None B. One C. Two D. Three E. More than three
5. How many such pairs of digits are there in the number 53146827 each of which has as
many digits between them in the number as when the digits are arranged in ascending
order within the number?
A. None B. One C. Two D. Three E. More than three
6. In a certain code CLIMATE is written as BUFLJMD. How is ORDERLY written in that code?
A. SMZDESP B. ZMSDPSE C. ZMSDESP D. ZMSFESP E. None of these
7. The positions of the first and the fifth digits in number 84329517 are interchanged.
Similarly the positions of the second and the sixth digits are interchanged and so on. Which
of the following will be the second from the right end after the rearrangement?
A. 3 B. 4 C. 2 D. 9 E. None of these
8. In a certain code, TOLD is written as 5132 and DEAR is written as 2648. How is LATE
written in that code?
A. 3652 B. 3246 C. 3856 D. 3456 E. None of these
9. In a certain code BEAN is written as ABNE and SALE is written as LSEA. How is NEWS
written in that code?
A. WNES B. WNSE C. SNWE D. SNEW E. None of these
10. Four of the following five are alike in a certain way and so form a group. Which is one
that does not belong to that group?
A. Coal B. Aluminium C. Plastic D. Iron E. Wood
Directions Q. 11-13 : Following questions are based on the information given below:
I.. 'P * Q' means 'P is mother of Q' II. 'P / Q' means 'P is sister of Q'
III. 'P + Q' means 'P is brother of Q' IV. 'P - Q' means 'P is father of Q'
11. Which of the following means 'K is son of R'?
A. R * K B. R - K C. K + T * R D. R - J / K + M E. None of
these
12. Which of the following means 'M is paternal uncle of T' ?
A. M + J - T B. M + J * T C. M / J - T D. M + J + T E. None
of these
13. Which of the following means 'D is cousin of W' ?
A. D / M + W B. D + M / W C. D * T + W D. D - T / N * W E. None
of these
Directions Q. 14-16 : Following questions are based on the five three digits numbers
given below:
518 725 849 387 634
14. If the positions of the first and the third digits in each of the numbers are inter changed,
which of the following will be the lowest number after the rearrangement?
A. 518 B. 725 C. 849 D. 387 E. 634
15. If the positions of the first and the second digits in each of the numbers are inter
changed, which of the following will be the third from the top, when they are arranged in
descending order after the rearrangement?
A. 518 B. 725 C. 849 D. 387 E. 634
16. If the positions of the second and the third digits in each number are inter changed,
which of the following will be the difference between the highest and the lowest number
after the rearrangement?
A. 506 B. 526 C. 416 D. 516 E. None of these
Directions Q. 17-20 : Study the following information carefully and answer the questions
given below:
P, Q, R, S, T, V and J are sitting around a circle facing at the center. S is not an immediate
neighbour of V. S is second to the right of T who is second to the right of Q. R is third to the
right of J and second to the left of P.
17. Who is the immediate right of Q?
A. S B. R C. V D. Data inadequate E. None of these
18. What is J's position with respect to P?
A. Third to the right B. Second to the left C. Second to the right D. Data
inadequate E. None of these
19. How many of them are between Q and S?
A. 2 only B. 3 only C. 4 only D. 2 or 3 only E. None of these
20. Who among the following is sitting between V and R?
A. Q B. J C. T D. S E. None of these
Directions Q. 21-27 : Study the following arrangement carefully and answer the questions
given below:
M J % 4 T E I 9 # P A $ Q 3 8 N 5 U 7 W B @ D F 1 Z
6 H
21. How many such symbols are there in the above arrangement, each of which is
immediately preceded by a number and immediately followed by a consonant?
A. None B. One C. Two D. Three E. More than three
22. How many such consonants are there in the above arrangement, each of which is
immediately preceded by a number and also immediately followed by a number?
A. None B. One C. Two D. Three E. More than three
23. If all the symbols are removed from the above arrangement, which of the following will
be the sixth to the right of the thirteenth from the right end?
A. B B. 9 C. D D. I E. None of these
24. If all the numbers are removed from the above arrangements, which of the following
will be the fourth to the left of the twentieth from the left end?
A. H B. 4 C. B D. H E. None of these
25. Four of the following five are alike in a certain way based on their positions in the above
arrangement and so form a group. Which is the one that does not belong to that group?
A. I 9 E B. 7 W 5 C. 1 D D. Q A 3 E. E K 4
26. What should come in place of the question mark (?) in the following series based on the
above arrangement?
J 4 E I # A Q 8 5 7 @ ?
A. F 1 6 B. D Z C. F 6 D. F 1 Z E. None of these
27. Which of the following is exactly midway between K and W in the above arrangement ?
A. $ B. 3 C. 8 D. A E. None of these
Directions Q. 28-33 : In each of the questions below are given three statements followed
by three conclusions numbered I, II and III. You have to take the given statements to be
true even if they seem to be at variance from commonly known facts. Read all the
conclusions and then decide which of the given conclusions logically follows from the given
statements disregarding commonly known facts.
28. Statements :
All halls are tyres
Some tyres are wheels
All wheels are cars
Conclusions :
I. Some cars are wheels II. Some cars are tyres III. Some wheels are halls
A. None follow B. Only I follow C. Only I and II follow D. Only III follows
E. Only II and III follow
29. Statements :
Some blades are hammers
Some hammers are knives
Some knives are axes
Conclusions :
I Some axes are hammers II. Some knives are blades III. Some axes are blades
A. None follows B. Only I follows C. Only II follows D. Only III follows E. None of
these
30. Statements :
All dolls are windows
All bottles are windows
All cars are bottles
Conclusions :
I All cars are windows II Some cars are dolls III. Some windows are cars
A. Only I and II follow B. Only II and III follow C. Only I and III follow D. All follow E.
None of these
31. Statements :
Some benches are beads
All beads are flowers
No tree is flower
Conclusions :
I. Some trees are benches II. Some trees are beads III. No tree is bead
A. Only I follows B. Only either I or II follows C. Only either I or II follows D. Only III
follows E. None of these
32. Statements :
All breads are tables
Some tables are brushes
All brushes are paints
Conclusions :
I. Some paints are breads II. Some brushes are breads III. Some paints are tables
A. None follows B. Only II follows C. Only III follows D. Only I and II follow E. Only II
and III follow
33. Statements :
Some pictures are frames
Some frames are idols
All idols are curtains
Conclusions :
I. Some curtains are pictures II. Some curtains are frames III. Some idols are frames
A. Only I and II follow B. Only II and III follow C. Only I and III follow D. All follow E.
None of these
Directions Q.34-38 : Each of the questions below consists of a question and two
statements numbered I and II given below it. You have to decide whether the data provided
in the statements are sufficient to answer the question. Read both the statements and give
answer
A. If the data in statement I alone are sufficient to answer the question, while the data in
the Statement II alone are not sufficient to answer the question
B. If the data in Statement II alone are sufficient to answer the question, while the data in
Statement I alone are not sufficient to answer the question.
C. If the data either in Statement I alone or in Statement II alone are sufficient to answer
the question
D. If the data given in both the Statement I and II together are not sufficient to answer the
question, and
E. If the data in both the Statements I and II together are necessary to answer the question
34. Who among M, N, P, T and R is the youngest?
I. N and T are younger than P. II M is older than R and P
(A) (B) (C) (D) (E)
35. How many children are there in the row?
I. Manoj is twelth from the left end and fourth to the left of Hari in that row
II. Hari is eigth from the right end of that
(A) (B) (C) (D) (E)
36. How is 'red' written in a code language?
I. 'red and blue' is written as 'ho po da' in that code language II. 'spread red carpet' is
written as 'na da ka' in that code language
(A) (B) (C) (D) (E)
37. Village R is towards which directions of village M?
I. Village M is to the West of Village T which is to the South of Village R
II. Village M is to the South of Village B which is to the West of village R
(A) (B) (C) (D) (E)
38. How many sisters does D have?
I. D's mother has four children II. K and T are brothers of E
(A) (B) (C) (D) (E)
Directions Q. 39-43 : In each question below is given a statement followed by two
assumptions numbered I and II. An assumption is something supposed or taken for
granted. You have to consider the statement and the following assumptions and decide
which of the assumption is implicit in the statement and given answer
A. if only Assumptions I is implicit B. if only Assumption II is implicit C. if either
Assumption I or Assumption II is implicit
D. if neither Assumption I nor Assumption II is implicit E. if both Assumption I and II are
implicit
39. Statements :
The Government has decided to provide monetary relief to the farmers in the drought his
areas
Assumptions :
I. The farmers of the affected areas may accept the Government relief
II. The Government machinery may be able to reach the affected farmers to provide relief
(A) (B) (C) (D) (E)
40. Statements :
All the students of a school were instructed by the Principal to reach school at least 15
minutes before the stipulated time for the coming month
Assumptions :
I. The parents of the students of the school may protest against the Principal's instructions
II. The parents may request the Principal to withdraw the instruction
(A) (B) (C) (D) (E)
41. Statements :
Railway authority has started internet booking facility of long distance trains and also
deliver the tickets at the door-step through courier service at a little extra cost
Assumptions :
I. Many customers may now book their tickets through internet resulting into less crowd at
ticket booking offices.}
II. Most of the customers may still buy their railway tickets at the booking counters
(A) (B) (C) (D) (E)
42. Statements :
" If you have obtained 75% or more marks in X Std. examination, your admission to our
coaching class for XII Std. is guaranteed". - An advertisement
Assumptions :
I. Bright students do not generally opt for attending coaching classes
II. The coaching class has adequate capacity to accommodate all such students
(A) (B) (C) (D) (E)
43. Statements :
The municipal corporation has given permission for holding funfairs in the local football
ground during the holiday season
Assumptions:
I. The local residents may protest against the Corporation's decision
II. Many people may not participate in the unfair
(A) (B) (C) (D) (E)
Directions Q. 44-48: Below is given a passage followed by several possible inferences
which can be drawn from the facts stated in the passage. You have to examine each
inference separately in the context of the passage and decide upon its degree of truth or
falsity and mark answer:
A. if the inference is definitely true i.e, it properly follows from the statement of facts given
B. if the inference is probably true though not definitely true in the light of facts given
C. if the data are inadequate, i.e, from the facts given you cannot say whether the inference
is likely to be true or false.
D. if the interference is probably false, though not definitely false in the light of the facts
given
E. if the inference is definitely false, i.e, it cannot possibly be drawn from the facts given or
it contradicts the given facts
The jeweller-next-door may have reasons to worry, thanks to the organised retail and
branded goods hitting the right cord from Indian consumers. The recent changes in lifestyle
goods industry and the diamonds industry threatens to impact the family jeweller segment,
which currently controls 97% of India's fragmented jewellery retail market. A study
suggests that as India's jewellery market matures, it is expected to get more organised and
the share of family jeweller is expected to come down. The family jeweller segment is he
largest segment of the market and hence, most likely to be impacted by these changes.
Family jewellers will have to bring in new practices and range of designs and customisation
of jewellery would differentiate the players. Currently, organised retailers are enlarging the
pie but the traditional players are not feeling the impact yet
44. Share of business of the small time jewellers will reduce substantially in the near future
(A) (B) (C) (D) (E)
45. Family jewellers have never customised their designs in the past.
(A) (B) (C) (D) (E)
46. Big retail companies have the capability to bring in more competition in the jewellery
market
(A) (B) (C) (D) (E)
47. Family jewellers at present control about two-third share of the entire jewellery market
(A) (B) (C) (D) (E)
48. There is a perceptible change in the choices of the customers in recent times with
regard to lifestyle products
(A) (B) (C) (D) (E)
Directions Q.49-53 : Below in each question are given two statements I and II. These
statements may be either independent causes or may be effects of independent causes or a
common cause. One of these statements may be the effect of the other statement. Read
both the statements and decide which of the following answer choice correctly depicts the
relationship between these two statements and mark answer:
A. if Statement I is the cause and statement II is its effect.
B. if Statement II is the cause and Statement I is its effect
C. if both the Statements I and II are independent causes
D. if both the Statements I and II are effects of independent causes
E. if both the Statements I and II are effects of some common cause
49. I. The prices of petroleum products dropped marginally last week
II. The State Government reduced the tax on petroleum products last week
(A) (B) (C) (D) (E)
50. I. Majority of the citizens in the locality belong to higher income group.
II. The sales in the local super market are comparatively much higher than in other
localities
(A) (B) (C) (D) (E)
51.I. A major fire destroyed part of the oil refinery owned by a private company.
II. Government has decided to increase the supply to retailers from the public sector
refineries
(A) (B) (C) (D) (E)
52. I. The Government medical college has decided to increase the number of seats in
undergraduate course from the next academic session
II. The Government has decided to withdraw its grant from all the Government medical
colleges from the next academic session'
(A) (B) (C) (D) (E)
53. I. Every year large number of people spend their vacation in various tourist destinations
within the country
II. Every year large number of people spend their vacations in various tourist destinations
outside the country
(A) (B) (C) (D) (E)