As IBPS IT Officer Exam is on the head, we are here to provide you MCQ set from previous paper. Questions are in mixed form and asked in previous exam of IBPS IT Officer. In case you have any doubt Ask us. 

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

2. 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?
A. Handshaking
B. Modem options
C. Protocol
D. All of these
E. None of these

3. In SQL, which command is used to changes data in a data table?
A. UPDATE
B. INSERT
C. BROWSE
D. APPEND
E. None of these

4. In SQL, which of the following is not a data definition language  command?
A. RENAME
B. REVOKE
C. GRANT
D. UPDATE
E. None of these

5. Which command(s) is (are) used to redefine a column of the table in  SQL ?
A. ALTER TABLE
B. DEFINE TABLE
C. MODIFY TABLE
D. ALL of the these
E. None of these

6. In a relational schema, each tuple is divided into fields called
A. Relations
B. Domains
C. Queries
D. All of the these
E. None of these

7. An indexing operation
A. Sorts a file using a single key
B. Sorts file using two keys
C. Establishes an index for a file
D. Both (1) and (3)
E. None of these

8. Data security threats include
A. Hardware failure
B. Privacy invasion
C. Fraudulent manipulation of data
D. All of these
E. None of these

9. The language used in application programs to request data from the  DBMS is referred to as the
A. DML
B. DDL
C. Query language
D. DCL
E. None of these

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