Ok, as you want the question paper of IBPS Specialist IT Officer exam so here I am providing you.

IBPS Specialist IT Officer exam question paper

Question1. 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

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

Question3. A set of programs that handle firm’s database responsibilities is called a
Data base Management System (DBMS)
Data Base Processing System (DBPS)
Data Management System (DMS)
All of these
None of these

Question4. Which of the following system program forgoes the production of object code to generate absolute machine code and load it into the physical main storage location from which it will be executed immediately upon completion of the assembly?
Two pass assembler
Load and go assembler
Macro processor
Compiler
None of these

Question5. Early morning after sunrise rajesh was standing in front of his house in such a way that his shadow was falling exactly behind him. He starts walking straight and walks 5 meters he turns to his left and walks 3 meters and again turning to his left walks 2 meters now in which direction is he from his starting point?
South
West
South-east
South-west
North-east

Question6. When a customer opens a Deposit account with the Bank, which one of the following is the status of the Bank?
Debtor
Creditor
Trustee
Beneficiary
None of these


IBPS Specialist 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?
1) None 2) One 3) Two 4) Three 5) More than three
2. If the letters in the word COMPARE are rearranged in such a way that first the vowels within
the word are rearranged alphabetically followed by the consonants arranged alphabetically,
which of the following will be the fifth letter from the right end after the rearrangement?
1) O 2) E 3) M 4) P 5) None
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?
1) B 2) S 3) Z 4) K 5) None
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?
1) None 2) One 3) Two 4) Three 5) 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?
1) None 2) One 3) Two 4) Three 5) More than three
6. In a certain code CLIMATE is written as BUFLJMD. How is ORDERLY written in that code?
1) SMZDESP 2) ZMSDPSE 3) ZMSDESP 4) ZMSFESP 5) None
7. The positions of the first and the fifth digits in the 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?
1) 3 2) 4 3) 2 4) 9 5) None
8. In a certain code TOLD is written as 5132 and DEAR is written as 2648. How is LATE written
in that code?
1) 3652 2) 3246 3) 3856 4) 3456 5) None
9. In a certain code BEAN is written as ABNE and SALE is written as LSEA. How is NEWS written
in that code?
1) WNES 2) WNSE 3) SNWE 4) SNEW 5) None
10. Four of the following five are alike in a certain way and so form a group. Which is the one that
does not belong to that group?
1) Coal 2) Aluminium 3) Plastic 4) Iron 5) Wood
Directions (11-13) : Following questions are based on the information given below :
(i) ‘P x 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’?
1) R x K 2) R-K 3) K + T x R 4) R - J ÷ K + M 5) None
12. Which of the following means ‘M is paternal uncle of T’?
1) M + J-T 2) M + J x T 3) M ÷ J - T 4) M + J + T 5) None
13. Which of the following means ‘D is cousin of W’?
1) D ÷ M + W 2) D + M ÷W 3) D x T + W 4) D - T ÷ N x W 5) None
IBPS SPECIALIST OFFICERS (IT) -1
2
Directions (14-16): Following questions are based on the five three digit 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 interchanged, which
of the following will-be the lowest” number after the rearrangement?
1) 518 2) 725 3) 849 4) 387 5) 634
15. If the positions of the first and the second digits in each of the numbers are interchanged,
which of the following will be the third from the top when they are arranged in descending
order after the rearrangement?
1) 518 2) 725 3) 849 4) 387 5) 634
16. If the positions of the second and the third digits in each number are interchanged, which of
the following will be the difference between the highest and lowest number after the
rearrangement?
1) 506 2) 526 3) 416 4) 516 5) None
Directions (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 centre. 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 to the immediate right of Q?
1) S 2) R 3) V 4) Data inadequate5) None
18. What is J’s position with respect to P?
1) Third to the right 2) Second to the left
3) Second to the right 4) Data inadequate 5) None
19. How many of them are between Q and S?
1) 2 only 2) 3 only 3) 4 only 4) 2 or 3 only 5) None
20. Who among the following is sitting between V and R?
1) Q 2) J 3) T 4) S 5) None
Directions (2.1-27) : Study the following arrangement carefully and answer the questions given
below :
M Y % 4 T E K 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?
1) None 2) One 3) Two 4) Three 5) 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?
1) None 2) One 3) Two 4) Three 5) 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?
1) B 2) 9 3) D 4) I 5) None
24. If all the numbers are removed from the above arrangement, which of the following will be the
fourth to the left of the twentieth from the left end?
1) H 2) 4 3) B 4) * 5) None
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?
1) I9 E 2) 7 W 5 3) © 1D 4) Q A 3 5) E K 4
26. What should come in place of the question mark (?) in the following series based On the above
arrangement?
J4E I # A Q 8 5 7 * @ ?
1) F 1 6 2) D © Z 3) F © 6 4) F 1 Z 5) None
27. Which of the following is exactly midway between K and W in the above arrangement?
1) $ 2) 3 3) 8 4) A 5) None
Directions (28-33) : In each of the questions below are given three statements followed by three
conclusions numbered A, B and C. 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 :
A. Some cars are wheels.
B. Some cars are tyres.
C. Some wheels are halls.
1) None follows 2) Only A follows
3) Only A and B follow 4) Only C follows 5) Only B and C follow
29. Statements :
Some blades are hammers.
Some hammers are knives.
Some knives are axes.
Conclusions :
A. Some axes are hammers.
B. Some knives are blades.
C. Some axes are blades.
1) None follows 2) Only A follows 3) Only B follows 4) Only C follows 5) None
30. Statements :
All dolls are windows.
All bottles are windows.
All cars are bottles.
Conclusions :
A. All cars are windows.
B. Some cars are dolls.
C. Some windows are cars.
1) Only A and B follow 2) Only B and C follow
3) Only A and C follow 4) All follow 5) None
31. Statements :
Some benches.are beads.
All beads are flowers.
No tree is flower.
Conclusions :
A. Some trees are benches.
B. Some trees are beads.
C. No tree is bead.
1) Only A follows 2) Only either A or B follows
3) Only either B or C follows 4) Only C follows, 5) None
32. Statements :
All breads are tables.
Some tables are brushes.
All brushes are paints.
Conclusions :
A. Some paints are breads.
B. Some brushes are breads.
C. Some paints are tables.
1) None follows 2) Only B follows 3) Only C follows
4) Only A and B follow 5) Only B and C follow
33. Statements :
Some pictures are frames.
Some frames are idols.
All idols are curtains.
Conclusions :
A. Some curtains are pictures.
B. Some curtains are frames.
C. Some idols are frames.
1) Only A and B follow 2) Only B and C follow
3) Only A and C follow 4) All follow 5) None
Directions (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. Redd both the statements and:
Give answer 1) If the data in statement I alone are sufficient tb answer the question, while the
data in statement II alone are not sufficient to answepthe question.
Give answer 2) 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.
Give answer 3) If the data either in statement I alone or in statement II alone are I sufficient to
answer the question.
Give answer 4) If the data given in both the state-ments I & II together are not sufficient to
answer the question, and
Give answer 5) If the data in both the statements I & II together are necessary to answer the
question.
34. Who among M, N, P, f and R is the youngest?
I. N and T are younger than P.
II. M is older than R and P.
35. How many children are there in the row?
I. Manoj is twelfth from the left end and fourth to the left of Hari in that row.
II. Hari is eighth from the right end of that row.
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.
37. Village R is towards which direction of village M?
I. Village M is to, the west ofvVjllage 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.
38. How many sisters does D have!
I. D’s mother has four children.
II. K and T are brothers of E.
39. Four of the following five are alike in a certain way and so form a group. Which is the one that
does not belong to the group?
1) 31 2) 39 3) 47 4) 41 5) 43
40. In a certain code ROSE is written as # 43$ and FIRST is written as 5*#37. How is STORE
written in that code?
1) 473$# 2) 473#$ 3) 374#$ 4) 347#$ 5) None



For more questions here is the attachment

Attached Files

IBPS Specialist IT Officer exam question paper.pdf (832.6 KB, 51 views)