State Bank of India Clerical Cadre Recruitment Exam 2008 Solved Paper

State Bank of India Clerical Cadre Recruitment Exam 2008 Solved Paper

Marketing Aptitude / Computer Knowledge

161. Cross-selling covers—
(A) Identifying customer needs
(B) Matching the Products to customer needs
(C) Convincing the customers of Product benefits
(D) Responding to questions and objections of customers
(E) All of these
162. A Prospect means—
(A) Any customer who walks into the Bank
(B) An employee of the Bank
(C) A customer who is likely to be interested in Bank's Product or service
(D) A Depositor of the Bank
(E) A Borrower of the Bank
163. A Lead means—
(A) A Prospect who is more likely to avail of the Bank's Product
(B) A Political Leader
(C) A Religious Leader
(D) A Bank Chairman
(E) None of these 164. Innovation means—
(A) Compensation
(B) Inspiration
(C) Additional perquisites
(D) Implementing new ideas or new methods
(E) None of these
165. A Call means—
(A) Calling on friends
(B) Calling on Bank employees
(C) Calling on Prospective customers
(D) To make telephone calls
(E) Calling on relatives
166. The Traditional Marketing style involves—
(A) Telemarketing
(B) Digital Marketing
(C) Indirect Marketing
(D) Direct Marketing
(E) All of these
167. Modern methods of Marketing include—
(A) Publicity on the net
(B) Advertisement on the net
(C) Soliciting business through e-mails
(D) Telemarketing
(E) All of these
168. A true marketing mindset requires—
(A) Command and order mindset
(B) Control mindset
(C) Active mindset
(D) Passive mindset
(E) None of these
169. Which of the following sentences is True ?
(A) Marketing is not required in a Buyers' Market
(B) Marketing is not required in a Sellers' Market
(C) Marketing is not required due to globalization
(D) Marketing is not required due to competition
(E) Marketing is not required due to liberalization
170. For effective marketing, the salesmen should have which of these qualities—
(A) Creativity
(B) Team spirit
(C) Motivation
(D) Effective communication skills
(E) All of these
171. Market information means—
(A) Knowledge of shops and bazaars
(B) Knowledge of shopping malls
(C) Knowledge of customer profile and product mix
(D) Knowledge of various languages
(E) None of these
172. Market Research is needed for—
(A) Deciding the market area
(B) Deciding the right product to be sold
(C) Making proper marketing decisions
(D) Deciding right time to sell
(E) All of these
173. Which of the following statements is True ?
(A) Marketing makes the Company to go into loss due to higher expenses
(B) Marketing is not required in profit-making companies
(C) Marketing sharpens the minds of the employees
(D) Marketing is a time-bound seasonal function
(E) Marketing is a waste of time
174. Marketing Plan helps in—
(A) Better lead generation
(B) Better systems
(C) Better results
(D) Improved Balance Sheet
(E) Better customer service
175. If Marketing is done effectively, which of the following is not required—
(A) Advertisement
(B) Publicity
(C) Market Research
(D) Market Segmentation
(E) None of these
176. Motivation means—
(A) Inspiring employees to perform better
(B) Better Communication Skills
(C) Sales coaching
(D) Market Research
(E) None of these
177. In a Selling Process in today's world—
(A) Only standard products are sold
(B) No customization required
(C) The Seller need not have product knowledge
(D) The Seller should aim at customer satisfaction
(E) Only quantum of sales matters
178. Find the True statement—
(A) Marketing is a waste of the employees' time
(B) Marketing is not required in India due to its vast population
(C) Marketing involves additional work
(D) Marketing involves team work
(E) Marketing is not required today due to IT advancement
179. A Target Market is—
(A) Entire country
(B) Entire city
(C) Entire globe
(D) That which consists of customers who need the identified product
(E) All of these
180. Sales forecasting involves—
(A) Sales Planning
(B) Sales pricing
(C) Distribution Channels
(D) Consumer tastes
(E) All of these
181. How many options does a binary choice offer ?
(A) None
(B) One
(C) Two
(D) It depends on the amount of memory in the computer
(E) It depends on the speed of the computer's processor
182. Data going into the computer is called—
(A) Output
(B) Algorithm
(C) Input
(D) Calculations
(E) Flowchart
183. How many values can be represented by a single byte ?
(A) 4
(B) 16
(C) 64
(D) 256
(E) 512
184. Transformation of input into output is performed by—
(A) Peripherals
(B) Memory
(C) Storage
(D) The Input-Output unit
(E) The CPU
185. Device drivers are—
(A) Tiny power cords for external storage devices
(B) Experts who know how to maximize the performance of devices
(C) Small, special-purpose programs
(D) The innermost part of the operating system
(E) Substitutes for operating system
186. A collection of programs that controls how your computer system runs and processes information is called—
(A) Operating system
(B) Computer
(C) Office
(D) Compiler
(E) Interpreter
187. Which of the following refers to a small, single-site network ?
(A) LAN
(B) DSL
(C) RAM
(D) USB
(E) CPU
188. A set of instructions telling the computer what to do is called—
(A) Mentor(B) Instructor
(C) Compiler(D) Program
(E) Debugger
189. If you receive an e-mail from someone you don't know, what should you do ?
(A) Forward it to the police immediately
(B) Delete it without opening it
(C) Open it and respond to them saying you don't know them
(D) Reply and ask them for their personal information
(E) Reply and tell them you want to keep in touch with them
190. Which of the following can handle most system functions that aren't handled directly by the operating system ?
(A) Vertical-market applications
(B) Utilities
(C) Algorithms
(D) Integrated software
(E) Compilers
191. Microsoft Office is—
(A) Shareware
(B) Public-domain software
(C) Open-source software
(D) A vertical-market application
(E) An application suite
192. Computers connected to a LAN (Local Area Network) can—
(A) Run faster
(B) Go on line
(C) Share information and/or share peripheral equipment
(D) E-mail
(E) None of these
193. Which of the following refers to the memory in your computer ?
(A) RAM
(B) DSL
(C) USB
(D) LAN
(E) CPU
194. Information travels between components on the motherboard through—
(A) Flash memory (B) CMOS
(C) Bays (D) Buses
(E) Peripherals
195. One megabyte equals approximately—
(A) 1,000 bits
(B) 1,000 bytes
(C) 1 million bytes
(D) 1 million bits
(E) 2,000 bytes
196. When you are working on a document on a PC, where is the document temporarily stored ?
(A) RAM
(B) ROM
(C) The CPU
(D) Flash memory
(E) The CD-ROM
197. How are data organized in a spreadsheet ?
(A) Lines and spaces
(B) Layers and planes
(C) Height and width
(D) Rows and columns
(E) None of these
198. Magnetic tape is not practical for applications where data must be quickly recalled because tape is—
(A) A random-access medium
(B) A sequential-access medium
(C) A read-only medium
(D) Fragile and easily damaged
(E) An expensive storage medium
199. The blinking symbol on the computer screen is called the—
(A) Mouse
(B) Logo
(C) Hand
(D) Palm
(E) Cursor
200. When cutting and pasting, the item cut is temporarily stored in—
(A) ROM
(B) Hard drive
(C) Diskette
(D) Dashboard
(E) Clipboard
Answers 161.(B) 162. (C) 163. (A) 164. (D)
165.(C) 166. (C) 167. (E) 168. (A)
169.(B) 170. (E) 171. (C) 172. (E)
173.(E) 174. (E) 175. (B) 176. (A)
177.(D) 178. (D) 179. (D) 180. (E)
181.(C) 182. (C) 183. (E) 184. (E)
185.(D) 186. (B) 187. (A) 188. (D)
189.(B) 190. (A) 191. (E) 192. (C)
193.(A) 194. (D) 195. (C) 196. (A)
197.(D) 198. (E) 199. (E) 200. (E)

SBI CLERK COMPUTER GENERAL KNOWLEDGE SOLVED PAPER

SBI CLERK COMPUTER GENERAL KNOWLEDGE

1) What does that acronym VGA stand for?
a) Extended Graphics Adapter
b) Enhanced Graphics Array
c) Video Graphics Array
d) Color Graphics Array

2) ISP stands for
a) Internet Service Provider;
b) Information Services Provider;
c) International Services Program;
d) Industrial Services program
3) One KB equals
a) 1000 Bytes;
b) 1000MB;
c) 1024 bytes;
d) 1024 MB
4) LAN means
a) Land Acquisition Notification;
b) Local Area Network;
c) Large Area Network;
d) Low Area Network
5) One MB equals
a) 1000 bytes;
b) 1000GB;
c) 1024 KB;
d) 1024 GB
6) MICR stands for
a) Magnetic Ink Character Recognition;
b) Magnetic Ink Charter Recognition
c) Magnetic Ink Charter Release;
d) Magnetic Ink Character Release
7) The communication equipment used in the computer is
a) CPU
b) MODEM;
c) Monitor
d) Mouse
8) Which of the following is a national net work ?
a) WAN
b) NICNET
c) WWW
d) HTTP
9) Which of the following can be used for Monitors ?
a) LCD
b) LAN
c) PIN
d) SQL
10) BIOS stands for
a) Basic Input Output System
b) Base Input Output System
c) Broad Information Output System
d) Basic Information Operating System
11) Which of the following is used for International Inter Bank Financial Communications?
a) SWIFT
b) CBS
c) WWW
d) SPNS
12) Which of the following not used in the Computers?
a) Key Board
b) Monitor
c) Power (AC/DC)
d) Handle
13) What does CBS mean?
a) Cost Benefit Services;
b) Current Business Services
c) Core Banking Services;
d) Cost of Banking Services
14) Marketing in Banks is the job of
a) Specialized marketing personnel;
b) every employee in the bank;
c) Manager of the bank;
d) Sales associates
15) The rate of interest on Savings Bank Account is stipulated by
a) The concerned bank;
b) RBI;
c) Indian Banks Association;
d) Government of India
16) The rate of interest on Fixed and Investment Deposits is stipulated by
a) The concerned bank;
b) RBI;
c) Indian Banks Association;
d) Government of India
17) The rate of interest on Savings Bank accounts is
a) 3.5 % p.a.;
b) 4%p.a;
c) 4.5% p.a
d) 5%p.a
18) Loan against the security of immovable property is by executing an agreement of
a) Assignment
b) Pledge;
c) Transfer;
d) Mortgage;
19) The regulator of the banking system in India is
a) RBI;
b) Finance Minister;
c) SEBI;
d) IBA
20) Which of the following is a financial asset?
a) Gold;
b) silver;
c) Shares in a demat account;
d) Land & buildings
21) NAV is normally used in respect of schemes floated by
a) Banks;
b) Mutual funds;
c) Insurance Companies;
d) Merchant banker
22) EMI is normally used in respect of which of the following loans?
a) Personal Loans;
b) Home Loans;
c) Consumer Loans;
d) All the above
23) The maximum period for which fixed deposit accounts allowed to be opened in a bank for an individual customer
a) 3 years;
b) 5 years;
c) 10 years;
d) 20 years
24) Zero balance account is generally allowed to be opened for
a) Salaried class;
b) businessmen;
c) foreign customers;
d) children
25) Four Ps of Marketing is also known as
a) Marketing Mix
b) Marketing Concept
c) Marketing environment
d) Marketing strategies

Answers
Q No Ans Q No Ans Q No Ans
1 c 11 a 21 b
2 a 12 d 22 d
3 c 13 c 23 c
4 b 14 b 24 a
5 c 15 b 25 a
6 a 16 a
7 b 17 a
8 b 18 d
9 a 19 a
10 a 20 c

SBI BANK CLERK COMPUTER GENERAL KNOWLEDGE SAMPLE PAPER

SBI CLERK COMPUTER GENERAL KNOWLEDGE

1. Compiler is the
(a) name given to the computer operator
(b) part of the digital machine to store the information
(c) translator of source program to object
(d) part of arithmetic logic unit
(e) operator of Boolean Algebra
Ans (c) 2. Main memory is(a) Random Access Memory (b) Read only Memory
(c) Serial Access Memory (d) None of these
Ans (a)
3. Which of the following is the smallest and fastest computer imitating brain working?
(a) Supercomputer (b) Quantum Computer
(c) Param-10,000 (d) IBM chips
Ans (b)
4. A compact disc (CD) is a data storage of the type
(a) Magnetic (b) Optical (c) Electrical (d) Electromechanical
Ans (a)
5. Which of the following is not as language for computer programming?(a) WINDOWS (b) PASCAL (c) BASIC
(d) COBOL (e) All of these
Ans (a)
6. What are the two basic types of memory that your computer uses?(a) RAM (b) RW/RAM (c) ROM (d) ERAM (e) POST
Ans (a)
7. The term gigabyte refers to
(a) 1024 bytes (b) 1024 kilobytes (c) 1024 megabytes
(d) 1024 gigabytes (e) None of the above
Ans (c)
8. A computer with CPU speed around 100 million instructions per second & with the word length of around 64 bits is known as
(a) Super computer (b) Mini computer (c) Micro computer
(d) Micro computer (e) None of the above
Ans (a)
9. What digits are representative of all binary numbers?
(a) 0 (b) 1 (c) Both (a ) and (b) (d) 3 (e) None of the above
Ans (c)
10. To locate a data items for storage is
(a) Field (b) Feed (c) Database
(d) Fetch (e) None of the above
Ans (d)
11. Off-line operation is the operation of devices without the control of
(a) Memory (b) CPU (c) ALU
(d) Control unit (e) None of the above
Ans (b)
12. A type of line printer that uses an embossed steel band to form the letters printed on the paper is
(a) Golf ball printer (b) Dot-matrix printer
(c) Laser printer (d) Band printer (e) None of the above
Ans (d)
13. A software used to convert source program instructions to object instruction is known as
(a) Compiler (b) Assembler (c) Interpreter
(d) Language processor (e) None of the above
14. The 'IC' chip, used in computers, is made of
(a) Chromium (b) Iron oxide (c) Silica (d) Silicon
Ans (d)
15. Name the first general purpose electronic computer
Ans : UNIVAC
16. The size of commonly used Floppy disk is
(a) 4.5” (b) 3.5” (c) 3.25” (d) 5.5”
Ans (b)
17. Which of the following statement is wrong
(a) Windows XP is an operating system
(b) Linux is owned and sold by Microsoft
(c) Photoshop is a graphical design tool by Adobe
(d) Linux is free and open source software
Ans (b)
18. Operating system of a computer
(a) Enables the programmer to draw a flow chart
(b) Links a program with subroutine with references
(c) Provides a layer, user friendly interface
(d) None of the above
Ans (c)
19. The term ‘Operating System’ means
(a) A set of programs which control computer working
(b) The way a user operates the computer system
(c) Conversion of high level language to machine language
(d) The way computer operator works
Ans (a)
20. Wild card operators specifies
(a) can be used when writing into multiple files
(b) allows several files to be read simultaneously
(c) Provide an easy way of groups of related files
(d) Are only used when printing the contents of a file
Ans (c)
21.Which one of the following is not a broadband communication medium
(a) Microwave (b) Fibre optic cable
(c) Twisted pair (d) Coaxial cable
Ans (c)
22.Which of the following performs modulation and demodulation
(a) Coaxial cable (b) Satellite (c) Modem (d) Optical fibre
Ans (c)
23. Which one of the following is not an application software package
(a) Redhat Linux (b) Microsoft Office
(c) Adobe PageMaker (d) Open Office
Ans (a)
24. Who is the father of computer
Ans : Charles Babbage
25.The function of key F4 is
Ans : To repeat the last action
26.The function of key F4 is
Ans : To repeat the last action
27. The 0 and 1 in the binary numbering system are called binary digits or .......
(a) bytes (b) kilobytes (c) decimal bytes (d) bits (e) nibbles
Ans (D)
28. A monitor's ...... is the distance between the holes in the mask behind the screen. This helps determine how sharp the dots appear.
(a) refresh rate (b) dot pitch (c) resolution
(d) colour depth (e) None of the above
Ans (B)
29. A directly accessible appointment calendar is a feature of a ....... resident package.
(a) CPU (b) memory (c) Buffer (d) ALU (e) None of the above
Ans (B)
30. Perforated paper used as input or output media is known as
(a) Paper tape (b) Magnetic tape (c) Punched paper tape
(d) Card punch (e) None of the above
Ans (A)
31. The invention of the slide rule is attributed to
(a) Babbage (b) Oughtred (c) Pascal
(d) Napier (e) None of the above
Ans (B)
32. Which of the following is not an advantage of magnetic disk storage.
(a) The access time of magnetic disk is much less than that of magnetic tape
(b) Disk storage is longer lasting than magnetic tape
(c) Disk storage is less expensive than tape storage
(d) All of the above
(e) None of the above
Ans (e)
33. The memory sizes in mainframe computers and advanced technology micro computer are expressed as
(a) Bytes (b) Kilo-bytes (c) Bits
(d) Megabytes (e) None of the above
Ans (d)
34. A prefix for billion which is equal to .... is called as billi.
(a) 100 (b) 10000 (c) 1000 (d) 10 (e) None of the above
Ans (d)
35. Each model of a computer has a unique
(a) Assembly language (b) Machine language
(c) High level language (d) All of the above
(e) None of the above
Ans (b)
36. One kilobyte = ____ byte.
(a) 1250 (b) 2088 (c) 1024 (d) 1000
Ans (c)
37. Which of the following circuit is used as a 'Memory device' in computers?
(a) Rectifier (b) Flip-Flop (c) Comparator (d) Attenuator
Ans (b)
38. To move the cursor to the end of the document press
Ans : Ctrl + End
39. In Word Processing the red underline indicates
Ans : Spelling mistakes
40. The shortcut key to print documents is
Ans : Ctrl + P
41. First layer in the OSI reference model is
(a) Data link (b) Network (c) Physical (d) Application
Ans (c)
42. Viruses, Trojan horses and Worms are
(a) able to harm computer system
(b) unable to detect if affected on computer
(c) user-friendly applications
(d) harmless applications resident on computer
Ans (a)
43. Program threats are
(a) Trap doors (b) Trojan horse (c) Both (a) & (b
Ans (b)
44. Failure of passwords security due to exposure can result from
(a) Electronic monitoring (b) Visual (c) Both (a) & (b)
Ans (c)
45. Data security threats include
(a) Hardware failure (b) Privacy invasion
(c) Fraudulent manipulation of data (d) All of the above
Ans (b)
46. The bar which displays information about the current page number is
Ans : Status bar
47. Graphical pictures that represent an object like file, folder etc. are
(a) Task bar (b) Windows (c) Desktop (d) Icons
Ans (d)
48. Who invented the super-computer?
(a) P.T Farnsworth (b) J.R Whinfield
(c) J.H. Van Tassell (d) Charles Ginsberg
Ans (c)
49. Accessing records from a file directly without searching from the beginning of the file is
(a) Time sharing (b) Random
(c) Direct access (d) Access time (e) None of the above
Ans (c)
50. Time during which a job is processed by the computer is
(a) Delay time (b) Real time (c) Execution time
(d) Down time (e) None of the above
Ans (c)

SBI BANK CLERK COMPUTER GENERAL KNOWLEDGE SOLVEDPAPER

SBI CLERK COMPUTER GENERAL KNOWLEDGE

1. Register is a
(a) Set of capacitors used to register input instructions in a digital computer
(b) Set of paper tapes and cards put in a file
(c) Temporary storage unit within the CPU having dedicated or general purpose use
(d) part of the auxiliary memory
(e) device to convert current signal into voltage signal
Ans (c)
2. Errors in computer results could be due to
(a) encoding of data (b) transmission of data
(c) manipulation of data (d) all of the above
(e) none of above
Ans (d)
3. Terminal is a
(a) device used to give supply to a computer
(b) Point at which data may leave or enter the computer
(c) ending point in a program
(d) point where wires are interconnected
(e) an input/output device
Ans (b)
4. A computer programmer
(a) enters data into computer
(b) writes programs
(c) changes flow chart into instructions
(d) provides solutions to complex problems
(e) does total planning and thinking for a computer
Ans (e)
5.Pickup wrong definition
(a) Off line - is a system peripheral equipment not controlled by CPU
(b) Online - is system in which peripheral equipment is in direct contact with CPU
(c) Peripherals - are hardware under the control of CPU, like punched card readers, tapes, drums, disk, output devices
(d) PL/I is the acronym Peripheral Listing /Index
(e) Program or routine is a set sequence of instructions given to computer for problem solving
Ans (d)
6. When a CD (Compact Disc used in audio and Video system) is seen in sunlight, rainbow like colours are seen. This can be explained on the basis of phenomenon of
(a) reflection and diffraction
(b) reflection and transmission
(c) diffraction and transmission
(d) refraction, diffraction and transmission
(e) none of these
Ans (d) Internet is an inter-networking of information from one part of the network to any other provided the information is packed according to certain conventions

7. For reproducing sound, a CD (Compact Disc) audio player uses a
(a) quartz crystal
(b) titanium needle
(c) laser beam
(d) barium titanium ceramic
(e) none of these
Ans (c) LASER stands for Light Amplification by Stimulated Emission of Radiation
8. The memory of a computer is commonly expressed in terms of Kilobytes or Megabytes. A byte is made up of
(a) eight decimal digits (b) eight binary digits
(c) two binary digits (d) two decimal digits (e) none of these
Ans (b) A byte consists of 8 bits—8 binary digits
9. Which of the following circuit is used as a 'Memory device' in computers?
(a) Rectifier (b) Flip-Flop (c) Comparator (d) Attenuator (e) none of these
Ans (b) Flip-flop refers to an electronic component which can adopt one of two possible states -0 or 1. It acts as an electronic switch which gets changed its state when input signals are received
10. Which is/are the main provisions of Information Technology (IT) Act, 2000?
(a) Legal recognition to digital signatures and documents.
(b) Finalisation of contracts through electronic media.
(c) Making hacking with computer system an office.
(d) All of the above
Ans (d)
11. Consider the following statements about Internet facility:
I. It serves as the largest one-line information system.
II. It provides the most dependable and latest mode for sending E-mail.
III. Recurring expenditure on communication E-mail is very high.
IV. It is often misused and has triggered cyber-crimes.
Which of these statements are correct?
(a) I, II and IV (b) I and IV (c) II, III and IV (d) II and III
Ans (a)
12. The computer device primarily used to provide hard copy is the
(a) CRT (b) Line Printer (c) Computer Console (d) Card Reader
Ans (b)
13. The unit of hardware, which an operator uses to monitor computer processing, is the
(a) Card Reader (b) CPU (c) Line Printer (d) Console
Ans (d)
14. Computers can be classified in which of the following hierarchical orders?
(a) PC, Large, Super Micro, Super Computer
(b) Super Micro, PC, Large, Super Computer
(c) PC, Super Micro, Large, Super Computer
(d) Large, Super Micro, Super Computer, PC
Ans (c)
15. Which one of the following is a stored program machine?
(a) Micro-processor (b) Calculator
(c) Analog-computer (d) Micro-computer
Ans (d)
16. First generation computer systems used
(a) Transistors (b) Vacuum tubes
(c) Magnetic cores (d) Silicon chips
Ans (b)
17. Transistors are associated with which computer system?
(a) First generation (b) Fifth generation
(c) Second generation (d) None of these
Ans (c)
18. Charles Babbage invented
(a) ENIAC (b) Difference engine (c) Electronic computer (d) Punched card
Ans (b)
19. Who wrote the book 'Computer Liberation and Dream Machine', the first book on personal computers?
(a) John McCarthy (b) Ted Nelson (c) Niklaus Wirth (d) Karl Capek
Ans (b)
20. Who was the inventor of mechanical calculator for adding numbers?
(a) Charles Babbage (b) Peano (c) Newton (d) Pascal
Ans (D)
21. The most widely used commercial programming computer language is
(a) BASIC (b) COBOL (c) FORTRAN (d) PASCAL
Ans (b) Cobol is abbreviated term for Common Business Oriented Language. It is high level programme language designed to assist the task of programs by enabling them to write programme in more simple manner
22.The brain of a computer is
(a) CPU (b) CD (c) Floppy disc (d) Megabyte
Ans (A) CPU is abbreviated term for Central Processing Unit. It is the principal operating part of a computer
23. Foxpro' is
(a) a medicine (b) a disease (c) a computer language (d) an animal
Ans (C)
24.In computer language, one kilobyte equals
(a) 1000 bytes (b) 1024 bytes (c) 100 bytes (d) 8 bytes
Ans (b) The memory of a computer is commonly expressed in terms of kilobytes
25. Which one of the following is not a programming language of a computer?
(a) BASIC (b) FORTRAN (c) LASER (d) PASCAL
Ans (c)
26.Which of the following packages is used for composition in printing press?
(a) Lotus (b) dBase (c) Page Maker (d) Word Perfect
Ans (c)
27. Which one of the following is not a computer language?
(a) BASIC (b) COBOL (c) LOTUS (d) FORTRAN
Ans (d)
28. The individual within the operations group who ordinarily uses a variety of keyboard devices, is the
(a) Data Clerk (b) Keypunch Operator
(c) Data Entry Clerk (d) Computer Operator
Ans (c)
29. An advantage of a distributed word processing network is
(a) increased number of reports handled
(b) less delay in inter-office communications
(c) greater corporate control over outputs
(d) All of these
Ans (b)
30.The retrieval of information from the computer is defined as
(a) collection of data (b) data retrieval operations
(c) output (d) data output collection
Ans (c)
31. Which of the following terms could be used to describe the concurrent processing of computer programs via CRTs, on one computer system?
(a) Time sharing (b) On-line processing
(c) Interactive processing (d) All of these
Ans (d)
32.The daily processing of corrections to customer accounts best exemplifies the processing mode of
(a) batch processing (b) real-time processing
(c) time-sharing (d) off-line processing
Ans (a)
33. A characteristic of card system is
(a) slowness in processing data
(b) using cards as records of transactions
(c) needing a larger data staff
(d) All of these
Ans (d)
34. Which of the following floppy sizes exists?
(a) 5.25 inches (b) 4.75 inches (c) 6 inches (d) 8 inches
Ans (a)
35. MS-DOS is the name of a/an
(a) Application software (b) Hardware
(c) System software (d) None of these
Ans (c)
36. A peripheral device used in a word processing system is
(a) Floppy disk (b) Magnetic card reader
(c) CRT (d) All of these
Ans (d)
37. A term used interchangeably with diskette is
(a) Disk cartridge (b) Disk pack
(c) Floppy disk (d) Packette disk
Ans (c)
38. An I/O device which provides photographic outputs for printing galleys, is the
(a) Camera printer (b) Automatic typesetter
(c) Radix printer (d) All of these
Ans (d)
39. Which one of the following a file?
(a) Floppy disk (b) Magnetic drum (c) magnetic tape (d) None of these
Ans (d)
40.A decimal equivalent of m second is
(a) 0.000001 sec (b) 1000000 sec (c) 0.001 sec (d) 1000 sec
Ans (a)
41. A characteristic of the ASCII code is
(a) its limitation to a maximum of 96 character configuration
(b) its use of the zone codes 1010, 1011 and 1100
(c) its independence from Hollerith code
(d) All of these
Ans (c)
42. A temporary storage area, attached to the CPU, for I/O operations, is a
(a) Channel (b) Buffer (c) Register (d) Core
Ans (b)
43. The computer code for interchange of information between terminals is
(a) ASCII (b) BCD (c) BCDIC (d) Hollerith
Ans (a)
44. ROM is composed of
(a) Magnetic cores (b) Micro-processors
(c) Photoelectric cells (d) Floppy disks
Ans (b)
45. Which of the following is true?
(a) Plotters are not available for microcomputer systems
(b) Micro-computer are not programmed like conventional computers
(c) Mini-computers are task-oriented
(d) The contents of ROM are easily changed
Ans (c)
46. Magnetic disk a medium known as
(a) Serial access (b) Direct access (c) Sequential access (d) Sequential and rotational access
Ans (b)
47. A dot-matrix printer
(a) is an input-output device (b) is an output device only
(c) is an input device only (d) None of these
Ans (b)
48.An octal number 237 is equal to the binary number
(a) 010 011 111 (b) 010 111 011
(c) 011 101 101 (d) 011 000 001
Ans (c)
49. A term associated with the comparison of processing speed is
(a) FFTS (b) MPG (c) MIPS (d) CPS
Ans (c)
50. The maximum size of a memory addressed by 12 bits is
(a) 1 K bytes (b) 16 K bytes (c) 32 K bytes (d) 4 K bytes
Ans (d)

sbi bank clerk computer based sample questions

1. Database redesign is not terribly difficult if the:
database is structured.
database is well-designed.
database has no data.
database is relatively small.
Ans (3)

2. A regular subquery can be processed:
from the top down.
from the bottom up.
by nesting.
None of the above is correct.

Ans (2)

3. Which of the following SQL statements are helpful in database redesign?
Correlated subqueries only
EXISTS/NOT EXISTS expressions only
Both of the above are helpful
None of the above are helpful.

Ans (3)

4. Which is not true of a correlated subquery?
EXISTS/NOT EXISTS is a form of a correlated subquery.
The processing of the SELECT statements is nested.
They can be used to verify functional dependencies.
They are very similar to a regular subquery.

Ans (4)

5. The EXISTS keyword will be true if:
any row in the subquery meets the condition only.
all rows in the subquery fail the condition only.
both of these two conditions are met.
neither of these two conditions is met.

Ans (1)

6. The NOT EXISTS keyword will be true if:
any row in the subquery meets the condition.
all rows in the subquery fail the condition.
both of these two conditions are met.
neither of these two conditions is met.
Ans (2)

7. How can you find rows that do not match some specified condition?
EXISTS
Double use of NOT EXISTS
NOT EXISTS
None of the above is correct.
Ans (2)

8. Before any changes to database structure are attempted one should first:
clearly understand the current structure and contents of the database only.
test any changes on a test database only.
create a complete backup of the operational database only.
All of the above should be done.

Ans (4)

9. The process of reading a database schema and producing a data model from that schema is known as:
data modeling.
database design.
reverse engineering.
None of the above is correct.

Ans (3)

10. The data model that is produced from reverse engineering is:
1. a conceptual model.
2. an internal model.
3. a logical model.
4. None of the above is correct.

Ans (4)

11. A tool that can help designers understand the dependencies of database structures is a:
dependency graph.
data model.
graphical display.
None of the above is correct.

Ans (1)

12. How many copies of the database schema are typically used in the redesign process?
One
Two
Three
Four

Ans (3)

13 Which SQL-92 standard SQL command can be used to change a table name?
RENAME TABLE
CHANGE TABLE
ALTER TABLE
None of the above is correct.
Ans (4)

14.What SQL command can be used to add columns to a table?
MODIFY TABLE TableName ADD COLUMN ColumnName
MODIFY TABLE TableName ADD ColumnName
ALTER TABLE TableName ADD COLUMN ColumnName
ALTER TABLE TableName ADD ColumnName

Ans (3)

15. What SQL command can be used to delete columns from a table?
MODIFY TABLE TableName DROP COLUMN ColumnName
MODIFY TABLE TableName DROP ColumnName
ALTER TABLE TableName DROP COLUMN ColumnName
ALTER TABLE TableName DROP ColumnName

Ans (3)

16. To drop a column that is used as a foreign key, first:
drop the primary key.
drop the table containing the foreign key..
drop the foreign key constraint.
All of the above must be done.
Ans (3)

17. Which of the following modifications may not succeed?
Changing a column data type from char to date
Changing a column data type from numeric to char
Both of the above actions should succeed.
Neither of the above actions will succeed.

Ans (1)

18. What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);
ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
None of the above is correct.

Ans (3)

19. Changing cardinalities in a database is:
a common database design task.
a rare database design task, but does occur.
a database design task that never occurs.
is impossible to do, so a new database must be constructed and the data moved into it.

Ans (1)


20. Because of the importance of making data model changes correctly, many professionals are __________ about using an automated process for database redesign.
optimistic
skeptical
ambivalent
None of the above is correct.

Ans (2)