SBI Bank PO Solved Question Papers 2011- Computer General Awareness

1. Programs from the same developer, sold bundled together , that provide better integration and share common features , toolbars and menus are known as….

(A) Software suites

(B) Integrated software packages

(C) Software processing packages

(D) personal information managers

(E) None of these

Ans: (A)

2. A data warehouse is which of the following?

(A) Can be updated by the end users

(B) Contains numerous naming conventions and formats

(C) Organized around important subject areas

(D) Contains only current data

(E) None of these

Ans: (C)

3.______________ servers store and manage files for network users.

(A) Authentication

(B) Main

(C) Web

(D) File

(E) None of these

Ans: (D)

4. All of the following are examples of real security and privacy risks Except_____

(A) Hackers

(B) Spam

(C) Viruses

 (D) Identify theft

(E) None of these

Ans: (B)

5.___________ terminals (formerly known as cash registers) are often connected to Complex Inventory and sales computer systems .

(A) Data

(B) Sales

(C) Query

(D) (Point-of-sale (POS)

(E) None of these

Ans: (B)

6. The OSI model is divided into_______ processes called layers.

(A) five

(B) six

(C) seven

(D) eight

(E) None of these

Ans: (C)

7. System software is the set of programs that enables your computer’s hardware devices

and______ software to work together.

(A) Management

(B) Processing

(C) Utility

(D) Application

(E) None of these

Ans: (D)

8.________ are specially designed computer chips reside inside other devices, such as your car or your electronic thermostat.

(A) Servers

(B) Embedded computers

(C) Robotic computers

(D) Mainframes

(E) None of these

Ans: (B)

9. The following are all computing devices, except………

(A) Notebook computers

(B) Cellular telephones

(C) Digital scanners

(D) Personal digital assistants

(E) None of these

Ans: (C)

10. In a ring topology, the computers in possession of the______ can transmit data

(A) packet

(B) data

(C) access method

(D) token

(E) None of these

Ans: (D)

11. This part of operating system manages the essential peripherals, such as the keyboard, screen , disk drives, and parallel and serial ports_ ___

(A) Basic input/output system

(B) Secondary input/output system

(C) Peripheral input/output system

(D) marginal input/output system

(E) None of these

Ans: (A)

12_______ Viruses are often permitted by a floppy disk left in the floppy drive

(A) Trojan horse

(B) Boot sector

(C) Script

(D) Logic bomb

(E) None of these

Ans: (B)

13.________ controls the way in which the computer system functions and provides a me : by which users can interact with the computer

(A) The platform

(B) Application software

(C) Operating system

(D) The motherboard

(E) None of these

Ans: (C)

14. Servers are computers that provide resources to other computers connected to a

___________

(A) Mainframe

(B) Network

(C) Supercomputer

(D) Client

(E) None of these

Ans: (B)

15. A goal of data mining includes which of the following?

(A) To explain some observed event or condition

(B) To confirm that data exists

(C) To analyze data for expected relationships

(D) To create a new data warehouse

(E) None of these

Ans: (A)

16. URL stands for……..

(A) Universal Research List

(B) Universal Resource List

(C) Uniform Resource Locator

(D) Uniform Research Locator

(E) None of these

Ans: (C)

17. A database management system (DBMS) is a. ………..

(A) Hardware system used to create, maintain and provide controlled access to a database

(B) Hardware system used to create, maintain, and provide uncontrolled access to a database.

(C) Software system used to create, maintain, and provide uncontrolled access to a database.

(D) software system used to create, maintain, and provide controlled access to a database.

(E) None of these

Ans: (D)

18. Which of the following is NOT a goal of traction processing system ?

(A) Capture, process and store tractions

(B) Produce a variety of documents related to routine business activities

(C) Reduce manual effort associated with processing business tractions

(D) Produce standard reports used for management decision making

(E) None of these

Ans: ()

19. A Proxy server is used for 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: (B)

20. When data changes in multiple lists and all lists are not updated, this causes:

(A) Data redundancy

(B) Information overload

(C) Duplicate data

(D) Data inconsistency

(E) None of these

Ans: (D)

21._____________ is words that a programming language has set aside for its own use.

(A) Control worlds

(B) Reserved words

(C) Control structures

(D) Reserved keys

(E) None of these

Ans: (B)

22. What is the primary difference between a virus and a worm?

(A) A worm has the ability to self-propagate from an infected user’s computer to other computers

(B) A worm is usually written by a cracker: Script bunnies do not have the skills to develop a worm program

(C) A virus is very harmful to the computers it infects: a worm is not a serious a problem

(D) Anti-virus software is effective in fighting viruses but not worms

(E) None of these

Ans: ()

23.______ describes what database fields are.

(A) Structures

(B) Field markers

(C) Field definition

(D) Field names

(E) None of these

Ans: (D)

24. You must install a (n) ____________ on a network if you want to share a broadband Internet connection.

(A) Router

(B) Modem

(C) Node

(D) Cable

(E) None of these

Ans: (A)

25. A goal of normalization is to__________

(A) Minimize the number of relationships

(B) Minimize the number of entities

(C) Minimize the number of tables

(D) Minimize the number of redundancy

(E) None of these

Ans: (D)

26. Granting an outside organization access to internet web pages is often implemented using a (n)____

(A) Extranet

(B) Intranet

(C) Internet

(D) Hacker

(E) None of these

Ans: (A)

27. Which term identifies a specific computer on the web and the main page of the entire site

(A) URL

(B) Web site address

(C) Hyperlink

(D) Domain name

(E) None of these

Ans: (A)

28. The code that relational database management systems use to perform their database task is referred to as…..

(A) QBE

(B) SQL

(C) OLAP

(D) Sequel Server

(E) None of these

Ans: (B)

29. Chip is a common nickname for a (n):

(A) Tristor

(B) Resistor

(C) Integrated circuit

(D) Semiconductor

(E) None of these

Ans: (C)

30. The purpose of the primary key in a database is to:

(A) Unlock the database

(B) Provide a map of the data

(C) Uniquely identify a record

(D) Establish constraints on database operations.

(E) None of these

Ans: (B)

31. A_________ contains specific rules and words that express the logical steps of an algorithm.

(A) Programming language

(B) Syntax

(C) Programming structure

(D) Logic chart

(E) None of these

Ans: (D)

32. The design of the network is called the network:

(A) Architecture

(B) Server

(C) Trmission

(D) Type

(E) None of these

Ans: (A)

33. The most frequently used instructions of a computer program are likely to be fetched from:

(A) The hard disk

(B) Cache memory

(C) RAM

(D) Registers

(E) None of these

Ans: (B)

34. The____________ contains data descriptions and defines the name, data type, and length of each field in the database.

(A) Data dictionary

(B) Data table

(C) Data record

(D) Data field

(E) None of these

Ans: (A)

35. Personal logs or journal entries posted on the Web are known as:

(A) listservs

(B) Webcasts

(C) Blogs

(D) Subject directories

(E) None of these

Ans: (C)

36. A (n)_______ uses pictures (called icons) and menus displayed on the screen to send commands to the computer system.

(A) Command – based user interface

(B) GUI

(C) System utility

(D) API

(E) None of these

Ans: (B)

37. The_____ manual tells you how to use a software program.

(A) Documentation

(B) Programming

(C) technical

D) User

(E) None of these

Ans: ()

38. Which of the following is NOT a type of broadband Internet connection?

(A) Cable

(B) DSL

(C) Dial-up

(D) Satellite

(E) None of these

Ans: (C)

39. Software, such as viruses, worms and Trojan horses, that has a malicious intent, is known as:

(A) Spyware

(B) Adware

(C) Spam

(D) Malware

(E) None of these

Ans: (D)

40. Making a field______ me: that it cannot be left blank.

(A) Numeric

(B) Required

(C) Calculated

(D) Validated

(E) None of these

Ans: (B)

41._________ is the process of finding errors in software code.

(A) Debugging

(B) Compiling

(C) Testing

(D) Running

(E) None of these

Ans: ()

42.____________ is viruses that are triggered by the passage of time or on certain date.

(A) Boot-sector viruses

(B) Macro viruses

(C) Time bombs

(D) Worms

(E) None of these

Ans: (C)

43. Linux is a (n)______ ______ operating system.

(A) open-source

(B) Microsoft

(C) Windows

(D) Mac

(E) None of these

Ans: (A)

44. What is a backup?

(A) Restoring the information backup

(B) An exact copy of a system’s information

(C) The ability to get a system up and running in the event of a system crash or failure

(D) All of these

(E) None of these

Ans: (D)

45. Which of the following places the common data elements in order from smallest to largest

(A) Character, file, record, field, database

(B) Character, record, field, database, file

(C) Character, field, record, file, database

(D) Bit, byte, character, record, field, file, database,

(E) No

Ans:(D)

46. The internet is……

(A) A large network of networks

(B) An internal communication system for a business

(C) A communication system for the Indian government

(D) All of these

(E) None of these

Ans: (D)

47.____________ is lists of commands that appear on the screen.

(A) GUIs

(B) Icons

(C) Menus

(D) Windows

(E) None of these

Ans: (C)

48. Which of the following statements is FALSE concerning file names?

(A) Files may share the same name or the same extension but not both

(B) Every file in the same folder must have a unique name

(C) File extension is another name for file type

(D) The file extension comes before the dot (.) followed by the file name

(E) None of these

Ans: (D)

49. Verification of a login name and password is known as:

(A) Configuration

(B) Accessibility

(C) Authentication

(D) Logging in

(E) None of these

Ans: (C)

50. Which of the following would most likely NOT be a symptom of a virus?

(A) Existing program files and icons disappear.

(B) The CD-ROM stops functioning.

(C) The Web browser opens to an unusual home page.

(D) Odd messages or images are displayed on the screen.

(E) None of these

Ans:(B)