July, 2016 M1-R4: IT TOOLS AND BUSINESS SYSTEMS

July, 2016 M1-R4: IT TOOLS AND BUSINESS SYSTEMS Solve

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 : The basic architecture of computer was developed by

A)           John Von Neumann

B)           Charles Babbage

C)           Blaise Pascal

D)           Gorden Moore
Answer : 

1.2 : Which protocol provides e-mail facility among different hosts?

A)           FTP

B)           SMTP

C)           TELNET

D)           SNMP
Answer :

1.3 : Primary Memory is

A)           RAM

B)           ROM

C)           USB Drive

D)           Floppy Disk

Answer :

1.4 : Which of the following is not a font style?

A)           Bold

B)           Italics

C)           Regular

D)           Strikethrough

Answer :

1.5 : Which of the following translates a program written in Assembly language into Machine Code?

A)           A compiler

B)           An assembler

C)           An operating system

D)           An editor

1.6 : To paste text from the clipboard in the document being edited, press the keys

A)           Ctrl and V

B)           Ctrl and X

C)           Ctrl and A

D)           Ins

Answer

1.7 : The value of Primary key

A)           cannot be null

B)           can be null

C)           can be duplicate

D)           none of these

Answer

1.8 : Mail Merge is

A)           production of document from a single template and a data source

B)           production of single documents from a single template and a Clip art

C)           production of multiple documents from a single file and an address

D)           production of multiple documents from a single template and a data source

Answer

1.9 : Linux is

A)           A Compiler

B)           An Office Suite

C)           An Editor

D)           An Operating System

Answer

1.10 : The function ROUND(1343.45,-2) returns

 A)          1343

B)        -1343

C)        -1300

D)        1300

Answer

2. Each statement below is either TRUE or FALSE. Choose the most appropriate one and enter your choice in the “OMR” answer sheet supplied with the question paper, following instructions therein.(1x10)

2.1 : An icon on the desktop that represents a temporary holding place for files that are deleted is called as Recycle Bin.

2.2 : e-Payment is not a smart option for businesses and organizations to collect their payment on-line.

2.3 : In WORD, search is case sensitive.

2.4 : A computer system can be split into input, processing and output.

2.5 : Counters are digital circuit for temporary storage of data.

2.6 : The process of writing such program instructions for an analyzed problem is called Coding

2.7 : H2SO4 is written in Word using superscript feature.

2.8 : Unix is a single user operating system.

2.9 : In Microsoft Word to increase row in a table, ENTER key is used.

2.10 : Record is a collection of File.

Answer

3 : Match words and phrases in column X with the closest related meaning/ word(s)/phrase(s) in column Y. Enter your selection in the “OMR” answer sheet supplied with the question paper, following instructions therein.

X		Y
3.1	A temporary holding place for text, pictures or graphics	A.	Modem
3.2	Open Source Operating System	B.	Sorting
3.3	Shortcut used to save a file	C.	ORACLE
3.4	Special memory unit within cpu	D.	Clipboard
3.5	A device that accomplishes modulation and Demodulation	E.	Bug
3.6	Digital Signature	F.	FoxPro
3.7	DSS	G.	DECISION SUPPORT SYSTEM
3.8	The arranging of data in a logical sequence is called.	H.	Register
3.9	A hidden error in a computer program	I.	CTRL+S
3.10	Popular RDBMS	J.	Scanned Signature
		K.	Linux
		L.	Internet
		M.	Cache

Answer

4 : Each statement below has a blank space to fit one of the word(s) or phrase(s) in the list below. Choose the most appropriate option, enter your choice in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

A.	Master	B.	F12	C.	Database Management System
D.	F5	E.	Byte	F.	8
G.	Binary	H.	Word Wrap	I.	60
J.	1024	K.	RAM	L.	16
M.	32+28

4.1          A string of 8 bit is                  .

4.2          Base of Octal number system is                 .

4.3          A file containing relatively permanent data is known as                   file.

4.4          1 GB is equivalent of                  MB.

4.5          Process of placement of text going past right margin to next line is termed as                  .

4.6          Symbols 0 and 1 represent                   states of components of a computer.

4.7          If you enter 32+28 in a Excel cell, it will display the result as                  .

4.8          Save As dialog box is open by pressing                   key.

4.9                           is known as a primary memory.

4.10       DBMS stands for                 .

Answer

PART TWO

(Answer any FOUR questions)

Q : 5
A) What is the need of database Management System? Give three examples of popular database management systems.

b) Convert decimal to binary number: 75, -50. Convert binary to decimal number: 00010111, 00001111.

c) Define the following terms in context of a database:

       i)Primary Key and Foreign Key
       ii)Data Validation

(6+5+4)

Q : 6

a) How to insert “IT Tools and Business Systems” at bottom of the each page in word file?

b)     i) What is the use of Macro in MS-Excel and how it is recorded and executed?

       ii) In a spreadsheet, how to find maximum, minimum and average of Cell A1 to A10.

c) How slide transition is used inside a PowerPoint presentation?

(4+6+5)

Q : 7

a) What are the features and significance of electronic spreadsheets?
b) What is a cell?
c) What is cell referencing and what are the different types of referencing?
d) Give some application areas of electronic spreadsheet?

(5+2+3+5)

Q : 8
a) Compare Compiler, Interpreter and Assembler.

b) What is the difference between SPAM and VIRUS? How do you avoid each of the two in your system?

c) Why are high level languages known as machine independent?

(5+5+5)

Q : 9

Support your answers with examples. Differentiate between:

a) System Software and Application Software
b) UPLINK and DOWNLINK
c) RAM and ROM

Download PDFd

Next Set