Welcome to our study portal www.indjobsportal.in, Institute of Banking personnel selection (IBPS) is going to conduct Specialist officer exam on the coming February 2017 Month. Every guy is preparing for this exam. many of the guys are looking for how to prepare for IBPS Specialist Officer IT Officer Professional Knowledge?
So just you have to go through the Previous Year papers of IBPS SO IT Officer, and practice each and every questions one by one. If you have some doubt in solutions of that questions then you can learn them here. we have opted some best questions of previous year exams of IBPS SO IT Officer Professional Knowledge.
Also hopefuls can check here most important questions with answer asked in previous year IBPS Specialist officer exam.Institute of Banking Personnel Selection is an autonomous agency in India, which started its operation in 1975 as Personnel Selection Services on various posts like IBPS PO, IBPS Clerk and IBPS SO Posts. So here you will find your best study materials for IBPS Specialist Officer IT Officer Exam 2017.
IBPS Specialist Officer IT Officer Professional Knowledge-
1. Which of the following statements is not true about two-tier-client-server database architecture?
1) SQL statements are processed on the server
2) SQL statements may be. processed on some of the clients
3) Business logic is mostly processed on clients
4) Business logic may be processed on the server
5) None
Ans: 3
2. Database redesign is not terribly difficult if the:
1) database is structured
2) database is well-designed
3) database has no data
4) database is relatively small
5) database is relatively large
Ans: 2
3. What is Internet 2?
1) A new type of cabling system for Wide Area Networks
2) A second local area network that can connect with another online LAN to share access
3) A new standard for Internet browsers
4) An association to develop advanced Internet technology
5) None
Ans: 4
4. All of the following are basic principles of networks, except:..
1) each computer must have a network card
2) there must be communications media connecting the network hardware devices
3) there must be at least one connecting device
4) each computer must.have software that supports the movement of information
5) None
Ans: 4
5. The term, “hypertext,” means :
1) Non-sequential writing
2) Hypermedia
3) Blinking text
4) Text with heavy formatting
5) None
Ans: 1
6. When you are selecting a mouse for a particular computer system, what is the most important
consideration?
1) The type of drivers that come with the mouse
2) The length of the mouse cord
3) The type of connector the mouse is equipped with
4) The number of buttons the mouse has
5) None
Ans: 3
7. Which of the following coutd be a legitimate Media Access Control address?
1) 192.168.254.3
2) 3FA2.4756.F9A3.
3) A5514
4) C1.3A.77.5B
5) None
Ans: 1
General Awareness MCQ Questions On History, Geography & Polity
IBPS Specialist Officer SO IT Previous Year Exam Papers :
1. Which of the following microprocessors is not 8bit microprocessor?
8085
6502
Z80
68000
None of these
2. Microprocessor 8085 is the enhanced version of which essentially the same construction set
6800
8080
6800A
8000
All of these
3. Which of the following interrupts has the lowest priority?
RST 5.5
RST 7.5
TRAP
INTR
None of these
4. The Data control language (DCL).
is used to manage user access to data bases
is used to manipulate the contents of a database in some form
Both (1) and (2)
Used for inserting, deleting and updating data in a database
None of these
5. A collection of fields is called a record with respect of DBMS, a record corresponds to
Tuple
Relation
File
Attribute
None of these.
6. Multiplexer means
One into many
Many into one
Many into many
All of these
None of these
7. Which gate is known as universal gate ?
NOT gate
NAND gate
AND gate
XOR gate
None of the above
8. Which of the following is the first integrated logic family?
TCL
T1L
DTL
MOS
RTL
9. A top to bottom relationship among the items in a database is established by a
Hierarchical schema
Network Schema
Relational Schema
Both (1) and (2)
Both (2) and (3)
10. In the relational schema, each tuple is divided into fields called.
Relations
Domains
Queries
Both (1) and (2)
Both (1) and (3)
11.The modify operation is likely to be done after.
Delete
Insert
Look up
All of the above
None of these
12.The way a particular application views the data from the database that the application uses is a :
Module
Relational model
Schema
Subschema
None of these
13.Which two files are used during operation of the DMBS?
Query language and utilities
Data manipulation language and query language:
Data dictionary and transaction log
Data dictionary and query language
None of these
14.Which normal form is considered adequate for relational database design?
2 NF
3 NF
4 NF
BCNF
None of these
15.An attribute of one matching the primary key another table, is called as
Foreign key
Secondary key
Candidate key
Composite key
None of these
16.Which of the following SQL commands can be used modify existing data in a database table?
MODIFY
UPDATE
CHANGE
NEW
None of these
17.Each node in a linked list must contain at least:
Three fields
Five fields
Four fields
One fields
Two fields
18.The average number of key comparisons done in a successful sequential search in a list of length “n” is
Log n
(n-1)/2
n/2
(n+1)/2
None of these
19.The order of the binary search algorithm is
n
n2
nlog(n)
log(n)
None of these
20.Which of the following is useful in implementing quick sort?
Stack
Set
List
Queue
None of these
21.OSI model consists of ____ layers
Three
Five
Six
Eight
Seven
22.Which data communication method is used to transmit the data over a serial communication link.
Simplex
Full duplex
Half duplex
Both (1) and (2)
Both (2) and (3)
23.Encryption and decryption are functions of the ____ layer.
Transport
Session
Application
Physical
Presentation
24.Which of the following is not a connecting device?
Bridge
Trans receiver
Router
Repeater
None of these
25.Repeaters function in the ___ layer
Physical
Data link
Network
Both (1) and (2)
None of these