IT questions asked in SBI Specialist Exam 2016

IT questions asked in SBI Specialist Exam 2016

Dear Readers,

We all know that yesterday SBI conducted the Specialist Officer exam and many students have shared the questions asked in the exam. All those who are going to appear for IBPS SO 2016 should go through these questions once because it will give you an idea and will help you understand what IBPS is going to ask.

Morning Shift:

• TCP and UDP functions
• Standby in oracle DB
• Security protocols in network layer
• Spoofing
• In which phase of SDLC prototyping is used
• What does (*) mean in sql
• What is Kernel
• Question related to primary key
• Which file is part of oracle database
• Data Mining Tool
• Security is supported by 802.11b access point
• Data warehouse support (OLAP, OLTP, operational db)
• Class A assignable range
• In database of 50 rows we have to select 20 rows, what operation should be used
• Disaster recovery plan time and cost
• Question related to oracle 9i shared pool
• Which one is middle ware technology
• What is Key-logger
• Function of physical layer
• Group of server that share task
• Which query structure is true
• Message is convert into non-readable is called - encryption 
• Data and Method together inside
• What is prototyping?
• In which stage prototyping will come?
• Keyloggers comes under?
• Class of IP and its range?
• Dataware house supports oltp or olap or both?
• What is cloud computing
• OSI layer in which routing will be done
• What will be done in OSI layer 1
• One question related to which of the following "SELECT" query is correct in the following queries
• Network of servers to work in case of one server is failed
• Kernel means?
• If two tables are having same "primary key" in 2 tables, what will happened(scenarios were given as options)

Evening Shift:

• Full form of CIDR - Classless Inter-Domain Routing
• Which technique is used for estimating the cost of a SDLC model
• 2-3 Questions Of Oracle 9i
• The unauthorised way of manipulating data while entering data
• The digital signature provides what for data
• What is main purpose of NOS
• What is primary objective of SDLC model
• Which amongst following is not part of Sql commands - Add and Replace
• Which amongst is basic Life cycle model - Waterfall
• The flowchart of data flowing in system design - Data Flow Diagram
• The conceptual level of database is managed by whom
• Which amongst provides Security in Network layer unlike Application layer
• The environment of Oracle database is called
• What is another name of wireless communication
• One question was on data marts
• 2-3 questions were based on WebApp
• What is server farming
• What is full form of SOP in ITIL - (SOP) Standard Operating Procedure and ITIL (Information Technology Infrastructure Library)
• Mapping of data,atributions and functions is in which level of database?
• Which of the following Is true about three tier database architecture?
• One question was based on green testing
• Which of following is true about Enterprises
• During Point to Point network in Ospf, the next address of node will be
• The system analysts discuss with end users about implementing new features in a IT software model. What is it called?
• In which OSI layer, the connectors are being used - Physical Layer
• 2-3 questions were based on Cloud computing