IBPS IT Officers Exam Papers

I am looking for previous year question papers of IBPS IT Officers Exam so please provide me the same for preparation?

[Arun Vats]

Here I am providing you previous year question papers of IBPS IT Officers Exam for your preparation.


IBPS IT Officers Exam Professional knowledge Questions:

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


IBPS IT Officers Exam General Awareness Questions:

1. Who among the following is one of the recipients of the Nobel Peace Prize – 2011?

(a) Ellen Johnson Sirleaf
(b) Jules A. Hoffmann
(c) Bruce A. Beutler
(d) Adam G. Riess
(e) Tomas Transtromer

2. The Food Security Bill – 2011 which is the process of becoming an Act, divides the entire population of the country into two groups. Which of the following are these two groups?

(a) Below poverty line and Above poverty line
(b) General population and Excluded population
(c) Included households and Excluded households
(d) Covered under PDS and Not Covered under PDS
(e) General households and priority households

3. RBI has recently deregulated the rates of interest to be provided by various Banks to their depositors/customers with effect from 25-10-2011 on their _____ accounts?

(a) Time Deposit
(b) Saving bank
(c) Loan
(d) Fixed deposit
(e) Current

4. Which of the following is the main advantage of “ASBA” with the applicants for share allotment?

(a) ASBA applicant has got secured allotment of shares
(b) ASBA applicant has got certain preference in allotment of shares as compared to general applicants
(c) ASBA applicant need not remit the fund for allotment of shares, he/she will do so after shares are allotted to him/her.
(d) ABSA Applicants deposit/OD account is not debited, only the funds are blocked for the same and he/she continues to avail interest till the shares are allotted to him/her.
(e) None of these

5. “Many people die in Deadly Games in Egypt”: Was the news in almost all major newspaper in February 2012. Which of the following statements is the correct representation of ‘Deadly Game’ given in the headlines?

(a) A riot broke out during a Football Match in Egypt in which many people were killed
(b) Police had to open fire on a Mob including some genuine ticked holders, who were not allowed to enter the Stadium even after the start of the match
(c) Egypt is famous for its dangerous games of ‘Bull fight’ and ‘Martial Game’; Many participants die every year in such games
(d) Some terrorist opened fire during a football match. About 10000 people were killed in the incident
(e) The defeat in the game is considered equivalent to death

6. Mullaperiyar Dam which was recently in news, is located in which of the following States?

(a) Maharashtra
(b) Karnataka
(c) Andhra Pradesh
(d) Kerala
(e) Tamil Nadu


IBPS I T Officers Exam Reasoning Questions:

1. In a certain code ‘TREAMWORK’ is written as ‘NBFUJQNV’ and ‘SOME’ is written as ‘PTDL’. How is ‘PERSON’ written in that code?
(a) QDOOPT
(b) QDOMNR
(c) SFQMNR
(d) SFQOPT
(e) None of these

2. How many such pairs of letters are three in the word ‘SUBSTANCE’ each of which has as many letters between them in the word (in both forward and backward directions) as in the English alphabets?
(a) None
(b) One
(c) Two
(d) Three
(e) More than three

3. How many meaningful English words, not ending with ‘D’ can be made with the third, the fifth, the seventh and the ninth letters of the word ‘STEADFAST’ using each letter only once in each word?
(a) None
(b) One
(c) Two
(d) Three
(e) More than three

4. In a certain code ‘BASKET’ is written as ‘5$3%#1’ and ‘THIRD’ is written as ‘14*#2’. How is ‘SKIRT’ written in that code?
(a) 3%*41
(b) 3/%41
(c) 3%#41
(d) 3#4%1
(e) None of these

5. The positions of the first and the fifth digits of the number 81943275 are interchanged. Similarly the positions of the second and the sixth digits are interchanged and so on till the fourth and the eight digits. Which of the following will be the third digit from the right end after the rearrangement?
(a) 1
(b) 9
(c) 2
(d) 4
(e) None of these

Study the following arrangement carefully and answer the questions given below:

M3 # R A T 1 E J $ K @ F U 5 4 V I 6©D 8 * G B 7 δ 2 W

6. Four of the following five are alike in a certain way based on their position in the above arrangement and so form a group. Which is the one that does not belong to that group?
(a) T E R
(b) U4 @
(c) 6 D V
(d) J 1 K
(e) N δ *

7. How many such numbers are there in the above arrangement, each of which is immediately preceded by a letter but not immediately followed by a letter?
(a) None
(b) One
(c) Two
(d) Three
(e) More than three

8. What should come in place of the question mark (?) in the following series based on the above arrangement? R T 1 $ @ F
(a) 8 * H
(b) 8 H N
(c) 8 H 7
(d) D * H
(e) None of these

9. How many such symbols are there in the above arrangement, each of which is immediately preceded by a number and immediately followed by a letter?
(a) None
(b) One
(c) Two
(d) Three
(e) More than three

10. Which of the following is the seventh to the left of the twentieth from the left end of the above arrangement?

(a) V
(b) @
(c) δ
(d) ©
(e) None of these