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.

Computer Awareness Quiz 2010 - II

1.      For the purposes of defining data needs, a responsibility area is

a) Marketing b) Personnel c) Administration d) Finance e) None

2.      The problem statement should include all of the following except:

a) Input. b) Output. c) Processing d) Storage e) None

3.      Hotmail, a free web-based email service operated by which company

a) Apple b) Rediff c) Microsoft d) Yahoo e) Google

4.      A collection of 4 binary digits is known as

a) Half Bit b)1/2 KB c) Byte d) Nibble e) None

5.      How many types of arithmetic operations does the ALU of all computers perform?

      a)     2 b) 4 c) 6 d) 8 e) 5

6.      Which of the following is not a part of the CPU?

a) Arithmetic and Logic Unit

b) Storage Unit

c) Program Unit

d) Control Unit

e) None

7.      Which of the following is not a unit of measurement in computer systems?

a)DPI b)PPI c)API d)Bd e)MB

8.      In Windows XP, which shortcut is used to cycle through opened items in taskbar?

a) Ctrl + Tab

b) Alt + Tab

c) Ctrl + Esc

d) Alt + Esc

e) None

9.      A digital computer compute the value of expression 2 * 5 - 2 >2 inside

a) RAM b) CPU Chip c) Hard Disk d) Floppy Disk e) MS-Excel

10. To produce a high-quality graphics (hardcopy) in color, you would want to use a

a)Virtual Printer b)Laser Printer c)Ink-jet Printer d)Plotter e)RGB Monitor

11. Which of the following is fastest memory ?

a) DDR RAM b) DDR2 RAM c) DDR3 RAM d) Swap Memory e) Buffer Memory

12. Which protocol is used by operating system to generate error message like

‘Host Unreachable’ over a TCP/IP network?

a) HTTP/1.1 b) ICMP c) PPP d) ICGM e) TCP/IP

13. What does SNMP stands for?

a) Simple Network Mail Protocol

b) Single Network Mail Protocol

c) Single Network Message Protocol

d) Simple Network Management Protocol

e) None

14. On a school computer, Tina learned how to copy programs. A classmate asked her to copy a program for his home use. Her most ethical response would be which of the following?

a) I'll copy it, but you have to promise not to tell anyone.

b) I don't know how to copy disks.

c) I can't copy it because it will break copyright laws.

d) I'll copy it for you, but you can't copy it for anyone else.

e) None

15. Which of the following is not true?

a)LOGO stands for Live On Google’s Orkut

b)BIOS is a system software

c)GRUB is a Linux bootloader

d)Ruby is a web scripting language

e) LILO is a Linux bootloader

16. What is the function of Drop Cap?

a) It does not allow capital letters to be used in the documents.

b) It makes first letter of each word capital letter in the documents

c) It lets you begin a paragraph with a large dropped initial capital letter.

d) It automatically starts all paragraphs and sentences with capital letters.

e) None

17. What is Mail-Merge?

a) a web based e-mail service with no spam

b) a name of Yahoo! MINDSET search feature

c) a new virus-hoax which can delete data from mail-inbox

d) a feature of MS-Word used to create multiple documents like letters,

mailing labels, name tags etc.

e) None

18. In MS-Excel 2003, the default workbook sheet contain maximum………

a) 65535 Rows b) 65536 Rows e) 1048576 Rows e) 65537 Rows c) None

19. In MS-Word, a menu item in dim color (gray) indicate that the menu is ?

a) Toggle Menu

b) Unavailable for current context

c) Not much required menu

d) Over Used Menu

e) None

20. Hot-Key is a

a) FireWire port

b) Alternate Key

c) Keyboard Shortcut

d) Primary Key

e) None

Note: Submitted by Narendra.