IBPS Specialist IT Officer Previous Paper - 2017-2018 StudyChaCha

Go Back   2017-2018 StudyChaCha > StudyChaCha Discussion Forum > General Topics




  #1  
Old January 11th, 2014, 02:50 PM
Unregistered
Guest
 
Posts: n/a
Default IBPS Specialist IT Officer Previous Paper

Can you please provide me the previous years question papers of IBPS Specialist IT Officer Exam??
Reply With Quote
  #2  
Old January 11th, 2014, 03:57 PM
Super Moderator
 
Join Date: Jun 2013
Posts: 42,987
Default Re: IBPS Specialist IT Officer Previous Paper

Here I am providing you the previous years question papers of IBPS Specialist IT Officer Exam

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

Rest of the questions are attached in below file which is free of cost
__________________
Answered By StudyChaCha Member
Reply With Quote
Sponsored Links






















  #3  
Old February 3rd, 2015, 11:37 AM
Super Moderator
 
Join Date: Nov 2011
Posts: 31,703
Default Re: IBPS Specialist IT Officer Previous Paper

Here I am giving you syllabus and previous years question paper of IBPS Specialist IT (Information technology) Officer.

IBPS IT Officer Exam Syllabus:

English Language:
Reading comprehension, fill in the blanks, sentence corrections, Para jumbles, Vocabulary, Grammar Corrections, Identification of Errors, sentence corrections, Vocabulary, Grammar Corrections, Identification Of Errors, Synonyms/ Antonyms, Choosing the appropriate word and Spelling Check questions

Reasoning:
Questions are asked from both Verbal and Non Verbal reasoning. In verbal reasoning – Completing number and alphabetical series, Coding and decoding, relations and ranking, Simple arithmetical reasoning, Analogies / decision making, Classification, odd one out, time sequence test, analytical reasoning, directions/distance sense test, input /output /seating arrangements etc.
In non verbal reasoning – series completion, finding missing figures, Mirror Images etc.

Professional Knowledge:
1) Data Base Management System (DBMS) – 15-20 Questions
1. RDBMS
2. Normalization
3. Overview of SQL queries
4. E- R Diagrams
5. Transaction Management

2) Data Communication & Networking – 10-15 Questions
1. Network Architecture
2. OSI Model
3. TCP-IP Model
4. Data Communication
5. IP Addressing (Subnetting)

3) Operating System – 4-5 Questions
1. Process
2. Thread
3. Types of OS
4. Semaphore
5. Scheduling
6. Dead Lock
7. Memory Partitioning
8. Page Replacement

4) Computer organization + Hardware (Microprocessor) – 4-5 Questions
1. Bus Structure

5) Network Security – 2 – 3 Questions
1. Cyber Crimes
2. Risk Management
3. Firewall
4. Cryptography

6) Software Engineering – 2 – 3 Questions
1. Software Development life cycle (SDLC)
2. Software Development Models

7) Data Structures – 3 – 4 Questions
1. Array
2. Linked List
3. Stacks

8) Web Technologies – 1-2 Questions
1. HTML Tags
2. XML
3. Network Security

9) Programming Languages (BASIC) – 1-2 Questions
1. C, C++
2. OOP (Objected oriented Programming)


Previous Years Question Paper of IBPS Specialist IT Officer:

Which of the following microprocessors is not 8bit microprocessor?
8085
6502
Z80
68000
None of these

Microprocessor 8085 is the enhanced version of which essentially the same construction set
6800
8080
6800A
8000
All of these

Which of the following interrupts has the lowest priority?
RST 5.5
RST 7.5
TRAP
INTR
None of these

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

A collection of fields is called a record with respect of DBMS, a record corresponds to
Tuple
Relation
File
Attribute
None of these

Multiplexer means
One into many
Many into one
Many into many
All of these
None of these

Which gate is known as universal gate ?
NOT gate
NAND gate
AND gate
XOR gate
None of the above

Which of the following is the first integrated logic family?
TCL
T1L
DTL
MOS
RTL

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)

In the relational schema, each tuple is divided into fields called.
Relations
Domains
Queries
Both (1) and (2)
Both (1) and (3)

The modify operation is likely to be done after.
Delete
Insert
Look up
All of the above
None of these

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

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

Which normal form is considered adequate for relational database design?
2 NF
3 NF
4 NF
BCNF
None of these

An attribute of one matching the primary key another table, is called as
Foreign key
Secondary key
Candidate key
Composite key
None of these

Which of the following SQL commands can be used modify existing data in a database table?
MODIFY
UPDATE
CHANGE
NEW
None of these

Each node in a linked list must contain at least:
Three fields
Five fields
Four fields
One fields
Two fields

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

The order of the binary search algorithm is
n
n2
nlog(n)
log(n)
None of these

Which of the following is useful in implementing quick sort?
Stack
Set
List
Queue
None of these

OSI model consists of ____ layers
Three
Five
Six
Eight
Seven

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)

Encryption and decryption are functions of the ____ layer.
Transport
Session
Application
Physical
Presentation

Which of the following is not a connecting device?
Bridge
Trans receiver
Router
Repeater
None of these

Repeaters function in the ___ layer
Physical
Data link
Network
Both (1) and (2)
None of these

How many hosts are attached to each of the local area network at your site?
128
256
254
64
None of these

Which of the following types of software should we use if we often need to create, edit and print documents?
Word processing
Spread sheet
Object program
UNIX
None of these

_____ is present in spiral model
Code generator
Risk analysis
Code optimizer
Reengineering
None of these

The approach used in top down analysis and design is :
To identify the top level functions by combining many smaller components into a single entity
To identify a top level function and then create hierarchy of lower level modules and components
To prepare flowcharts after programming has been completed
All of these
None of these

B2C ecommerce focuses on customer ___.
Respond to customer
Obtain customer feedback
Establish buyerseller transaction
All of the above
None of these

OLAP stands for
Online Analytical project
Online Analytical problem
Online Application process
Online Application Problem
Online Analytical processing

Data mining is
Storing data when in need
Automatic extraction of patters of information
Searching data on Internet
All of these
None of these

Decision support system are based on ____ analysis
Query and reporting
Data mining
OLAP
All of the above
None of these

The term push and pop is related to the
Array
Lists
Stacks
All of the above
None of these

The break statement causes an exit.
From the innermost loop only
Only from the innermost switch
From the loops and switches
From the innermost loop or switch
None of these

Backup procedure helps in
Restoring the operation whenever there is a disk failure
Restoring both application and system software whenever there is disk corruption
Restoring the data sites whenever there is a system crash
All of the above
None of these

Software testing is
The process of demonstrating that error are not present
One process of establishing confidence that a program does what it is supposed to do
The process of executing a program to show that it is working as per specifications
The process of executing a program with the intent of finding errors
None of these

Regression testing in primarily related to
Functional testing
Data flow testing
Development testing
Maintenance testing
None of these

Which of the following is easiest software development process model?
Waterfall Model
Prototyping
Interactive enhancement
Spiral model
All of these

Banker’s algorithm for resource allocation deals with
Deadlock prevention
Deadlock avoidance
Deadlock recovery
Mutual exclusion
All of these

In Queues, the items deleted at one end is called.
Rear
Front
Top
Base
None of these

Pointer is used in
Direct Addressing
Indirect Addressing
Indexed mode
Immediate Addressing
None of these

An array can be passed in a functions in C language through
‘Call by value’ only
‘Call by reference’ only
Both (1) & (2)
Call by preference
None of these

HTTP refers to
Hyper Text Transmission Protocol
Hyper Text Transfer Protocol
Hyper Text Tie Protocol
Hyper Text Total Protocol
None of these

An email account includes a storage area, often called a (n)
Attachment
Hyperlink
Mailbox
Ip address
None of these

A(n) ____ is a collection of information that determines which files you can access and which setting you use.
Network
User account
Operating system
File system
None of these

To print a document
Select the print command and then select OK
Select the Ready printer and then select OK
Type PRINT and then press Enter
Close the document, select the print command then select OK
None of these

Which part of the computer provides only temporary storage of files?
ROM memory
Processor
Hard drive
Mother board
RAM memory
__________________
Answered By StudyChaCha Member
Reply With Quote
Other Discussions related to this topic
Thread
IBPS specialist officer law scale 1 solved question papers of last years
Previous Years Question Papers of IBPS IT officer scale I
SBI Specialist Officer paper
IBPS Specialist officer previous question papers
Previous Year IBPS-RRB Officer Scale-1 Solved paper
IBPS IT officer Previous Year Paper
IBPS Specialist Officers Exam previous year question papers
Solved Papers IBPS Specialist Officer IT
Books for IBPS Exam for Specialist Officer in IT
Solved Paper for IBPS IT officer
Model Paper for IBPS IT Officer
IBPS Specialist officer syllabus
IBPS HR specialist officer syllabus
IBPS Specialist officer Model question papers
IBPS Specialist Officer Exam Syllabus
IBPS Specialist officer exam Books
IBPS HR specialist officer previous years question papers
Bank of India Specialist Officer Exam Sample Paper
SBI Specialist Officer Question Paper
Question Paper for IBPS Special IT Officer






Have a Facebook Account? Ask your Question Here



Reply


Forum Jump


All times are GMT +6.5. The time now is 11:15 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0 PL2

1 2 3 4 5 6 7 8 9