SBI Specialist Officer Exam Question Paper

Will you please provide the sample Question Paper of SBI Specialist Officer exam ?

[Kiran Chandar]

Here is the list of few questions of SBI Specialist Officer Exam Sample Question Paper which you are looking for .

1. Which of the following statement(s) reflects India's stand on new World Trade Organization's
proposal on the issue of the subsidy to agro products ?
(1) India would protect the interest of its poor farmers who can not bear the burden of the cost of the
products if they have to sell them on cheaper rate.
(2) Indian industry needs more flexibility as compared to the industry in developed countries.
(3) WTO has set up a new committee under the chairmanship of Putin of Russia to look into the issue
of subsidy and find out a solution to the problem acceptable to all the parties.
(A) Only 1
(B) Only 2
(C) Only 3
(D) Both 1 & 2
(E) None of these
Ans : (A)
2. Which of the following statement(s) is / are true about the 11th five year plan of India ?
(1) The highest priority is given to exports ,education and development of steel sector.
(2) The plan aims at achieving the growth at 10 % level by the end of the plan.
(3) The Rashtriya Krishi Vikas Yojana is revived in such a way so that it can be achieve a growth nof 4
% for agriculture sector.
(A) Only 1
(B) Only 2
(C) Only 3
(D) Both 1 & 2
(E) None of these
Ans : (D)
3. As per the figures released recently the Stock markets in emerging economies made handsome
returns last year (2007-08). Which of the following stock markets amongst the BRIC nations registered
highest increased (97 %) compared to its performance in 2006-07 ?
(A) China
(B) Brazil
(C) Russia
(D) India
(E) None of these
Ans : (A)
4. Bayana which was in news recently is a place in—
(A) Uttar Pradseh
(B) Madhya Pradseh
(C) Bihar
(D) Haryana
(E) Rajasthan
Ans : (E)
5. Which of the following statement (s) is / are correct about the Indo-Russia Bilateral Defence Ties ?

(1) Both the countries have decided to produce a fifth generation fighter aircraft and a multi role cargo
plane.
(2) India has agreed to launch Russian missiles from its base at Chandipur incase some other nation
attacks on Russia
(3) India and Russia were able to sort out differences over the utilization of Rupee debt fund which is
of Rs. 8000 crore at present.
(A) Only 1
(B) Only 2
(C) Only 3
(D) Both 1 & 3 only
(E) None of these
Ans : (A)
6. India has recently decided to put a wire fence on the 76 km. long border in Dhudri district in Assam.
The fence will separate India from—
(A) Nepal
(B) China
(C) Bangladesh
(D) Myanmar
(E) Pakistan
Ans : (C)
7. As we all know the Govt. of India is very keen about providing banking service to the people in rural
and remote areas . However , banks feel that the cost of providing services in these areas for financial
inclusion is quite high if services are offered through the "traditional branch channel ". What is / are the
other alternative cost effective channel(s) to fulfill this aim of the Govt. of India ?
(1) Putting biometric ATMs.
(2) Introduce mobile banking.
(3) Issue credit or debit cards
(A) Only 1
(B) Only 2
(C) Only 3
(D) All 1, 2 & 3
(E) None of these
Ans : (B)
8. The Govt. of India recently issued a notification altering constituencies in 24 States and Union
territories. This is done as per the provision of which of the following Acts?
(A) Delimitation Act
(B) Census Act
(C) Parliament Act
(D) State Reorganization Act
(E) None of these
Ans : (A)
9. As we read very frequently in the newspaper fraudulent activities in financial world is still
continuing despite various efforts made by various countries to prevent them. As an estimate by IMF,
what is the probable amount derived from such illegal activities which is laundered through the world's
formal financial systems every year? About -

(A) US$ 500 billion
(B) US$ 800 billion
(C) US$ 1000 billion
(D) US$ 1250 billion
(E) US$ 1500 billion
Ans : (A)
10. Indian Prime Minister during his visit the Arunachal Pradseh a few months back asserted that the
State is India's Land of Rising Sun. Which of the following countries did not like his statement and had
raised some objection over his visit to Arunachal Pradseh which is very much a part of India?
(A) Myanmar
(B) China
(C) Bangladseh
(D) Bhutan
(E) Nepal
Ans : (B)
11. Which of the following is the amount of insurance cover provided to the workers of the
unorganized sector under Rashtriya Swasthya Bima Yojana?
(A) Rs. 10,000/-
(B) Rs. 20,000/-
(C) Rs. 30,000/-
(D) Rs. 40,000/-
(E) Rs. 50,000/-
Ans : (C)
12. Which of the following is NOT one of the highlights Economic Survey presented in the Lok Sabha
for the year 2007-08?
(A) Economy has "moved to higher growth phase"
(B) A trend of acceleration in domestic investment and saving rate is recorded.
(C) Buoyant growth in Govt. revenue.
(D) Indian Economy at market rate of exchange crossed 1 trillion US$ in current fiscal.
(E) Net Foreign direct Investment increased by 350% .
Ans : (E)
13. Which of the following is / are correct about sub prime crisis which was in news recently?
(1) It has reduced the flow of capital coming of Indian Stock Markets.
(2) The sub prime crisis is the major financial crisis whose origin is in the Russia and Brazil.It has
adversely affected the economy of Europe and USA.
(3) The crisis started when some people started trading with false Share certificates of major blue chip
US companies in the stock markets.
(A) Only 1
(B) Only 2
(C) Only 3
(D) Both 1 & 2
(E) None of these
Ans : (D)
14. The Prime Minister Gram Sadak Yojana (PMGSY) has a target to connect all habitations of which

of the following levels with all weather roads by 2008-09?
(A) 1000+
(B) 2000+
(C) 3000+
(D) 4000+
(E) None of these
Ans : (A)
15. As we all know the value of the Indian rupee has appreciated in the recent past . The value of the
Rupee is direct dependent on which of the following?
(A) Availability of commodities in the market.
(B) VAT introduced by the Govt. on various commodities.
(C) Size of total Forex Reserve of India currently.
(D) Capital flow in the market during a given period of time.
(E) None of these
Ans : (A)
16. Which of the following banks has taken over the Centurion Bank of Punjab?
(A) ICICI Bank
(B) IDBI Bank
(C) HDFC Bank
(D) AXIS Bank
(E) None of these
Ans : (B)
17. As per provision made in Bharat Nirman Programme the pace of creation of irrigation facilities is
required to be raised from present level of 1.42 million hectare per year in such a way so that it can
achieve the target level fixed for the same?
(A) 1.50 million hectares / year
(B) 1.75 million hectares / year
(C) 2.00 million hectares / year
(D) 2.25 million hectares / year
(E) 2.50 million hectares / year
Ans : (D)
18. Inflation has become major area of concern in India these days. What measures do the Govt. of
India / RBI normally take to control the same?
(1) Fixation of Maximum Price of the Commodities
(2) System of Dual prices.
(3) Increased in supply of food grains.
(4) Control on credit and liquidity in market.
(A) Only 1
(B) Only 2
(C) Only 3
(D) Only 2, 3 & 4
(E) All 1, 2, 3 & 4
Ans : (D)
19. How much Education Cess is being levied on all the taxes to support elementary education for the

children of age group of 6-14 years under Sarva Shiksha Abhiyan (SSA)?
(A) 0.50%
(B) 0.75%
(C) 1.00%
(D) 1.50%
(E) 2.00%
Ans : (E)
20. Which of the following is / are correct about various concessions given in the Union Budget for
2008-09?
(1) Five years tax holidays for setting up hospitals in Tier II & Tier III regions for providing health care
in rural areas.
(2) Commodities tax transaction to be introduced.
(3) Banking cash transaction tax withdrawn.
(A) Only 1
(B) Only 2
(C) Only 3
(D) Only 2 & 3
(E) All 1, 2 & 3
Ans : (E)
21. Which of the following statements reflects the aim(s) Jawaharlal Nehru National Urban Renewal
Mission (JNNURM)?
(1) Give focused attention to integrated development of infrastructure in selected cities.
(2) Provide basic services to the urban poors
(3) Scale up civic amenities and provision of utilities in urban areas.
(A) Only 1
(B) Only 2
(C) Only 3
(D) All 1, 2 & 3
(E) None of these
Ans : (D)
22. The Press Freedom Day is observed on which of the following days?
(A) 1st May
(B) 1st June
(C) 3rd May
(D) 3rd June
(E) 10th June
Ans : (C)
23. As per the decision taken by the Govt. of India now the National Rural Employment Guarantee Act
is extended to all the districts of India. This means : it will now be applicable to about—
(A) 200 districts
(B) 300 districts
(C) 400 districts
(D) 500 districts
(E) 600 districts
Ans : (E)

24. As per the reports published by the Ministry of Finance recently the overseas borrowings by the
Corporates and currency fluctuation has gone up by which of the following percentage points? About—
(A) 1%
(B) 2%
(C) 3%
(D) 4%
(E) 5%
Ans : (C)
25. The Govt. of India and Reserve Bank of India is planning to set up an autonomous "ATM
corporation of India" in which various banks can get together for common ATM operations. If this
happens how will we all be benefited by the same?
(1) It will be a cost effective measure as each bank can share its operational cost with others.
(2) Clients can withdrawn money from any ATM from any location. They are not required to go to their
banks' ATM only.
(3) It will indirectly help the IT business also as India has a large pool of IT skilled manpower waiting
for suitable placement.
(A) Only 1
(B) Only 2
(C) Both 1 & 2
(D) All 1, 2 & 3
(E) None of these
Ans : (C)
26. As per the news published in various newspapers the Govt. of India has decided to create a
Strategic Reserve of—
(A) Oil & Petroleum
(B) Rasoi Gas
(C) Food grains
(D) Cement & Steel
(E) None of these
Ans : (C)
27. The Govt. of India had constituted a high level committee on financial sector reforms with
Raghuram G.Rajan as its Chairman. Which of the following is / are the recommendations of the
committee?
(1) Liberalize the interest rate that banks/institution can charge to ensure credit for poors.
(2) Create an office of the Ombudsman exclusively for financial sector.
(3) Do not allow foreign investors in domestic stock markets.
(A) Only 1
(B) Only 2
(C) Only 3
(D) Both 1 & 2
(E) None of these
Ans : (E)
28. Yves Leterme has taken over as the prime minister of—
(A) Newzealand

(B) Belgium
(C) Croatia
(D) Portugal
(E) None of these
Ans : (B)
29. The State Bank of India recently opened its 10000th branch in Puduvayal (Tamil Nadu). Only a
bank in China has more branches than State Bank of India in the world. What is the name of that
Chinese bank?
(A) Shanghai Commercial Bank
(B) Bank of China
(C) China Banking Corporation
(D) Industrial and Commercial Bank of China
(E) None of these
Ans : (D)
30. Many a times we read about 'Globalization' and its impact on business practice in India. Which of
the following is NOT one of the important parameters of 'Globalization'?
(1) Reduction of trade barriers to permit free flow of goods and services amongst various nations.
(2) Developing an environment in which free flow of capital can take place.
(3) Promoting local industry to cater to the needs of the consumers in Tier II and Tier III cities. The
production from metros should be reserved only for exports.
(A) Only 1
(B) Only 2
(C) Only 3
(D) All 1,2 & 3
(E) Both 2 & 3
Ans : (D)
31. Many times we read a term CBS used in banking operation. What is the full form of the letter 'C' in
the term 'CBS'?
(A) Core
(B) Credit
(C) Continuous
(D) Complete
(E) None of these
Ans : (A)
32. As per news published in newspapers the Oil & Natural Gas Commission (ONGC) has purchased
some oil assets in Latin American Countries along with one other major company of India . What is the
name of that company?
(A) Hindustan Petroleum Corporation
(B) Indian Oil Corporation
(C) Reliance Industries Ltd.
(D) National Mineral Development Corporation of India
(E) None of these
Ans : (E)
33. India's First centre to monitor climate change was opened recently at—

(A) New Delhi
(B) Chennai
(C) Jaipur
(D) Bangalore
(E) Kolkata
Ans : (B)
34. Which of the following Acts was framed specially to deal more effectively with the problem of
Non-Performing Assets in banking system?
(A) SARFAESI ACT.
(B) Banking Regulation Act.
(C) Foreign Exchange Management Act.
(D) Industrial Dispute Act.
(E) None of these
Ans : (A)
35. The————shows all the websites and pages that you have visited over a period of time.
(A) status bar
(B) task bar
(C) history list
(D) tool bar
(E) None of these
Ans : (C)
36. A proxy server is used for the which of the following?
(A) To provide security against unauthorized users
(B) To process client requests for web pages
(C) To process client requests for database access
(D) To provide TCP/IP
(E) None of these
Ans : (A)
37. A repair for a known software bug,usually available at no charge on the internet, is called a(n)—
(A) version
(B) Patch
(C) Tutorial
(D) FAQ
(E) None of these
Ans : (B)
38. In the Higher Education the portion lebelled http is the—
(A) host
(B) domain name
(C) protocol
(D) top-level domain
(E) None of these
Ans : (C)
39. Which of the following organizations has recently given a US$ 600 million loan to Power Grid

Corporation of India,a Govt. run organization?
(A) Asian Development Bank
(B) World Bank
(C) International Monetary Fund
(D) Bank of America
(E) None of these
Ans : (B)
40. The ability to easily add additional users meAns : that a network is—
(A) Scalable
(B) dedicated
(C) Decentralized
(D) Secure
(E) None of these
Ans : (A)
41. In a database, a field is a—
(A) lable
(B) table of information
(C) group of related records
(D) category of information
(E) None of these
Ans : (C)
42. The number of pixels displayed on a screen is known as the screen—
(A) resolution
(B) colour depth
(C) refresh rate
(D) viewing size
(E) None of these
Ans : (A)
43. Wor processing , spreadsheet , and phoyo-editing are example of—
(A) application software
(B) system software
(C) operating system software
(D) platform software
(E) None of these
Ans : (A)
44. If you wish to extend the length of the network without having the signal degrade, you would use a
—
(A) repeater
(B) router
(C) gateway
(D) switch
(E) None of these
Ans : (A)

45. A————is approximately a million bytes.
(A) gigabyte
(B) kilobyte
(C) megabyte
(D) terabyte
(E) None of these
Ans : (C)
46. The time it takes a device to locate data and instructions and make them available to CPU is known
as—
(A) clock speed
(B) a processing cycle
(C) CPU speed
(D) access time
(E) None of these
Ans : (D)
47. ——————controls the way in which the computer system functions and provides a means : by
which users are interact with the computer.
(A) The platform
(B) The operating system
(C) Application software
(D) The motherboard
(E) None of these
Ans : (B)
48. ——————meAns : that the data contained in a database is accurate and reliable.
(A) Data redundancy
(B) Data integrity
(C) Data reliability
(D) Data consistency
(E) None of these
Ans : (B)
49. A(n) —————— is aprivate corporate network,used exclusively by company employees.
(A) Internet
(B) local area network
(C) peer-to-peer
(D) intranet
(E) None of these
Ans : (B)
50. A characteristic of a file server is which of the following?
(A) Manages file operations and is shared on a network
(B) Manages file operations and is limited to one PC
(C) Acts as fat client and is shared on a network
(D) Acts as fat client and is limited to one PC
(E) None of these
Ans : (A)

Tell me from where I can get SBI IT Specialist Officers Exam model Question paper???

[Quick Sam]

You need State Bank of India IT Specialist Officers Exam model Question paper, I am giving here:

In SQL, which of the following is not a data Manipulation Language Commands?
Delete
Select
Update
Create
None of the above
The value for an attribute or a column are drawn from a set of values known as –
Tuples
Attributes
Domain
Column
None of these
Entities having primary key are called
Primary Key
Strong entities
Weak entities
Primary Key
None Of these
Which of the following is not a type of SQL statement?
Data Manipulation Language (DML)
Data Definition Language (DDL)
Data Control Language (DCL)
Data Communication Language (DCL)
None of these
Which of the following is not included in DML (Data Manipulation Language)
INSERT
UPDATE
DELETE
CREATE
None of these
TRUNCATE statement in SQL is a –
DML statement
DDL statement
DCL statement
DSL statement
None of these
To discard all pending data changes
COMMIT
ROLLBACK
SAVEPOINT
LOCK
None of these
Which of the following term is related to the stack?
TOP
PUSH
POP
Rear
A, B and C.
In Queues, the end from where items inserted is called
Rear
Front
Top
Base
None of these
Which protocol is used for browsing website:
TCP
FITFP
FTP
TFTP
None of these
Which of the following is a browser?
Netscape Navigator
Mosaic
Mozilla Firefox
Google chrome
All of these
Black Box Testing sometime called –
Data flow testing
Loop testing
Behavioral testing
Graph based testing
None of these
The Objective of testing is
Debugging
To uncover errors
To gain modularity
To analyze system
None of these
Choose the right sequence of SDLC (Software development life cycle) steps
Design, Requirement Analysis, Coding, Testing
Requirement Analysis, Design, Coding, Testing
Requirement Analysis, Design, Testing, Coding
Requirement Analysis, Coding, Design, Testing
None of these
The drawback of the binary tree sort are remedied by the
Linear Sort
Quick Sort
Heap Sort
Insertion Sort
All of these
Round robin scheduling is essentially the preemptive version of
FIFO
Shortest job first
Shortest remaining
Longest time first
None of these
____ is the situation in which a process is waiting on another process, which is also waiting on another process which is waiting on the first process. None of the processes involved in this circular wait are making progress.
Deadlock
Starvation
Dormant
All of these
None of these
Assembly language is a _____
Low Level Language
Middle Level Language
High level Language
User Language
None of these
Which of the following is a type of translator?
Assembler
Compiler
Interpreter
All of the Above
None of these
Multiprogramming systems ___
Are easier to develop than single programming
Execute each job faster
Execute more jobs in the same time
Are used only on large main frame computers
None of these
The mechanism by which the data and functions are bound together with an
Inheritance
Encapsulation
Abstraction
Polymorphism
None of these
The OSI model consists of ___layers.
Nine
Eight
Seven
Five
Eleven
Decryption & Encryption of data are the responsibility of the ___ layer.
Physical
Data link
Presentation
Session
Application
LANs can be connected by devices called ____ which operate in the data link layer?
Hub
Bridges
HDLC
Tunnel
None of these
In a ____ topology, if there are n devices in a network, each device has n-1 ports for cable.
Mesh
Star
Bus
Ring
None of these
OLAP applications are widely used by ____ and it uses ____ Schema.
RDBMS , Bus
Operating System ,Star
Java , Bus
Data mining Techniques; Star or multidimensional
None of these
Arrange the following in increasing order of their size.
Database<File<Record<Field<Byte<Bit
Bit<Byte<Field<Record<File<Database
Bit>Byte>Record>Field>File>Database
Bit>Byte>File>Record>Field>Database
JVM is a virtual machine that can execute ___
C language
.net programming
RDBMS
C++ Language
Java byte Code
ODBC is based on ___.
Structured Query Language.
C language
C++ language
.net
None of these
Which of the following is not an advantage of the data-base approach?
Increased security
Elimination data redundancy
Ability to associate related data ‘
Programming/data independence
All of the above
In relational database row and column is called as ____and ____respectively.
Tuple; Attribute
Attribute; Tuple
Tupple;Domain
Attribute; Domain
None of these
To delete a particular column in a relation the command used is:
DELETE
UPDATE
DROP
ALTER
None of these
A primary key if combined with a foreign key creates
Parent-Child relationship between the tables that connect them.
Many to many relationship between the tables that connect them.
Network model between the tables that connect them.
All of the above
None of the above
Which of the following is record based logical model?
Network Model
Object oriented model
E-R Model
All of these
None of these
The full form of DDL is
Dynamic Data Language
Detailed Data Language
Data Definition Language
Data Derivation Language
All of these
Which of the following virus overtake computer system when it boots and destroy in-formation?
Trojan
System infectors
Boot infectors
Stealth virus
None of these
The relational model includes two general integrity rules. Integrity rule 1 is concerned with ____ and integrity rule 2 is concerned with ____
Primary Key, Foreign key
Primary Key, composite key
Unique key, Foreign key
Composite Key, Foreign key
None of these
____ is person who has the central control over both data and application programs.
System engineer
Database administrator
Database manager
Technical analyst
None of these
An attribute of a relation that references the primary key of another relation is known as the ____
Foreign Key
Unique Key
Parent key
Child key
Index key
An entity set that does not have sufficient attributes to form a primary key is a
strong entity set
weak entity set
simple entity set
primary entity set.
None of these
The JDBC-ODBC bridge is
Three tiered
Multithread
Best for any platform
All of these
None of these
In a relational database, this is a data structure that organizes the information about a single topic into row and columns.
Block
Record
Tuple
Table
None of these
Which statements about the Java language are true?
Java supports both procedural and object-oriented programming
Java is only a procedural language.
Java is only an Object-Oriented.
Java is related to
None of the above.
Stack is also called ____
First In First Out (LIFO)
Last In First Out (FIFO)
First In Last Out (FILO)
First Come First Served (FCFS)
None of the above
The index created by primary key column is called _____
Unique Index
Composite Index
Single Index
Primary index
None of these
In SQL ,which command(s) is(are) used to remove rows from a table.
Delete
Remove
Truncate
Both
and (3)
None of the above
In SQL, the CREATE TABLE is used
To create a table, defining its columns, integrity constraints, and storage allocation
To add a column/integrity constraint to a table.
To redefine a column
To change a table’s storage characteristics
All of the above
What is the abbreviation is used for a software package that permits the user to create , retrieve and maintain records in a database?
DASD
CRMD
DBMS
All of these
None of the above
Choose the right sequence of virus stages -
Triggering, Damage ,Dormancy, propagation
Damage, Triggering ,Dormancy, propagation
Damage, Triggering, propagation ,Dormancy
Triggering, Damage, propagation, Dormancy
Dormancy, Propagation,. Triggering, Damage
In SQL, which command is used to add new rows to a table?
Alter Table
Add row
Insert
Append
None of the Above