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.

Computer Awareness Quiz 2010 - III

1.      After a program has shown that it runs and produces results, the next step is to…...?

a) Save   b) Load   c) Exit   d) Test   e) List

2.      A computer that works with discrete quantities is

a) Hybrid  . b) Optical.   c) Digital   d) Analog   e) None

3.      A 32 bit computer word consists of………?

a) 4 bytes   b) 8 bytes   c) 16 bytes   d) 32 bytes   e) None

4.      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

5.      What is a ‘tuple’?

a) Another name for a table in an RDBMS.

b) Another name for the key linking different tables in a database.

c) Initial seed value of a field

d) A row or record in a database table.

e) An attribute attached to a record.

6.      Which of the following is not a web scripting language?

a) ASP   b) DSP   c) JSP    d) PHP   e) HTML

7.      Which one of the following work as both an input and output device?

a) Keyboard   b) QWERTY Keyboard   c) Mouse    d) Scanner   e) Modem

8.      Which of the following companies is also known as ‘Big Blue’

a) Intel   b) IBM   c) Microsoft   d) Adobe System   e) Google

9.      Which of the following is not an operating system for personal computers?

a) Windows XP   b)Windows 7   c) Red Hat Linux   d) Google’s Nexus One   e)Unix

10. A network where all systems have equal status is called:

a) Peer-to-Peer.

b) A Star Network.

c) The Internet.

d) Client-Server.

e) None

11. What is the communications protocol that allows you to connect your computer

to the Internet using a standard telephone line ?

a) HTTP   b) ISDN   c) SLIP   d) TCP/IP   e) None

12. What is the name given to the standard or set of rules that two computers use

to communicate with each other ?

a) Access Control   b) Domain   c) Link   d) Protocol   e) TCP/IP

13. What does SMPS stands for?

a) Switched Mode Power Supply

b) Single Mode Power Supply

c) Simple Mode Power Supply

d) Synchronous Mode Power Supply

e) None

14. When a user turns on a Windows XP system, which program will activate first?

a) Exhaust fan of SMPS will start rotating

b) Windows XP logo screen appear with progress bar

c) Operating System start to load its file in RAM.

d) Desktop screen appear with mouse pointer

e) BIOS the in-charge of system start executing

15. In Windows Explorer, when a user press Alt key and Double-click a file/folder

simultaneously, what will happen?

a) Selected file/folder will open in new window

b) Selected file/folder will open in same window

c) Selected file/folder will move to recycle bin

d) Properties dialog box of Selected file/folder will open

e) None

16. Which of the following is not true?

a) TCP is a connection-oriented protocol

b) 48 is an Octal Number

c) FTP stands for File Transfer Protocol

d) A file having extension PNG is a graphic file

e) C++ is a computer programming language

17. In MS-Excel, what is the keyboard shortcut to complete a cell entry and move up in the selection?

a) Ctrl + TAB

b) Shift + TAB

c) Alt + ENTER

d) Shift + ENTER

e) None

18. What is the file extension used for Microsoft Word document templates?

a) .dot   b) .wdt   c) .txt   d) .exe   e) .doc

19. Which Access component is best for data presentation?

a) Table    b) Form    c) Report    d) Query    e) None

20. What would you see while spell checking the phrase “My father was write”?

a) The word “write” is misspelled.

b) A red line appears under “write”

c) A green line appears under “write”

d) The word “father” is misspelled.

e) No errors.

Note: Submitted by Narendra.