Ibps /sbi (i.t. officer jmgs 1) 2017

SBI SO -2016 

Morning Shift Profession Knowledge Question:

  • 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 Profession Knowledge Question:

  • 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

For SBI so reasonig English quant section whether they consider individual cutoff or they consider overall cutoff also

MEMORY Based question of SBI SO in 2nd shift......


How many types of dimensions exist in Cloud cube model ?

(1) 6

(2) 3

(3) 4

(4) 2

(5) 1

System analysts work with end users to determine the features that must be included in a new IT application. These are called ... .

(1) implications

(2) requirements

(3) effects

(4) core functions

(5) critical processes

What is full form of SOA, a method to improve availability in ITL ?

(1) Service ability of Applications

(2) Service Outage Analysis

(3) Service Offer Adjustment

(4) Systematic Operational Adjustment

(5) System Optimization Approach

Which of the following is not a Web App interface mechanism ?

(1) Cookies

(2) Forms

(3) Browser

(4) Cookies and Links

(5) Links

Which of the following can help to detect transmission errors by appending specially calculated bits into the each segment of data ?

(1) Parity check

(2) Integrity check

(3) Accuracy check

(4) Redundancy check

(5) Completeness check

SQL security issues include which of the following ?

(1) The complexity of key structures

(2) The number of records

(3) The size of databases

(4) The number of candidate key elements

(5) Granularity of administration

What is the technical name of a wireless network ?

(1) SSID

(2) SSO

(3) WPAD

(4) WPA

(5) BSSID

If you are connected to your internal network, what should you check if you cannot connect to with servers on the internet ?

(1) Administrative rights

(2) NTFS permissions

(3) Browser settings

(4) Proxy settings

(5) UAC

To define what columns should be displayed in an SQL, SELECT statement ....................

(1) use USING to name the source table(s).

(2) use SELECT to name the source table(s) and list the columns to be shown after USING.

(3) use USING to name the source table(s) and list the columns to be shown after SELECT.

(4) use FROM to name the source table(s) and list the columns to be shown after SELECT.

(5) use USING to name the source table(s) and list the columns to be shown after WHERE.

Which of the following is a CASE SQL statement ?

(1) A way to establish a data definition in SQL.

(2) A way to establish an IFTHENELSE

in SQL.

(3) Establish a loop in SQL or establish an IFTHENELSE

in SQL.

(4) A way to establish a loop in SQL.

(5) A way to establish a data definition in SQL or establish a loop in SQL.

Which one is not a phase of the systems development life cycle ?

(1) Problem analysis

(2) Decision analysis

(3) Requirements analysis

(4) Postimplementation

review

(5) Scope definition

The simplest model in software development is ...................

(1) Iterative

(2) COCOBC model

(3) spiral

(4) waterfall model

(5) prototyping

....................is a standard for security that is located at the network or packet processing layer of network communications, as opposed to the application

layer.

(1) TCP

(2) SQL

(3) IPsec

(4) SHTTP

(5) passive FTP

A thin, creditcard

size device used principally on Laptop computers to expand its capabilities is...............

(1) special card

(2) smart card

(3) expansion card

(4) flash card

(5) PC card

In the concept of object orientation, .........................

(1) Users change properties and cell functions

(2) Designers can only call functions

(3) Designers can only call calculations

(4) Users change properties with their input devices

(5) Designers convert binary data into object functions

What type of BCP test user adjusts resources to simulate a system crash and validate the plan's effectiveness ?

(1) Paper

(2) Preparedness

(3) Walkthrough

(4) Parallel

(5) None of the above

Data mining is used to aid in.............................

(1) analyzing current decisions made by managers.

(2) operational management

(3) retrieving archival data

(4) analysing past decisions made by managers

(5) detecting patterns in operational data

Which of the following provid network redundancy in a local network environment ?

(1) Shadowing

(2) Mirroring

(3) Mirroring and Shadowing

(4) Duplexing

(5) Dual backbones

On pointtopoint

networks, OSPF hello packets are addressed to which address ?

(1) 27.0.0.1

(2) 172.16.0.1

(3) 224.0.0.5

(4) 192.168.0.5

(5) 224.255.255.255

Which of the following do digital signatures provide ?

(1) Authentication and integrity of data

(2) Confidentiality and availability of data

(3) Authentication and confidentiality of data

(4) Confidentiality and integrity of data

(5) Authentication and availability of data

Which of the following codes must be granted to an Oracle 9x to perform a full database import ?

(1) CONNECT

(2) RESOURCE

(3) FULL_REPORT_PREVS

(4) FULL_REPORT_PRINS

(5) IMP_FULL_DATABASE

What does CIDR, a method of allocating IP addresses, stand for ?

(1) Classless Interdomain

Routing

(2) Classless IP Default Routing

(3) Glassful IP Dclass

Routing

(4) Classless IP Dclass

Routing

(5) Glassful Information Routing

What tool is used to view the hardware and software loaded on a Windows server ?

(1) KB Tool

(2) System Information

(3) System configuration

(4) POST

(5) Device manager

A server farm is an example of..........................

(1) Multiple servers

(2) Redundant servers

(3) Server clustering

(4) Standalone

server

(5) Serve fault tolerance

Map entities, attributes and relations in Oracle is represented by .....................

(1) Special Schema

(2) Conceptual and Physical Schema

(3) Logical Schema

(4) Physical Schema

(5) Conceptual Schema

A systems analysis test used to display how data moves through a new program design is called a(n).............

(1) data logic chart

(2) dataflow diagram

(3) system flowchart

(4) software logic diagram

(5) webrelationship

illustration

Which one of the following control steps is usually not performed in data warehousing applications ?

(1) Monitor summary tables for regular use

(2) Cleaning up the data

(3) Control meta data from being used interactively.

(4) Reconcile data moved between the operations environment and data warehouse

(5) Monitor the data purging plan

Any idea for developers n testers paper

Anyone who can tell what is the minimum number of attempts in professional knowledge section that will guarantee you an interview call? Category: General

Zz

Pagal guy jaisa koi aur badiya app h ???

If you are a paper setter then what topics would you include in pk ? please be specific..

1. If the Quant, Logic, English are just qualifying papers, then the cutoff for last years is around only 5 marks. then what is point of studying them? I should prepare for Professional Knowledge test only nah? please correct me if my strategy is wrong. 

2. More over what does PK test syllabus comprises of, I belongs to EEE but applied as I had electronics, is there any problem with that?

 Oracle version 9.2.0.4.0 what does each number refers to?

  • 9-Major database release number
  • 2-Database Maintenance release number
  • 0-Application server release number
  • 4-Component Specific release number
  • 0-Platform specific release number


 

What are the extensions used by oracle reports

Answer : Oracle reports are used to make business enable to provide information of all level within or outside in secure way. REP file and RDF file extensions are used by oracle report.


#Networking Simplified .. 

http://servicetechmag.com/system/application/images/I38/0410-3-fig02.jpg

Helloo guys...!!


i m preparing for SBI SO exam..!!

Can anyone guide me..in PK section...what to study...how much to study..n from where to study?? plzzz help...

 

1. If the Quant, Logic, English are just  qualifying papers, then the cutoff for last years is around only 5  marks(it is only 1 or 2 marks for obc as in 2014), i belongs to obc). then what is point of studying them, cant anyone cross such less marks out of 50 or 35) ? I should prepare for  Professional Knowledge test only nah? please correct me if my strategy  is wrong.  

2. More over what does PK test syllabus comprises of, I belongs to  EEE but applied as I had electronics, is there any problem with that at the time of interview?

solve previous year sets and google each option other than the crrct one ...hover around the topic by googling... follow youtube ..topic wise.. solve online affrscloud quiz for it offcr ..make sure u clear ur basics u shud be able to eliminate each options by knwing it very well...by heart or learn kiran publication book.. u can go for arihant it offcrs buk as well...

an ip protocol field of 0x06 indicates that ip is carrying what as its payload ?

  • TCP
  • TCP OR IGRP
  • UDP
  • ICMP

0 voters

R u watching match?

  • Watching and studying
  • No, studying
  • Yes

0 voters

Based on passed trends,what is the cutoff of Pk section in SBI (IT) ?

 1. If the Quant, Logic, English are just  qualifying papers,  then the cutoff for last years is around only 5  marks(it is only 1 or 2  marks for obc as in 2014), i belongs to obc). then what is point of  studying them, cant anyone cross such less marks out of 50 or 35) ? I  should prepare for  Professional Knowledge test only nah? please correct  me if my strategy  is wrong.   2. More over what does PK test syllabus comprises of, I belongs to   EEE but applied as I had electronics, is there any problem with that at  the time of interview? 

can anybody tell me the answer to this question. It was asked in previous year IT exam.


maximum no.of programs that can be run in a linux of 32-bit os?