Wednesday, 19 April 2023

Solved IT Tools and Business Systems (July 2021)

 Solved IT Tools and Business Systems M1-R4 (July 2021)

Q. 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 SaveAs dialog box can be used :
(A) for saving the file for the first time
(B) to save file by some alternative name
(C) to save file in a format other than Word
(D) all of the above

1.2 : Non-impact based printing device is :
(A) Dot-Matric Printer
(B) Scanner
(C) Laser Printer
(D) None of the above

1.3 : To cut text from the document, press the keys
(A) Ctrl and V
(B) Ctrl and C
(C) Ctrl and A
(D) Ctrl and X

1.4 : __________ maps IP addresses with the domain names of the sites.
(A) URL
(B) DNS
(C) FTP
(D) None of the above

1.5 : A Nibble consists of Bits.
(A) 2
(B) 4
(C) 8
(D) 16

1.6 : User interact with the operating system through a set of .
(A) USB Sticks
(B) Commands
(C) Scanner
(D) All of the above

1.7 : Which is the technology used in the evaluation of aptitude test ?
(A) OCR
(B) OMR
(C) MICR
(D) MCR

1.8 : To create a Paragraph Break  in MS- WORD, which key is used ?
(A) Enter
(B) Esc
(C) Tab
(D) Shift

1.9 : MIDI means :
(A) Multimedia Instrument Digital Information
(B) Multimedia Instrument Digital Interface
(C) Musical Instrument Digital Interface
(D) Musical Information Digital Information

1.10 : Full form of ASCII :
(A) American Standard Code for Information Interconnection
(B) American Situation Code for Information Intercommunication
(C) American Standard Code for Information Interchange
(D) American Standard Coding for Information Interconnection


Q. 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 IPv6 Internet Protocol address is represented as eight groups of four Octal digits.
2.2 There are only two types of page orientation - portrait and landscape.
2.3 Internet is a network of networks.
2.4 MIDI means Multimedia Instrument Digital Interface.
2.5 MICR stands for Magnetic Ink Character Reader.
2.6 Peripheral is an external device connected to the computer, such as input and output devices and external storage devices.
2.7 We can get back the deleted files/folders from the Recycle bin.
2.8 ALU is not a part of CPU.
2.9 Results are automatically recalculated by a formula if the data is changed in a given cell of worksheet.
2.10 Database can contain table, query and  report.

Answer



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

X

Y

3.1

Popular RDBMS

(A)

Protocol

3.2

Number system to the base 2

(B)

Ctrl + w

3.3

Set of Rule

(C)

Binary

3.4

Shortcut to Close a document.

(D)

Octal

3.5

A type of file system in Windows operating system

(E)

Internet

3.6

Any part of the computer that you can physically touch

(F)

Functions

3.7

The arranging of data in a logical sequence is called :

(G)

Sorting

3.8

Readymade formulas of Excel

(H)

Software

3.9

Global system of interconnected computer networks.

(I)

Hardware

3.10

Facility can automatically rectify common spelling mistakes

and often-used acronyms, etc.

(J)

Auto Right

 

 

(K)

Auto correct

 

 

(L)

NTFS

 

 

(M)

ORACLE



Q. 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)

F12

(B)

Cut/Copied

(C)

Home

(D)

IT Act

(E)

Tables & Query

(F)

Control

(G)

Cyber crime

(H)

F2

(I)

Autosum

(J)

Hard disk Drive

(K)

Mailbox

(L)

End

(M)

Link

 

 

 

 



4.1 _________ deals with cybercrime and electronic commerce.
4.2 Relational Database contains _________.
4.3 The _________ tab is to take you to first page of website.
4.4 Inventory _________ is concerned with minimizing the total cost of inventory.
4.5 _________is used in MS-Excel to total rows and/or columns.
4.6 Save As dialog box is open by pressing _________ key.
4.7 A Clipboard is a temporary storage area used for text which is _________.
4.8 _________ an area of memory or disk that is assigned to store e-mail messages sent by other users.
4.9 _________ is both an Input-Output device.
4.10 Foreign Key is used to _________ the given table with other table.



PART TWO
(Answer any FOUR Questions)

5 (A) What is the difference between function and formula in Excel ? Provide example. Explain the working of the functions with example: count, max, if, sort in worksheet.

5 (B) Enumerate the components of multimedia and explain in brief. Enlist the commonly used file
formats of multimedia files.


6 (A) Convert (2565)8 to Hexadecimal number.
6 (B) Differentiate between DDL and DML.
6 (C) Discuss the role of Information Technology in the field of Education.

7 (A) Why are high level languages known as machine independent ?
7 (B) What is the need of database Management System ? Give three examples of popular database management systems.
7 (C) Compare all three : Compiler, Interpreter and Assembler.

8 (A) What is Personal Information System (PIS) and what are its functions ?
8 (B) Explain the application of Multimedia in E-learning.
8 (C) Explain the need of Operating System in a computer. What is the role of Kernel and Shell in LINUX Operating System ?


9 (A) Differentiate between Open Source Software and Proprietary Software.
9 (B) Explain common characteristic of the computer.
9 (C) Differentiate between SPAM and VIRUS.


No comments:

Post a Comment