M1-R4: IT TOOLS AND BUSINESS SYSTEMS JAN 2020

M1-R4: IT TOOLS AND BUSINESS SYSTEMS JAN 2020

TOTAL TIME: 3 HOURS TOTAL MARKS: 100

(PART ONE – 40; PART TWO – 60)

PART ONE

(Answer all the questions)

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 Which Decimal equivalent of the binary
number 11100011

(A) 227 (B) 226
(C) 224 (D) 228

1.2. The value of Primary key :
A) cannot be null
(B) can be null
(C) duplicate
(D) all of the above

1.3. LINUX is :
(A) a Compiler
(B) an Assembler
(C)- an Operating System
(D) an Editor

1.4 MIS stands for
(A) Maintenance Information System
(B) Model Information System
(C) Management Information System
(D) Media Information Source

1.5 The most commonly used web browser is:
(A) Internet Explorer
(B) Netscape
(C) Both (A) and (B)
(D) None of the above

1.6 Memory is used to store BIOS on Motherboard.
(A) ROM
(B) RAM
(C) CACHE
(D) None of the above

1.7 SQL stands for :
(A) Standard Query Language
(B) Structured Query Language
(C) Shortest Query Language
(D) System Query Language

1.8 Which of the following is a communication device?
(A) Printer 
(B) Monitor
(C) Keyboard 
(D)Modem

1.9 Using Microsoft Word’s Find and Replace feature you can
(A) replace both text and formatting.
(B) replace the text of a document only.
(C) replace formatting only.
(D) replace document’s name with a new name.

1.10. Numbers in base 16 are called as
(A) Octal System
(B) Hexadecimal System
(C) Decimal System
(D) Binary Numbering System

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

2.1 UNIX is a free, reliable alternative to Windows XP.

True

2.2 Windows clipboard can hold multiple pieces of information at the same point of time.

True

2.3 By default, the numbers are left-aligned and text is right-aligned in a spreadsheet.

False

2.4 A Browser is a software program used for viewing Web pages on the Internet.

True

2.5 Word file cannot be protected by a password.

False

2.6 A series of specially designed documents, all linked together to be viewed on the Internet is the World Wide Web.

True

2.7 ROM is volatile memory.

False

2.8 MS Word is system software.

False

2.9 The PowerPoint presentation can be embedded with sound, video clips and animations.

True

2.10 In Microsoft, Access deleted record can be undone.

False

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. (1x10)

Q.No	X	Y
3.1	Data transfer rate of a Dial-up Modem is measured in  K	A	Information
3.2	A device that accomplishes modulation and demodulation  E	B	Ctrl + P
3.3	Universal serial bus H	C	AVI
3.4	IPR J	D	Mac-os
3.5	Processed Data A	E	MODEM
3.6	Number system to the base 2 F	F	Binary
3.7	Shortcut to print file B	G	Ctrl+S
3.8	It is a file format to store video file C	H	USB
3.9	Operating system software used on the apple Macintosh  D	I	RAM
3.10	Special memory unit within CPU L	J	Intellectual property right
		K	Kbps
		L	Register
		M	Linus

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

A. 16    

B. B2C 

C. Folder         

D. Password              

E. M2M                 

F. GHz

G. Calibri 

H. Star  

I. 8  

J. LAN   

K.Format Painter     

L. Animation        

M. System

4.1 Format Painter facility copies the only format of the selected text, not the content.

4.2 Calibri is the name of a Font.

4.3 Animation is the rapid display of a sequence of images to create an illusion of movement.

4.4 Speed of latest computer is measured in GHz.

4.5 Folder can contain files as well as subfolders

4.6 Base of Octal number system is 8.

4.7 Commercial exchange between business and consumers conducted over the internet
is abbreviated as B2C

4.8 Operating System is a System software.

4.9 LAN is a type of network topology.

4.10 Password Unix command is used to change ownership of the file.

PART TWO

(Answer any FOUR questions)

5. 

a. Define a function in Spreadsheet Software. Describe any five functions.

b. Explain the following with example in MS Word :
  (i) Mail-Merge.

 (ii) Header, Footer, Footnote and Endnote.

6. 

a Discuss the security risks associated with e-commerce.

b What is application software? What are the different types of application software?

c Describe various components of Windows Desktop.

7. 

(a) Describe the different views available in presentation software.
(b) What is a Relational Database Management System? Differentiate between Create Table & View Table commands in SQL?

(c) Write a short note on Database

8. 

(a) What is a path? What is absolute and relative path in Linux environment?

(b) How information technology is going to impact the Indian Education system.

9. 

a Draw the block diagram depicting the four functional units of the computer system.

b Define RAm EOM , Cache memory.

c Explain briefly Intellectual property right.

- o O o -