COMPUTER KNOWLEDGE PRACTICE QUESTIONS

1. A process of preparing a floppy diskette for use is called ........
1) assembling
2) translating
3) parsing
4) formatting
5) None

2. Which of the following refers to the memory in your computer?
1) RAM
2) DSL
3) USB
4) LAN
5) CPU

3. Information travels between components on the motherboard through .....
1) Flash memory
2) CMOS
3) Bays
4) Buses
5) Peripherals

4. A program that enables you to perform calculations involving rows and columns of numbers is called as .........
1) spreadsheet program
2) word processor
3) graphics package
4) window
5) None of the above

5. What is a file?
1) A file is a section of main storage used to store data
2) A file is a collection of information that has been given a name and is stored in secondary memory
3) A file is the part of a program that is used to describe what the program should do
4) A file is another name for floppy disk
5) None of the above

6. Applications are often referred to as .........
1) data files
2) executable files
3) system software
4) the operating system
5) None of the above

7. How many options does a binary choice offer?
1) None
2) One
3) Two
4) It depends on the amount of memory in the computer
5) It depends on the speed of the computer’s processor

8. Data going into the computer is called .......
1) Output
2) Algorithm
3) Input
4) Calculations
5) Flowchart

9. How many values can be represented by a single byte?
1) 4
2) 16
3) 64
4) 256
5) 512

10. A prescribed set of well-defined instructions for solving mathematical problems is called......
1) a compiler
2) a code
3) a description
4) an algorithm
5) None of the above

11. Transformation of input into output is performed by ..........
1) Peripherals
2) Memory
3) Storage
4) The Input-Output unit
5) The CPU

12. For creating a document, you use .......... command at File Menu.
1) Open
2) Close
3) New
4) Save
5) None of these

13. What is equipment used to capture information and commands?
1) Output device
2) Input device
3) Storage device
4) Telecommunication device
5) None of these

14. A ..... contains specific rules and words that express the logical steps of an algorithm.
1) programming language
2) programming structure
3) syntax
4) logic chart
5) None

15. The physical components of a computer system ........
1) software
2) hardware
3) ALU
4) control unit
5) None of the above

16. Device drivers are ..........
1) Tiny power cords for external storage devices
2) Experts who know how to maximize the performance of devices
3) Small, special-purpose programs
4) The innermost part of the operating system
5) Substitutes for operating system

17. PC stands for ..........
1) Personal Comprehension
2) Personal Computing
3) Personal Computer
4) Personal Calculations
5) None of the above

18. You cannot link Excel worksheet data to a Word document ........
1) with the right drag method
2) with the hyperlink
3) with the copy and paste special commands
4) with the copy and paste buttons on the standard commands
5) All of these

19. Date and Time are available on the desktop at ........
1) Taskbar
2) My Computer
3) Recycle Bin
4) Only (2) and (3)
5) None of these

20. When you are working on a document on a PC, where is the document temporarily stored?
1) RAM
2) ROM
3) The CPU
4) Flash memory
5) The CD-ROM

21. The blinking symbol on the computer screen is called the ........
1) Mouse
2) Logo
3) Hand
4) Palm
5) Cursor

22. When cutting and pasting, the item cut is temporarily stored in ............
1) ROM
2) Hard drive
3) Diskette
4) Dashboard
5) None of these

23. A CD-ROM disk ..........
1) cannot be erased and rewritten
2) has more storage capacity than a CD-R
3) holds less data than a floppy disk
4) can be written to only once
5) None of the above

24. What is the main folder on a storage device called?
1) Platform
2) Interface
3) Root Directory
4) Home Page
5) None of the above

25. Compatibility in regard to computers refers to .........
1) the software doing the right job for the user
2) it being versatile enough to handle the job
3) the software being able to run on the computer
4) software running with other previously installed software
5) None of the above

26. How is it possible that both programs and data can be stored on the same floppy disk?
1) A floppy disk has two sides, one for data and one for programs
2) Programs and data are both software, and both can be stored on any memory device
3) A floppy disk has to be formatted for one or for the other
4) Floppy disks can only store data, not programs
5) None of the above

27. Output which is made up of pictures, sounds, and video is called .............
1) COM
2) hard copy
3) graphics
4) multimedia
5) None

28. Storage device found inside the computer...
1) CD-ROM
2) Zip Disk
3) Super Disk
4) Hard Disk
5) None of the above

29. The computer monitor is which type of device?
1) Input
2) Output
3) Processing
4) Software
5) None of the above

30. The two major categories of software include ...........
1) operating system and utility
2) personal productivity and system
3) system and application
4) system and utility
5) None of these

31. The smallest unit of information a computer can understand and process is known as a ...........
1) digit
2) kilobyte
3) bit
4) byte
5) None of the above

32. RAM is .............. and ..............
1) volatile, temporary
2) nonvolatile, permanent
3) nonvolatile, temporary
4) volatile, permanent
5) None

33. Which is not an item of hardware?
1) An MP3 file
2) A keyboard
3) A monitor
4) A mouse
5) None

34. The primary output device for computers is a ...........
1) video monitor
2) printer
3) keyboard
4) mouse
5) None of the above

35. A directory within a directory is called ........
1) Mini Directory
2) Junior Directory
3) Part Directory
4) Sub Directory
5) None of the above

36. Deleted data remains on a disk until ........
1) the data is overwritten
2) the recycle bin is emptied
3) a file compression utility is used
4) the disk is scanned
5) None

37. Computers send and receive data in the form of ............ signals.
1) Analog
2) Digital
3) Modulated
4) Demodulated
5) All of these

38. To take information from one source and bring it to your computer is referred to as...
1) upload
2) download
3) transfer
4) de-link
5) None of these

39. Each box in a spreadsheet is called a .......
1) cell
2) empty space
3) record
4) field
5) None of these

40. A field that uniquely identifies which person, thing, or event the record describes is a ....
1) file
2) data
3) field
4) key
5) None of these

41. Most World Wide Web pages contain commands in the language .......
1) NIH
2) URL
3) HTML
4) IRC
5) FTP

42. ................ are graphical objects used to represent commonly used application.
1) GUI
2) Drivers
3) Windows
4) Application
5) Icons

43. Which of the following operating systems is not owned and licensed by a company?
1) Unix
2) Linux
3) Windows 2000
4) Mac
5) Windows

44. If you are going to a site you use often, instead of having to type in the address every time, you should ......
1) save it as a file
2) make a copy of it
3) bookmark it
4) delete it
5) None

45. You click at B to make the text ........
1) Italics
2) underlined
3) Italics and underlined
4) Bold
5) None of these

46. Microcomputer hardware consists of three basic categories of physical equipment ......
1) keyboard, monitor, hard drive
2) system unit, input/ output, memory
3) system unit, input/ output, secondary storage
4) system unit, primary storage, secondary storage
5) None of these

47. A program that works like a calculator for keeping track of money and making budgets ..........
1) calculator
2) scholastic
3) keyboard
4) spreadsheet
5) None of these

48. The ability to find an individual item in a file immediately .......
1) sequential access
2) file allocation table
3) direct access
4) directory
5) None

49. Magnetic tape is not practical for applications where data must be
quickly recalled because tape is ......
1) A random-access medium
2) A sequential-access medium
3) A read-only medium
4) Fragile and easily damaged
5) An expensive storage medium

50. You can start Microsoft Word by using button ........
1) New
2) Start
3) Program
4) Control Panel
5) None

ANSWERS:
1-4, 2-1, 3-4, 4-1, 5-2, 6-2, 7-3, 8-3, 9-5, 10-4
11-5, 12-3, 13-2, 14-1, 15-2, 16-4, 17-3, 18-5, 19-1, 20-1
21-5, 22-5, 23-4, 24-3, 25-3, 26-2, 27-4, 28-4, 29-2, 30-3
31-3, 32-1, 33-1, 34-1, 35-4, 36-1, 37-2, 38-2, 39-1, 40-5
41-3, 42-5, 43-1, 44-3, 45-4, 46-2, 47-4, 48-3, 49-5, 50-2

COMPUTER AWARENESS PRACTICE MCQs FOR BANK EXAMS

1. ______ printer is used for fax machines.
a) Line
b) Dot matrix
c) Laser
d) Inkjet
e) Thermal

2. What does AMD stands for?
a) Advanced Mainframe Devices
b) Advanced Micro Devices
c) Advanced Mini Devices
d) Advanced Monitor Devices
e) Advanced Major Devices

3. _______ provides electronic data interchange facility.
a) ISDN
b) LAN
c) VAN
d) CAN
e) DAN

4. Language based on graphics for use in education is called
a) PROLOG
b) LOGO
c) COBOL
d) BASIC
e) PASCAL

5. When a picture or other graphic image is placed in the report header section it will appear____
a) Once in the beginning of the report
b) At the top of every page
c) Every after record break
d) On the 1st and last pages of the report
e) None of these

6. Query design window has two parts. The upper part shows
a) Name of fields, field type and size
b) Tables with fields and relationships between tables
c) Criteria
d) Sorting check boxes
e) None of these

7. To create a new table, in which method you don’t need to specify the field type and size?
a) Create table in Design View
b) Create Table using wizard
c) Create Table by Entering data
d) All of above
e) None of these

8. Which of the following is not a database object?
a) Tables
b) Queries
c) Relationships
d) Reports
e) None of these

9. Which of the field has width 8 bytes?
a) Memo
b) Number
c) Date/Time
d) Hyperlink
e) None of these

10. When you add fields in ____, a Field List pane displays.
a) Design View
b) Layout View
c) Print Preview
d) Report View
e) None

11. Which of the following is NOT possible when printing Forms?
a) Print page 1, 3 and 5
b) Print pages 1 through 5
c) Print selected records
d) Print only the third record
e) None

12. Which of the following database object produces the final result to present?
a) Forms
b) Reports
c) Queries
d) Tables
e) Cells

13. What is the maximum length a text field can be?
a) 120
b) 255
c) 265
d) 75
e) 65

14. The most popular commercial DBMS.
a) Microsoft SQL Server
b) Microsoft Access
c) MySQL d) Oracle
e) All of the above

15. What is the keyboard shortcut to move to the last records in a table?
a) [Tab]
b) [Shift]+[Tab]
c) [Ctrl]+Home]
d) [Ctrl]+[End]
e) None of these

16. The process of checking the validity of information held in a transaction file is
a) Verification
b) Test data
c) Validation
d) Updating
e) None of these

17. Which of the following is not a function of the control unit?
a) Read instructions
b) Execute instructions
c) Interpret instructions
d) Direct operations
e) None of these

18. Software for organizing storage and retrieval of information is a(n)______.
a) Operating system
b) Database
c) Database program
d) Data warehouse
e) None of these

19. SUM (B1:B8) is an example of a ______
a) Function
b) Formula
c) Cell address
d) Value
e) None of these

20. What is the difference between a CD-ROM and a CD-RW?
a) They are the same; just two different terms used by different manufacturers
b) A CD-ROM can be written to and a CD-RW cannot
c) A CD-RW can be written to, but a CD-ROM can only be read from
d) A CD-ROM holds more information than a CD-RW
e) None of these

21. Documents converted to______ can be published to the Web.
a) .doc file
b) Http
c) Machine language
d) HTML
e) None of these

22. All are included in removable media except the following:
a) CD-ROMs
b) Diskette
c) DVDs
d) High disk drive
e) None of these

23. Straight and Uniform margins on both the sides indicate that there is ______ in the document
a) Full justification
b) Full alignment
c) Left justification
d) Right justification
e) None of these

24. A person need to design invitation card. What type of computer program is suitable?
a) MS-Word
b) Desktop Publishing
c) Simulation
d) Accounting
e) None of these

25. To select or unselect one word to the right
a) CTRL+SHIFT
b) CTRL+SHIFT+ Up Arrow
c) CTRL+SHIFT+ Down Arrow
d) CTRL+SHIFT+ Right Arrow
e) None of these

26. To maximise or restore a selected window.
a) CTRL+ F7
b) CTRL+ F10
c) CTRL+ F8
d) CTRL+ F9
e) None of these

27. _______ is the functional key to display save-as box
a) F5
b) F6
c) F9
d) F12
e) None of these

28. To copy a picture of the selected window to the clipboard.
a) ALT+TAB
b) CTRL+TAB
c) ALT+ Print screen
d) Both a and b
e) None of these

29. A compiler in computing means
____ .
a) A programmer
b) Aperson who compiles source program
c) Keypunch operator
d) A gaming software
e) Aprogram which translates source program into object program

30. The digital telecommunication term ISDN is an abbreviation for _______
a) Internet Services Data Network
b) International Services Digital Network
c) Integrated Services Digital Network
d) Interactive Standard Dynamic Networks
e) Integrated Standard Digital Networks

31. How to specify cell range from A10 to A25 in MS Excel?
a) (A10-A25)
b) (A10 to A25)
c) (A10:A25)
d) (A10.A25)
e) (A10 A25)

32. A result of a computer virus cannot lead to ______
a) Disk crash
b) Mother Board Credits
c) Corruption of programs
d) Deletion of files
e) None of the above

33. Which of the following storage media provides sequential access only?
a) Floppy disk
b) Magnetic disk
c) Magnetic tape
d) Optical disk
e) None of the above

34. What is the other name of LAN Card?
a) MODEM
b) Network connector
c) Internet card
d) NIC
e) None of the above

35. _______ is known as father of World Wide Web.
a) Robert Cailliau
b) Tim Thompson
c) Charles Darwin
d) Tim Berners-Lee
e) None of these

36. What type of information should you avoid including on your Web site?
a) Links to sites of interest
b) Private personal information
c) Work and academic experience
d) Graphical
e) None of these

37. Which of the following web elements should you know about before building your web site?
a) The web audience
b) The operating environment of your ISP
c) The operating system of your visitor
d) Each consideration should determine your web design choices
e) None of these

38. Which of the following is best suitable for remote administration of a computer?
a) Telnet
b) WAIS
c) Browsers
d) HTML
e) None of these

39. If you wanted to create text that was a different color or font than other text in your Web page, what type of tag would you use?
a) Layout
b) Basic formatting
c) Design
d) Outline
e) None of these

40. When creating a Web document, what format is used to express an image's height and width?
a) Centimeters
b) Pixels
c) Dots per inch
d) Inches
e) None of these

Answers:
1) e; 2) b; 3) c; 4) b; 5) a; 6) b; 7) c; 8) c; 9) c; 10) b;
11) a; 12) d; 13) d; 14) b; 15) b; 16) c; 17) d; 18) c; 19) b; 20) c;
21) d; 22) d; 23) a; 24) b; 25) d; 26) b; 27) d; 28) c; 29) e; 30) c;
31) c; 32) b; 33) a; 34) d; 35) d; 36) b; 37) a; 38) a; 39) b; 40) b.

COMPUTER KNOWLEDGE PRACTICE QUESTIONS FOR ALL BANK EXAMS

1. Which of the following is not a logical database structure?
1) Chain
2) Network
3) Tree
4) Relational
5) All of the above

2. Which of the following is not a standard MS office Edition?
1) CE
2) Advanced
3) Standard
4) Professional
5) None of these

3. Which device is used as the standard pointing device in a Graphical User Environment?
1) Keyboard
2) Mouse
3) Joystick
4) Track ball
5) All of the above

4. Which of the following is not a part of standard office suit?
1) File Manager
2) Image Editor
3) Database
4) Word Processor
5) None of these

5. Which of the following is a programming language for creating special programs like applets?
1) Java
2) Cable
3) Domain name
4) Net
5) Cobol

6. An online discussion group that allows direct "live" communication is known as ___
1) WebCrawler
2) Chat group
3) Regional service provider
4) Hyperlink
5) E-mail

7. The other name of motherboard is:
1) Chip sheet
2) Computer board
3) System device
4) Central board
5) System board

8. The basic goal of the computer process is to convert data into ___
1) Graphs
2) Tables
3) Files
4) Data
5) Information

9. To restart the computer which of the following combination of keys used?
1) Del + Ctrl
2) Backspace + Ctrl
3) Ctrl + Alt +Del
4) Insert +Esc
5) Esc +Ctrl

10. The storage devices used to compensate for the difference in rates of flow of data from one device to another is termed as ___
1) Chip
2) Channel
3) Floppy
4) Call
5) Buffer

11. Which of the following companies is a leader in manufacture of Hard Disk Drives?
1) Samsung
2) IBM
3) Fujitsu
4) Seagate
5) Moratala

12. DSL is an example of a(n) ____ connection.
1) Network
2) Wireless
3) Slow
4) Cable
5) Broadband

13. ____ is data that has been organized or presented in a meaningful fashion.
1) A process
2) Software
3) Storage
4) Information
5) Hard ware

14. ____ is a set of computer programs used on a computer to help perform tasks.
1) An instruction
2) Software
3) Hardware
4) Memory
5) A processor

15. Any part of the computer that you can physically touch is called as ___
1) Hardware
2) Software
3) A device
4) A peripheral
5) An application

16. Which of the following is not available on the Ruler of MS Word screen?
1) Tab stop box
2) Left Indent
3) Right Indent
4) Center Indent
5) All of these are available on ruler

17. ___ is the section of the CPU that selects, interprets and sees to the execution of program instructions.
1) Memory
2) Register unit
3) Control unit
4) ALU
5) System unit

18. Which was the world's first minicomputer and when was it introduced?
1) PDP-I, 1958
2) IBM System/36, 1960
3) PDP-II, 1961
4) VAX 11/780, 1962
5) PDP-I, 1963

19. Which of the following is a software package to implement a data base?
1) System analysis
2) DBMS
3) Database
4) DASD
5) File analysis

20. The permanent memory built into your computer is called ___
1) ROM
2) CD-ROM
3) RAM
4) CPU
5) Mother board

21. What is a portion of a document in which you set certain page formatting options?
1) Page
2) Document
3) Section
4) Page Setup
5) Page layout

22. The term "push" and "pop" is related to the:
1) Array
2) Lists
3) Stacks
4) All of the above
5) None of these

23. www is based on which model?
1) Local server
2) Client server
3) 3 tier
4) World server
5) User server

24. Which of the following is not a domain name extension?
1) .mil
2) .org
3) .int
4) .com
5) All of the above

25. Which of the following TCP/IP protocol is used for transferring electronic mail messages from one machine to another?
1) FTP
2) SNMP
3) SMTP
4) RPC
5) HTTP

26. A processor that collects the transmissions from several communications media and sends
them over a single line that operates at a higher capacity is called?
1) Multiplexor
2) Bridge
3) Hub
4) Router
5) None of these

27. Which of the following is used for manufacturing chips?
1) Control bus
2) Control unit
3) Parity unit
4) Semiconductor
5) Process unit

28. ____ defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
1) Instance
2) Schema
3) Program
4) Super Key
5) Code

29. To produce high-quality graphics (hardcopy) in color, you would use a(n):
1) RGB monitor
2) Plotter
3) Ink-jet printer
4) Laser printer
5) All of the above

30. What component would most likely cause a "parity error"?
1) Bad hard disk
2) Bad controller
3) Bad RAM
4) Bad software
5) Bad OS

31. _____ transforms one interface into another interface.
1) Software
2) Program
3) Data
4) File
5) Code

32. A URL can specify the IP address of the web ____ that houses a Web page?
1) server
2) client
3) page
4) user
5) e-mail recipient

33. The three basic categories of connection to the internet include all EXCEPT?
1) Direct connection
2) Dial-up
3) Broadband
4) Direct satellite
5) None of these

34. Hundreds of Universities, Government entities and Research labs have formed ____.
1) Internet
2) www
3) Internet2
4) TCP/IP
5) Intranet

35. Which of the following is not an example of hard ware?
1) Scanner
2) Printer
3) Mouse
4) Monitor
5) Interpreter

36. A computer program that translates one program instructions at a time into machine language is called a/an ____
1) Interpreter
2) CPU
3) Compiler
4) Simulator
5) RAM

37. What is the name of the display feature that highlights are of the screen which requires operator attention?
1) Pixel
2) Reverse video
3) Touch screen
4) Cursor
5) Note pad

38. The first digital computer built with IC chips:
1) IBM 7090
2) Apple - 1
3) VAX-10
4) Dell-1
5) IBM System / 360

39. Which of the following case does not exist in complexity theory?
1) Best case
2) Worst case
3) Average case
4) All cases
5) Null case

40. Which of the following American Computer Company is called big blue?
1) Microsoft
2) Compaq Corp
3) IBM
4) Tandy Stevenson
5) Samsung

ANSWERS:
1) 1; 2) 2; 3) 2; 4) 1; 5) 1; 6) 2; 7) 5; 8) 3; 9) 3; 10) 5;
11) 4; 12) 5; 13) 4; 14) 2; 15) 1; 16) 4; 17) 3; 18) 1; 19) 2; 20) 1;
21) 3; 22) 3; 23) 2; 24) 3; 25) 3; 26) 1; 27) 4; 28) 2; 29) 2; 30) 3;
31) 1; 32) 1; 33) 4; 34) 3; 35) 5; 36) 1; 37) 2; 38) 5; 39) 5; 40) 3

COMPUTER KNOWLEDGE PRACTICE MCQs

1. If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate the feature?
1) Point to Speech on the Tool menu, and then click Show Text To Speech Toolbar.
2) Click validation on the data menu.
3) Point to speech on the tools menu, and then click speech recognition.
4) All of the above
5) None of these

2. ...... are a type of inexpensive digital camera that remains tethered to a computer and are used for video conferencing, video chatting and live web broadcast.
1) Webcams
2) Webpicks
3) Browser cams
4) Browser pics
5) None

3. Which of the following statements is true?
1) To insert link in Ms Excel, Ctrl + K is used.
2) One can edit selected cell in Excel by pressing the F2 key.
3) Shift + space is used to select the entire row in Excel.
4) Ctrl + space is used to select the entire column in Excel.
5) All 1), 2), 3) and 4) are true

4. For multiple selection in any file system you have..
1) Radio button
2) Local area network
3) Notification area
4) Yes/ No box
5) None

5. A(n) ...... is a private corporate network used exclusively by company employees.
1) Internet
2) Local area network
3) Peer-to-peer
4) Intranet
5) None

6. Which of the following is the characteristic of a file server?
1) It manages file operations and is shared on a network.
2) It manages file operations and is limited to one PC.
3) It acts as fat client and is shared on a network.
4) It acts as fat client and is limited to one PC.
5) None of these

7. The && and operators.........
1) compare two numeric values
2) combine two numeric values
3) combine two Boolean values
4) All the above
5) None of these

8. Advantage of X.25 network is that...
1) frame delivery is more reliable
2) frames are delivered in order
3) flow control is provided
4) All the above
5) None of these

9. A ........ is a pre-designed document that already has co-ordinating fonts, a layout, and
a background.
1) guide
2) model
3) ruler
4) template
5) None of these

10. An output device that lets you see what the computer is doing is called....
1) a disk drive
2) monitor screen
3) shift key
4) printer
5) None of these

11. Computer's hard disk is....
1) an arithmetic and logical unit
2) computer software
3) operating system
4) computer hardware
5) None of these

12. To make a notebook act as a desktop model, the notebook can be connected to a ...... which
is connected to a monitor and other devices.
1) bay
2) docking station
3) port
4) network
5) None of these

13. Each cell in a Microsoft Office Excel document is referred to by its cell address, which
is the...
1) cell's column label
2) cell's column label and worksheet tab menu
3) cell's row
4) cell's row and column labels
5) None

14. The secret code that restricts entry to some programs is called.....
1) password
2) passport
3) entry-code
4) access-code
5) None of these

15. ...... is a field that uniquely identifies which person, thing or event the record describes
1) File
2) Data
3) Folder
4) Key
5) None

16. The .... directory is mandatory for every disk.
1) Root
2) Base
3) Sub
4) Case
5) None of these

17. You must install a ..... on a network if you want to share a Broadband Internet connection.
1) router
2) modem
3) node
4) cable
5) None of these

18. This can be another word of a program...
1) software
2) disk
3) floppy
4) hardware
5) None of these

19. First Technopark in India is in....
1) Bangalore
2) Kolkata
3) Thiruvananthapuram
4) Delhi
5) None

20. The simultaneous processing of two or more programs by a multiple processor is known as
1) Multiprogramming
2) Multitasking
3) Time sharing
4) Multiprocessing
5) None of these

ANSWERS:

1-1, 2-1, 3-5, 4-2, 5-4, 6-1, 7-3, 8-4, 9-4, 10-2
11-4, 12-2, 13-4, 14-1, 15-4, 16-1, 17-1, 18-1, 19-3, 20-4

COMPUTER KNOWLEDGE PRACTICE MCQs FOR ALL BANK EXAMS

1. Which of the following condition is used to transmit two packets over a medium at the same time?
1) Contention
2) Collision
3) Synchronous
3) Asynchronous
5) None of the above

2. Which of the following is not an option of the spelling dialog box?
1) Ignore
2) Ignore all
3) Edit
4) Change
5) Select

3. Four bits are used for packet sequence numbering in a sliding window protocol used in a computer network. What is the maximum window size?
1) 4
2) 8
3) 16
4) 15
5) 32

4. A message with replies on a newsgroup is often called a _____
1) post
2) list
3) thread
4) comment
5) format

5. Which of the following network is used to connect a number of computers to each other by cables in a single location?
1) WAN
2) LAN
3) GAN
4) PAN
5) MAN

6. News servers utilize _____ to distribute documents to readers.
1) NNTP
2) NEWS
3) HTTP
4) FTP
5) HTML

7. The Software which contains rows and columns is called ___
1) Database
2) Drawing
3) Word processing
4) Spreadsheet
5) All the above

8. Addresses separate the user name from the ISP using the ____ symbol.
1) &
2) @
3) %
4) *
5) $

9. The ___ layer provides a well defined service interface to the network layer, determining how the bits of the physical layer are grouped into frames
a) Data Link
b) Physical
c) Network
d) Session
e) MAC

10. The spelling tool is placed on ___ toolbar
1) Standard
2) Formatting
3) Drawing
4) Reviewing
5) Viewing

11. The maximum size of the window in a Sliding Window Protocol is _____
1) 2m + 1
2) 2m
3) 2(m-1)
4) 2m*1
5) 2m - 1

12. A name in the ____ name space is a sequence of characters without structure
1) address
2) oman
3) flat
4) Both a and b
5) location

13. Which of the following is not a valid Zoom percentage in Excel?
1) 10
2) 100
3) 300
4) 500
5) 750

14. Distance Vector Routing is a ____ routing algorithm; it consists of a data structure called a ____
1) Static, routing table
2) Dynamic, look-up table
3) Dynamic, routing table
4) Static, look-up table
5) dynamic, less table

15. What is the short cut key to replace a data with another in sheet?
1) Ctrl + R
2) Ctrl + Shift + R
3) Ctrl + H
4) Ctrl + F
5) Ctrl + V

16. The ___ protocol is based on end-toend delivery.
1) SCTP
2) TCP
3) SMTP
4) SCTP
5) HTTP

17. If you need to change the typeface of a document, which menu will you choose?
1) Edit
2) View
3) Tools
4) File
5) Format

18. What is the size of Network bits & Host bits of Class A of IP address?
1) Network bits 7, Host bits 24
2) Network bits 8, Host bits 24
3) Network bits 7, Host bits 23
4) Network bits 8, Host bits 23
5) Network bits 4, Host bits 25

19. ____ is a uniform naming scheme for locating resources on the web.
1) URI
2) HTTP
3) WEBNAME
4) RESOURCENAME
5) URL

20. The options like Relationship, SQL Server etc. are found in ___
1) External data tab
2) Database tools tab
3) Create tab
4) Home tab
5) Format tab

21. A Database Language Concerned with the Definition of the Whole Database Structure and Schema is ____
1) DCL
2) DML
3) DDL
4) DCO
5) DDI

22. A ____ Enables You To View Data From A Table Based On A Specific Criterion
1) Form
2) Query
3) Macro
4) Report
5) Bug

23. A____ normal form normalization will be needed where all attributes in relation tuple are not functionally dependent only on the key attribute.
1) First
2) Second
3) Third
4) Fourth
5) Fifth

24. An outstanding functionality of SQL is its support for automatic ____ to the target data.
1) programming
2) functioning
3) navigation
4) notification
5) none of these

25. The hardware component used to control the operation of a computer system is:
1) Ram
2) Processor
3) Keyboard
4) Hard disk
5) Monitor

26. Which output device is suited to presenting information that is likely to change very frequently?
1) Sound card
2) Monitor
3) Plotter
4) Printer
5) COM

27. Which is the most difficult environmentally to dispose of?
1) Floppy drives
2) Hard drives
3) Power supplies
4) CRTs
5) System boards

28. Which type of system hoard is the MOST likely candidate for processor upgrading if you want maximum performance and future compatibility?
1) ML
2) PCI
3) ISA
4) EISA
5) ISO

29. Which of the following is a type of preventative maintenance used on a hard drive?
1) Disk check diagnostics
2) Head alignment diagnostics
3) Initializing
4) Uninstalling programs
5) None of the above

30. How many IRQs does a chain of USB devices require?
1) 1
2) 2
3) 3
4) 4
5) 5

31. Which of the following addressing modes, facilitates access to an operand whose location is defined relative to the beginning of the data structure in which it appears?
1) ascending
2) sorting
3) index
4) indirect
5) direct

32. Which command will be used with vi editor to replace text from cursor to right?
1) r
2) R
3) s
4) S
5) Q

33. Which of the following is not a filter?
1) cat
2) grep
3) wc
4) sort
5) None of the above

34. Which of the following commands is used to view your file 24 lines at a time?
1) pg
2) cat
3) //p
4) /p
5) ///p

35. The rise time of a pulse waveform is the time required for the voltage to rise:
1) from zero to its rms value
2) from zero to its peak value
3) from 10% of the peak value to 70.7% of the peak value
4) from 10% of the peak value to 90% of the peak value
5) from 10% of the peak value to 80% of the peak value

36. Holes are the minority carriers in which type of semiconductor?
1) Extrinsic
2) Intrinsic
3) n-type
4) p-type
5) m-type

37. While working with MS-DOS, which command is used to restore files that were backed up using the BACKUP command?
1) COPY
2) DISKCOPY
3) RESTORE
4) STORE
5) DELETE

38. Which of the following commands will take you directly to the root directory no matter what subdirectory you are currently in?
1) CD \root
2) CD\
3) CD\..
4) CD..
5) CD\\..

39. Batch files contain a group of MSDOS commands that are run in successive order. What filename extension identifies batch files?
1) COM
2) BAT
3) EXE
4) SYS
5) DOC

40. The _____ command allows you to modify the default prompt to provide other information
1) prompt
2) windows
3) cursor
4) click
5) double click

ANSWERS:
1) 2; 2) 3; 3) 4; 4) 3; 5) 5; 6) 1; 7) 4; 8) 2; 9) 1; 10) 1 ;
11) 5; 12) 3; 13) 4; 14) 3; 15) 3; 16) 3; 17) 5; 18) 1; 19) 1: 20) 2;
21) 3; 22) 2; 23) 3; 24) 3; 25) 2; 26) 2; 27) 4; 28) 2; 29) 1; 30) 1;
31) 3; 32) 2; 33) 5; 34) 1; 35) 4; 36) 3; 37) 3; 38) 2; 39) 2; 40) 1;

COMPUTER AWARENESS PRACTICE QUESTIONS

1. Which of the following translate back from machine code something resembling the source language?
1) Interpreter
2) Compiler
3) Assembler
4) Decompiler
5) None of the above

2. When you are working on a document on Computer, which location the document temporarily stored?
1) RAM
2) ROM
3) The CPU
4) Flash memory
5) The CD-Rom

3. The latest PC keyboards use a circuit that senses the movement by the change in its capacitance.
What are these keyboards called?
1) Mechanical keyboards
2) Capacitance keyboards
3) Qwerty keyboards
4) Dvorak keyboards
5) None of these

4. Transformation of data into information is performed by which of the following....
1) Peripherals
2) Memory
3) Storage
4) The Input-Output unit
5) The CPU

5. ....... is collection of web pages and ....... is the very first page that we see on opening of a web-site.
1) Home-page, Web-page
2) Web-site, Home-page
3) Web-page, Home-page
4) Web-page, Web-site
5) None of these

6. Which of the following registers is used to keep track of address of the memory location where the next instruction is located?
1) Memory Data Register
2) Memory Address Register
3) Instruction Register
4) Program Counter
5) None of these

7. What tab is selected to cut, copy, and paste?
1) Insert
2) Tools
3) Special
4) Home
5) None of these

8. The most important or powerful computer in a typical network is .......
1) Network Desktop
2) Network client
3) Network server
4) Network Station
5) None of these

9. Which kind of devices allows the user to add components and capabilities to a computer system?
1) System boards
2) Expansion slots
3) Input devices
4) Output devices
5) Storage devices

10. To what temporary area can you store text and other data, and later paste them to another location?
1) The clipboard
2) ROM
3) CD-ROM
4) The hard disk
5) None of these

11. ....... is the science that attempts to produce machines that display the same type of intelligence that humans do.
1) Nanoscience
2) Nanotechnology
3) Simulation
4) Artificial intelligence (AI)
5) None of these

12. Computers use the ........ number system to store data and perform calculations.
1) Decimal
2) Hexadecimal
3) Octal
4) Binary
5) None of these

13. A device mounted on a communication satellite which receives, amplifies and re-transmits signals from earth station is ....
1) Transponder
2) Track
3) Transistor
4) Terminal
5) None of these

14.To move to the ending of a page of text, press the ...... key.
1) End
2) A
3) Page-up
4) Enter
5) None of these

15. A ...... contains specific rules and words that express the logical steps of an algorithm.
1) Syntax
2) Programming structure
3) Programming language
4) Logic chart
5) None of these

16. ........ tells the computer how to use its components.
1) Utility
2) Network
3) Operating system
4) Application program
5) None of these

17. What is data backup?
1) Adding more components to your network
2) Protecting data by copying it from the original source to a different destination
3) Filtering old data from the new data
4) Accessing data on tape
5) None of these

18. This component is required to process data into information and consists of integrated circuitry.
1) Hard disk
2) RAM
3) CPU
4) ROM
5) None of these

19. Who was the father of Punched Card Processing?
1) Dr. Herman Hollerith
2) J Presper Eckert
3) Charles Babbage
4) Blaise Pascal
5) None of these

20. Computers that are portable and convenient for users who travel are known as....
1) Super computers
2) Laptops
3) Mini computers
4) File servers
5) None of these

21. Office LANs that are spread geographically apart on a large scale can be connected using a corporate .......
1) CAN
2) LAN
3) DAN
4) WAN
5) TAN

22. What is the process of copying software programs from secondary storage media to the hard disk called?
1) Configuration
2) Download
3) Storage
4) Upload
5) Installation

ANSWERS:
1-4, 2-1, 3-2, 4-5, 5-2, 6-4, 7-4, 8-3, 9-2, 10-1
11-4, 12-4, 13-1, 14-1, 15-3, 16-3, 17-2, 18-3, 19-1, 20-2, 21-4, 22-5

COMPUTER KNOWLEDGE FOR BANK EXAMS

1. A firewall is ........
1) A software program
2) A virus program
3) A Hardware
4) All the above
5) Only 1 and 3

2. Which of the following memory can be erased using Ultra Violet Rays?
1) RAM
2) ROM
3) PROM
4) EPROM
5) EEPROM

3. Which of the following is an input device which is used with interactive graphics to locate a place on the screen?
1) Bus
2) Modem
3) Magnetic Tape
4) Mouse
5) Scanner

4. Retrieval of information from a computer is called:
1) Output
2) Input
3) Data
4) Information
5) Processing

5. GUI is the acronym for:
1) Generation User Interface
2) General User Interface
3) Graphical User Instruction
4) Graphical User Interface
5) None of these

6. Internal Memory in a Central Processing Unit Comprises of which of the following?
1) Bus
2) A set of ALUs
3) A set of registers
4) Ward disk memory
5) All of these

7. Which of the following is a file in computer?
1) Hard disk
2) Magnetic Drum
3) Floppy disk
4) Portable Document Format
5) None of these

8. Which of the following terms is associated with the computers processing speed?
1) MIPS
2) FCFS
3) MPEG
4) TIFF
5) None of these

9. The smallest storage unit in a computer is...
1) Nibble
2) Byte
3) Bit
4) Word
5) None of these

10. Which function calculates the average of a given set of numbers in Excel?
1) Min
2) Max
3) Count
4) Avg
5) Sum

IBPS CLERKS CWE COMPUTER KNOWLEDGE PRACTICE MCQs

1. Ubuntu is an example of which kind of Source Model?
1) Open Source
2) Vertical Market Software
3) Horizontal Market Software
4) Shareware
5) None of these

2. ..... is a computer program that fills the screen with moving images or patterns when the computer is not in use.
1) Wallpaper
2) Computer Screen
3) Screen Saver
4) Both 1 and 3
5) None of these

3. Which of the following is a valid unit of measurement of Bandwidth?
1) Data Per second
2) Information Per second
3) Bits Per second
4) All the above
5) None of these

4. Which of the following is true about Intranet?
1) It is a Private Network
2) It is a Public Network
3) It is a Network which can access illegally.
4) Only 1 and 3
5) None of the above

5. The process of loading an Operating System into main memory is called:
1) Formatting
2) Posting
3) Booting
4) Partitioning
5) None of the above

6. Line by line translation of a program is done by:
1) Interpreter
2) Translator
3) Compiler
4) All the above
5) None of these

7. SQL is a:
1) Programming Language
2) Communication Language
3) Low-level language
4) Query Language
5) None of the above

8. Network of Networks is known as :
1) Intranet
2) Internet
3) Extranet
4) VPN
5) MAN

9. Which of the following is true about Java?
1) It is an OOP language
2) It is Platform Independent
3) It provides more security
4) It was Designed by Sun Microsystems.
5) All the above

10. The process of replacing a software with a newer version is called:
1) Upgrading
2) Installing
3) Updating
4) Downloading
5) Replacing

COMPUTER KNOWLEDGE PRACTICE QUESTIONS

1. Which of the following is most essential for effective multimedia presentations incorporates user participation or ....
1) Links
2) Buttons
3) Interactivity
4) Integration
5) None

2. Most of the websites have moving graphics, which are called as:
1) animations
2) vectors
3) links
4) morphs
5) None

3. Which of the following is the term used to enlarge a window to its maximum area so that it fills the entire desktop?
1) Maximize
2) Zoom
3) Enlarge
4) Extend
5) None of these

4. Microsoft Windows and Apple Mac are widely used Operating systems in today's world. Which of the following feature makes them so popular?
1) Multitasking Capacity
2) Calligraphy
3) User-friendly GUI
4) Being Inexpensive
5) None of these

5. Physical components of a computer are called:
1) Hardware
2) Software
3) Viruses
4) Internet
5) None of these

6. Which of the following is an object oriented feature:
1) Structured Programming
2) Multi-Tasking
3) Linking
4) Inheritance
5) None of these

7. In Windows XP, which of the following views is the best to see the file size and modified dates of all files in a folder.
1) List
2) Icon
3) Thumbnails
4) Details
5) None of these

COMPUTER KNOWLEDGE PRACTICE QUESTIONS

1.          A Passive threat to computer security is-
        (1) Malicious Intent              

(2) Sabotage

(3) Accidental Errors             

(4) Espionage Agents

(5) None of these

2.          ____ allows wireless mobile devices to access the Internet and its services such as the Web and e-mail.

(1) TCP/IP                                  

(2) Ethernet

(3) WAP                                     

(4) Token ring

(5) None of these

3.          ‘DOS’ floppy disk does not have____.

(1) A Boot Record                  

(2) A File Allocation Table

(3) A Root Directory              

(4) Virtual Memory

(5) BIOS

4.          ‘MICR’ technology used for clearance of cheques by banks refers to ____.

(1) Magnetic Ink Character Recognition

(2) Magnetic Intelligence Character Recognition

(3) Magnetic Information Cable Recognition

(4) Magnetic Insurance Cases Recognition

(5) None of these

5.          All the information collected during database development is stored in a ____.

(1) repository                          

(2) data warehouse

(3) RAD                                      

 (4) CASE

(5) None of these

6.          The ____ component is used by the data analyst to create the queries that access the database.

(1) data extraction                 

(2) end-user query tool

(3) end-user presentation tool

(4) data store                           

(5) None of these

7.          The altering of data so that it is not usable unless the changes are undone is ____.

(1) Biometrics                         

 (2) Compression

(3) Encryption                          

(4) Ergonomics

(5) None of these

8.          The word FTP stands for-

(1) File Transfer Protocol   

 (2) File Transit Protocol

(3) File Typing Protocol        

(4) File Transfer Protocol

(5) None of these

9.          This ____ tier processes HTTP protocol, scripting tasks, performs calculations, and provides access to data.

(1) Client                   

(2) Applications/Web server

(3) Enterprise server            

(4) DBA

(5) None of these

10.      A DVD-RAM is similar to a ____, except it has storage capacities up to 5.2 GB.

(1) CD-R                                     

(2) Floppy disk

(3) CD-RW                                 

(4) Hard disk

(5) None of these

11.      All of the following are basic principles of networks, except-

(1) each computer must have a network card

(2) there must be communications media connecting the network hardware devices

(3) there must be at least one connecting device

(4) each computer must have software that supports the movement of information

(5) None of these

12.      ____ are used to identify a user who returns to a Website.

(1) Cookies                               

(2) Plug-ins

(3) Scripts                                  

(4) ASPs

(5) None of these

13.      If you wanted to locate the hardware address of a local device, which protocol would you use?

(1) ARP                                       

(2) RARP

(3) ICMP                                    

(4) PING

(5) PONG

14.      The term, ‘hypertext’ means-

(1) Non-sequential writing 

(2) Hypermedia

(3) Blinking text     

(4) Text with heavy formatting

(5) None of these

15.      Which kind of lock includes a keypad that can be used to control access into areas?

(1) Cipher                                  

(2) Warded

(3) Device                                  

(4) Tumbler

(5) Type lock

16.      What is the name of protocol used in eliminate loops?

(1) Switching                            

(2) ISL

(3) Frame tagging                  

 (4) Spanning Tree Protocol

(5) None of these

17.      In networking terminology UTP means –

(1) Unshielded Twisted Pair

(2) Ubiquitous Teflon Port

(3) Uniformly Terminating Port

(4) Unshielded T-Connector

(5) None of these

18.      In OSI network architecture, the dialogue control and token management are responsibility of-

(1) Session layer                     

(2) Network layer

(3) Transport layer                 

(4) Data link layer

(5) None of the above

19.      A ‘C’ data structure called a structure is a group of items in which each item is identified by its own identifier, each of which is known as a member of a structure. Member is also known as-

(1) Information                       

(2) Field

(3) Record                                 

(4) Data type

(5) None of these

20.      Multithread means-

(1) Program do more than one thing at a time

(2) More than one program do one thing at a time

(3) Both are correct               

(4) Both are incorrect

(5) None of these

21.      A page fault occurs?

(1) when the page is not in the memory

(2) when the page is in  the memory

(3) when the process enters the blocked state

(4) when the process is in the ready state

(5) None of these

22.      “Each packet contains the full source and destination address.” This statement indicates which of the following?

(1) Virtual Circuit                    

(2) Datagram

(3) Data link                              

(4) FDDI

(5) None of these 

23.      Data bus is-

(1) Unidirectional                   

(2) Bidirectional

(3) Both (1) & (2)                   

 (4) Multidirectional

(5) None of these

24.      Which of the following is a type of ISDN (Integrated Service Digital Network)?

(1) Narrow bank                     

(2) Broad band

(3) Both (1) & (2)                    

(4) Virtual Circuit

(5) None of these 

25.      Which of the following is a browser to view a web page?

(1) Mosaic                                 

(2) Netscape

(3) Internet Explorer           

(4) All of the above

(5) None of these

26.      A graph is a collection of-

(1) Row and columns            

(2) Vertices and edges

(3) Equations                           

(4) Identity

(5) None of these

27.      CDMA is used in-

(1) Wireless and local loop

(2) Allocating a wireless channel

(3) Both (1) & (2)                    

(4) Local loop

(5) None of these

28.      Number of arcs incident to a node is called its-

(1) Level                                     

(2) Predecessor

(3) Degree                                                

(4) Successor

(5) None of these

29.      OSPF means-

(1) Open shortest path finite protocol

(2) Open shortest path finite protocol

(3) Open slotted path finite protocol

(4) Open slotted path first protocol

(5) None of these

30.      Binding the same name to multiple operations whose signatures differ in number or types of arguments?

(1) Overloading                       

(2) Origin class

(3) Object model                    

(4) Package

(5) None of these

31.      What is the name of the chip which has more than one processor on it?

(1) Parallel chip                       

(2) Multi-processor chip

(3) Transputer                         

(4) Parallel processor

(5) None of these

32.      In windows-

(1) Docking views may be docked

(2) Docking views may be float

(3) Docking views may be docked or float

(4) All of the above                               

(5) None of these

33.      ____ performs relocations function?

(1) Absolute loader               

(2) Direct linking loader

(3) Relocating loader            

(4) Linkage editor

(5) None of these

34.      A central computer surrounded by one or more satellite computers is called a-

(1) Bus network                      

(2) Ring network

(3) Star network                     

(4) All of the above

(5) None of these

35.      Segmentation –

(1) is a memory management scheme that supports user view of memory

(2) logical address space is collection of segments

(3) logical address consists of two tuple < segment-number, offset>.

(4) All of the above                               

(5) None of these 

36.      Which of the following is a major component of the telephone system?

(1) Local loop                           

(2) Trunks

(3) Switching office                               

(4) All of these

(5) None of these 

37.      Function is invoked by-

(1) Function                             

(2) Declaration

(3) Definition                           

(4) Prototype

(5) None of these

38.      The ACCEPT command in SQL?

(1) Creates a customized prompt when accepting user input

(2) Explicitly defines a NUMBER or DATE data type variable

(3) Hides user input for security reasons

(4) All of the above

(5) None of these

39.      How many fields are required to represent a header node of a graph?

(1) 3                                             

(2) 2

(3) 4                                             

(4) 5

(5) None of these

40.      Which of the following is not used as a data structure?

(1) Array                                    

(2) Linked list

(3) Graph                                   

(4) Directory

(5) None of these 

41.      Which of the following is an operating system call?

(1) CREATE                                                

(2) LINK

(3) SYSTEM                               

(4) All of these

(5) None of these

42.      In C++, by default, the members of a class are-

(1) Public                                   

(2) Private

(3) Both public and private 

(4) Only Public

(5) None of these

43.      In core banking systems:

(1) Store and forward of transaction is done

(2) Branch server is not required

(3) Local database is not required

(4) Transaction cannot happen from a non-home branch

(5) None of these 

44.      MV command in Unix changes-

(1) Only the directory

(2) Only the directory entry and i-node

(3) Only the i-node number

(4) All of the above                               

(5) None of these

45.      E-Commerce refers to-

(1) Electrical commerce       

(2) Electronic commerce

(3) Evolutionary commerce              

(4) Effective commerce       

(5) None of these

46.      Graphs can be implemented using-

(i) Arrays    (ii) Linked list      (iii) Stack              (iv) Queue

(1) (i), (ii) and (iv)                   

(2) (i), (ii) and (iii)

(3) (ii) and (iii)                          

(4) (i) and (iv)

(5) None of these

47.      Thrashing-

(1) Always occur on large computers

(2) is a natural consequence of virtual memory systems

(3) Can always be avoided by swapping

(4) Can be caused by poor paging algorithm

(5) None of these

48.      The process of converting analog signals into digital signals so they can be processed by a receiving computer is referred as-

(1) modulation                        

(2) demodulation

(3) synchronizing                    

(4) digitizing

(5) None of these

49.      The relational database environment has all of the following components except-

(1) Users                                    

(2) Separate files

(3) Database                            

(4) Database administrator

(5) None of these

50.      Primary key-

(1) Denote a candidate key that is chosen by the database designer as the principal means of identifying entities with in an entity set

(2) Attributes names of all primary key are unique

(3) Primary key specification is optional and good idea to specify primary key for each relation

(4) All of the above                              

 (5) None of these

Answers:

1	1	11	4	21	1	31	3	41	4
2	3	12	1	22	2	32	2	42	2
3	5	13	1	23	2	33	3	43	1
4	1	14	2	24	3	34	3	44	1
5	1	15	1	25	4	35	4	45	2
6	2	16	4	26	2	36	4	46	4
7	3	17	3	27	3	37	1	47	4
8	4	18	1	28	3	38	4	48	4
9	2	19	2	29	1	39	1	49	2
10	3	20	1	30	1	40	4	50	4