Tag: IBPS Specialist Officer IT Officer Exam Questions 2016

IBPS Specialist Officer IT Officer Professional Knowledge Questions 2016

Welcome to our study portal GraduateGeeks.com, Institute of Banking personnel selection (IBPS) is going to conduct Specialist officer exam on the coming February 2016 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 2016.

IBPS Specialist Officer IT Officer Professional Knowledge Questions 2016

IBPS Specialist Officer IT Officer Professional Knowledge Questions 2016

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

study

Uttarakhand Revenue Dept Collector Office, Pauri Inspector (Patwari, Accountant) Exam Syllabus

General Awareness MCQ Questions On History, Geography & Polity

Current Affairs For IBPS SSC And Other Govt Exams 2015

Latest Bank PO Jobs 2016

IBPS Specialist Officer SO IT Previous Year Exam Papers 2013:

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)

General Awareness For UPSC, CDS, NDA, RRB, SCRA On Indian Economy

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

SSC CGL Notification Admit Card Syllabus & Result © 2017