Computer Awareness Quiz 2010 - V

1.      A group of attribute/field in a database is known as a______.

a) Record   b) File   c) Database   d) Entry   e) None

2.      A ______ describe a category of information in a table of database.

a) Record   b) File   c) Entry   d) Field   e) None

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

a) To confirm that data exists

b) To create a new data warehouse

c) To analyze data for expected relationships

d) To explain some observed event or condition

e) None of the above

4.      The correct hierarchical order, smallest to largest, for the following database terms is:

a) File, Field, Record, Database

b) File, Record, Field, Database

c) Record, Field, File, Database

d) Field, Record, File, Database

e) None of the above

5.      In RDBMS , DBA is responsible for:

a) Physical database design

b) Defining conceptual models and schema

c) Defining security and integrity rules

d) Defining backup and recovery mechanisms

e) All the above

6.      When data changes in multiple lists and all lists are not updated, this causes _______.

a) Duplicate data

b) Data redundancy

c) Data inconsistency

d) Information overload

e) None

7.      Which of the following programming method is used to minimize data errors when data

is transferred over a network?

a) Checksum  b) Checkbit  c) Cryptography d) Encryption  e) None

8.      Which device act as a traffic cop over a network?

a) Modem   b) Hub   c) Switch   d) Router   e) None

9.      How many layers are present in Open System Interconnection (OSI) model of network

architecture?

a) Five   b) Six   c) Seven   d) Eight  e) None of these

10. Which layer of OSI model, firstly make use of unit of data called “Packet”?

a) Datalink Layer

b) Transport Layer

c) Network Layer

d) Presentation Layer

e) None

11. Communication between computers is established, maintained and terminated by _____ .

a) Network Layer

b) Session Layer

c) Application Layer

d) Presentation Layer

e) None

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

site?

a) URL   b) Hyperlink   c) Web site address   d) Domain name   e) None of these

13. The place where data or information is stored for a short time is

a) Memory   b) Control Unit   c) Buffer   d) ALU   e) None

14. The section of CPU which selects, interprets and sees to the execution of program

instructions?

a) ALU   b) Control Unit   c) Register Unit   d) Processing Unit   e) None

15. Which program is used to convert assembly language to machine language?

a) Compiler   b) Interpreter   c) Linker   d) Assembler   e) None

16. The process of finding errors in software’s source code

a) Debugging   b) Compiling   c) Testing   d) Running   e) None

17. A computer programmer

a) can draw only flowchart

b) can enter data quickly

c) does all the thinking for a computer

d) can operate all type of computer equipment

e) None

18. Primary Memory of a personal computer consists of

a) RAM only

b) ROM only

c) Hard Disk only

d) Both (a) and (b)

e) All (a), (b), and (c)

19. A Trojan horse is

a) An ad ware program

b) A virus disguised as a useful program.

c) A program that blows up every time you use it

d) A spy ware which steal information over internet

e) None

20. Which one of the following is not true?

a) HTTP Protocol is used to view a web page in a browser

b) Android is Google's operating system for mobile devices

c) GHz is the measurement used to determine the speed of processor

d) WAN requires the same technology as LAN

e) All are true

Note: Submitted by Narendra.