1. In Excel, this is a prerecorded formula that provides a shortcut for complex calculations

A. Value B. Data Series C. Function D. Field E. None of these

2. DNS in internet technology stands for ________.

A. Distributed Name System B. Data Name System C. Dynamic Name System D. Domain Name Server E. None of these

3. Who amongst the following is called the father of modern computer science ?

A. Alan Turing B. Charles Babbage C. Konrad Zuse D. Frederick Cohen E. None of these

4. Which of the following is true for the octal system?

A. It needs less digits to represent a number than in the binary system. B. It needs more digits to represent a number than in the binary system. C. It needs the same number of digits to represent a number as in the binary system. D. It needs the same number of digits to represent a number as in the decimal system. E. None of these

5. Diagrammatic or symbolic representation of an algorithm is called _______.

A. Data-Flow diagram B. E-R diagram C. Flowchart D. Software E. None of these

Answers and Explanations
1. Answer - Option C
Explanation -
Function is a prerecorded formula that provides a shortcut for complex calculations
2. Answer - Option D
Explanation -
Domain Name Servers (DNS) are the Internet's equivalent of a phone book. They maintain a directory of domain names and translate them to Internet Protocol (IP) addresses.
This is necessary because, although domain names are easy for people to remember, computers or machines, access websites based on IP addresses.
3. Answer - Option A
Explanation -
Alan Turing is considered by many to be the father of modern computer science as the world knows it. He formed the concept of the algorithms and computations with one of his inventions, the Turing machine. Alan Turing was born on June 23, 1912 in England.
4. Answer - Option B
Explanation -
The Octal numeral system is the base-8 number system and uses the digits 0 to 7. Octal numerals can be made from binary numerals by grouping consecutive binary digits into groups of three (starting from the right).
Hence, it needs more digits to represent a number than in the binary system.
5. Answer - Option C
Explanation -
A flowchart is a type of diagram that represents an algorithm, workflow or process, showing the steps as boxes of various kinds, and their order by connecting them with arrows. This diagrammatic representation illustrates a solution model to a given problem.

1. If you selected text and click at I on the toolbar of MS Word, it makes the text ______.

A. Italics B. Underlined C. Italics and under lined D. Bold E. None of these

2. Which of the following types of tables constraints will prevent the entry of duplicate rows?

A. Primary key B. Unique C. Null D. Foreign key E. None of these

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

4. Which of the following search engines continuously sends out that starts on a homepage of a server and pursue all links stepwise ?

A. Spiders B. Packets C. Cookies D. asPaddle E. None of these

5. What kind of Protocol is used to provide Internet access from mobile?

A. TCP/IP B. ISD C. WAP D. HTTP E. None of these

Answers and Explanations
1. Answer - Option A
Explanation -
To make selected text italic, select and highlight the text first. Then hold down Ctrl (the control key) on the keyboard and then press the I on the keyboard, it makes the text Italic.
2. Answer - Option A
Explanation -
In the relational model of databases, a primary key is a specific choice of a minimal set of attributes (columns) that uniquely specify a tuple (row) in a relation (table).
3. Answer - Option D
Explanation -
Data inconsistency is a condition that occurs between files when similar data is kept in different formats in two different files, or when matching of data must be done between files.
Note: As a result of the data inconsistency, these files duplicate some data such as addresses and names, compromising data integrity.
4. Answer - Option A
Explanation -
A programme that automatically fetches Web pages. Spiders are used to feed pages to search engines. It’s called a spider because it crawls over the Web another term for these programmes is Web Crawler.
5. Answer - Option C
Explanation -
WAP(Wireless Application Protocol) is a technical standard for accessing information over a mobile wireless network.

1. One or more defects or problems that prevent the software from working as intended or working at all is a(n)____.

A. Bug B. Boot C. Programming language D. Fuzzy logic E. None of these

2. An e-mail address typically consists of a user ID followed by the _______sign and the name of the e-mail server that manages the user’s electronic post office box.

A. @ B. # C. & D. * E. None of these

3. Computer instructions written with the use of English words instead of binary machine code is called ____.

A. Mnemonics B. Symbolic code C. Gray codes D. Opcode E. None of these

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

A. Data extraction B. End-user query tool C. End-user presentation tool D. Data store E. None of these

5. Which of the following is used with databases?

A. Data mining B. EDI C. Credit cards D. All of the above E. None of the these

Answers and Explanations
1. Answer - Option A
Explanation -
A software bug is an error, flaw, failure or fault in a computer program or system that causes it to produce an incorrect or unexpected result, or to behave in unintended ways.
2. Answer - Option A
Explanation -
An e-mail address typically consists of a user ID followed by @ the sign and the name of the e-mail server that manages the user’s electronic post office box.
3. Answer - Option B
Explanation -
Symbolic code is a program code unrelated to the hardware of a particular computer and requiring conversion to the code used by the computer before the program can be used.
4. Answer - Option B
Explanation -
End user query tool performs data retrievals data analysis and data mining tasks using the data in the data store and business data analysis models. This component is used by the data analyst to create the queries that access the database.
5. Answer - Option A
Explanation -
Data mining is the computational process of discovering patterns in large data sets involving methods at the intersection of artificial intelligence, machine learning, statistics, and database systems.
Note: The overall goal of the data mining process is to extract information from a data set and transform it into an understandable structure for further use.