M1-R4: IT TOOLS AND BUSINESS SYSTEMS JUL 2015
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)
one and enter in the “OMR” answer sheet supplied with the question paper, following
instructions therein. (1x10)
1.1 EEPROM stands for
A) Electrically Erasable Programmable Read of Memory
B) Erasable Electrically Programmable Read Only Memory
C) Easily Erasable Programmable Read Only Memory
D) Electrically Erasable Programmable Read Only Memory
1.2 Which of the following belongs to Systems Software?
A) Word Processing Software
B) Web Browser
C) Operating System
D) Spreadsheet Software
1.3 Background color or effects applied on a document is not visible in
A) Web layout view
B) Print Layout view
C) Reading View
D) Print Preview
1.4 If you need a text to show vertically in a cell. How will you achieve this?
A) Choose Vertical on Text alignment in Format Cells dialog box
B) Choose 90 Degrees in Orientation of Format Cells dialog box
C) Choose Distributed from the Vertical drop down list of Format Cells dialog box
D) Choose Center across Selection from Horizontal combo box in Format Cells dialog box
1.5 A transparent DBMS
A) hides sensitive information from users
B) keeps its logical structure hidden from users
C) keeps its physical structure hidden from users
D) provides physical map of underlying hardware to users
1.6 Convert the Hexadecimal number 5A to Binary
A) 01011001
B) 01001010
C) 01011010
D) 01000100
1.7 A collection of worksheets is called as
A) Excel Sheets
B) Workbook
C) Excel worksheets
D) Excel Book
1.8 A CPU consists of at least
A) ALU and Registers
B) ALU and Control Unit
C) ALU and Memory
D) RAM and ROM
1.9 The resolution of a printer is measured in:
A) Megabits
B) Hz
C) Dots per inch (DPI)
D) Inches (diagonal)
1.10 An example of a volatile memory is:
A) CD-ROM
B) RAM
C) ROM
D) Hard Disk
A) Electrically Erasable Programmable Read of Memory
B) Erasable Electrically Programmable Read Only Memory
C) Easily Erasable Programmable Read Only Memory
D) Electrically Erasable Programmable Read Only Memory
1.2 Which of the following belongs to Systems Software?
A) Word Processing Software
B) Web Browser
C) Operating System
D) Spreadsheet Software
1.3 Background color or effects applied on a document is not visible in
A) Web layout view
B) Print Layout view
C) Reading View
D) Print Preview
1.4 If you need a text to show vertically in a cell. How will you achieve this?
A) Choose Vertical on Text alignment in Format Cells dialog box
B) Choose 90 Degrees in Orientation of Format Cells dialog box
C) Choose Distributed from the Vertical drop down list of Format Cells dialog box
D) Choose Center across Selection from Horizontal combo box in Format Cells dialog box
1.5 A transparent DBMS
A) hides sensitive information from users
B) keeps its logical structure hidden from users
C) keeps its physical structure hidden from users
D) provides physical map of underlying hardware to users
1.6 Convert the Hexadecimal number 5A to Binary
A) 01011001
B) 01001010
C) 01011010
D) 01000100
1.7 A collection of worksheets is called as
A) Excel Sheets
B) Workbook
C) Excel worksheets
D) Excel Book
1.8 A CPU consists of at least
A) ALU and Registers
B) ALU and Control Unit
C) ALU and Memory
D) RAM and ROM
1.9 The resolution of a printer is measured in:
A) Megabits
B) Hz
C) Dots per inch (DPI)
D) Inches (diagonal)
1.10 An example of a volatile memory is:
A) CD-ROM
B) RAM
C) ROM
D) Hard Disk
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 All data processing systems must provide for the input, processing, and output of data.
2.2 The principal advantage of database systems is the ability to share the same data across multiple applications and systems.
2.3 Dot matrix printer uses optical technique to print.
2.4 An example of an input device is a printer.
2.5 A bit is bigger than a byte.
2.6 Entity is a characteristic of object in database.
2.7 The kernel is a program that constitutes the central core of a computer operating system.
2.8 Mnemonics are associated with machine language.
2.9 Internet is network of networks.
2.10 Volatile memory is directly accessible by the CPU.
2.2 The principal advantage of database systems is the ability to share the same data across multiple applications and systems.
2.3 Dot matrix printer uses optical technique to print.
2.4 An example of an input device is a printer.
2.5 A bit is bigger than a byte.
2.6 Entity is a characteristic of object in database.
2.7 The kernel is a program that constitutes the central core of a computer operating system.
2.8 Mnemonics are associated with machine language.
2.9 Internet is network of networks.
2.10 Volatile memory is directly accessible by the CPU.
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)
Sr.No. | X | Y(Ans.) |
In the year 1969, Department of Defence of the United States started a network called | ||
A device that accomplishes modulation and demodulation | ||
Number system to the base 2 | ||
The menu on which the WordArt option is available | ||
Readymade formulas of Excel | ||
The icons with an arrow in Windows Desktop |
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. Internal
B. Animation
C. Physical
D. Two
E. Calibri
F. Backup
G. 1000
H. I/O Module
I. External
J. Database
K. Logical
L. 1024
M. Home
4.1 The Semiconductor memories are ________ types.
4.2 ________ is a name of a Font.
4.3 Optical disks are used for ________ memory.
4.4 The ________ tab is to take you to first page of website.
4.5 The address of a location of the main memory is called ________ address.
4.6 ________ is the rapid display of a sequence of images to create an illusion of movement.
4.7 The external memory systems are accessible by the CPU through ________.
4.8 Magnetic Tapes are examples of ________ memory.
4.9 An arrangement of data in a particular order is called ________.
4.10 The 1KB equals ________ bytes.
B. Animation
C. Physical
D. Two
E. Calibri
F. Backup
G. 1000
H. I/O Module
I. External
J. Database
K. Logical
L. 1024
M. Home
4.1 The Semiconductor memories are ________ types.
4.2 ________ is a name of a Font.
4.3 Optical disks are used for ________ memory.
4.4 The ________ tab is to take you to first page of website.
4.5 The address of a location of the main memory is called ________ address.
4.6 ________ is the rapid display of a sequence of images to create an illusion of movement.
4.7 The external memory systems are accessible by the CPU through ________.
4.8 Magnetic Tapes are examples of ________ memory.
4.9 An arrangement of data in a particular order is called ________.
4.10 The 1KB equals ________ bytes.
PART TWO
(Answer any FOUR questions)
5.
a) Compare and contrast between Linux and UNIX.
b) Convert the hexadecimal number D6FA into decimal number and octal number.
c) What are the main components of CPU? Discuss them in detail.
(5+5+5)
6.
a) Write short notes on applications of Multimedia in Education and Entertainment.
b) Explain the difference between Multiprogramming and Multiprocessing systems.
c) Write short notes on Computer Reservations System.
(5+5+5)
7.
a) Discuss how can you have animation in MS-Power Point slides?
b) Define function in Spreadsheet Software. Describe any five functions.
c) What is the difference between relative, absolute and mixed references? Explain with example.
(3+7+5)
8.
a) Write short notes on System Software and Application Software.
b) With a neat diagram explain the organizations of a computer.
c) Explain following with example in MS-Word: i) Mail-Merge ii) Header, Footer, Footnote and Endnote
(4+3+8)
9.
a) Define the concept of aggregation with suitable example.
b) Consider the EMPLOYEE database as shown below:
Emp (person_id, person_name, street, city) Works (person_id, company_id, salary) Company (company_id, company_name, company_city) Give expressions in SQL for each of the following queries:
i) Write the statement to create Emp Table.
ii) Write the statement to create Works Table.
iii) Write the statement to create Company Table.
iv) Display names and salary of those employees who are getting salary greater than Rs. 10,000. v) Find the names and cities of residence of all employees who work for “SBBJ Bank”.
vi) Count the employees on the basis of similar salaries.
(6+9)
a) Compare and contrast between Linux and UNIX.
b) Convert the hexadecimal number D6FA into decimal number and octal number.
c) What are the main components of CPU? Discuss them in detail.
(5+5+5)
6.
a) Write short notes on applications of Multimedia in Education and Entertainment.
b) Explain the difference between Multiprogramming and Multiprocessing systems.
c) Write short notes on Computer Reservations System.
(5+5+5)
7.
a) Discuss how can you have animation in MS-Power Point slides?
b) Define function in Spreadsheet Software. Describe any five functions.
c) What is the difference between relative, absolute and mixed references? Explain with example.
(3+7+5)
8.
a) Write short notes on System Software and Application Software.
b) With a neat diagram explain the organizations of a computer.
c) Explain following with example in MS-Word: i) Mail-Merge ii) Header, Footer, Footnote and Endnote
(4+3+8)
9.
a) Define the concept of aggregation with suitable example.
b) Consider the EMPLOYEE database as shown below:
Emp (person_id, person_name, street, city) Works (person_id, company_id, salary) Company (company_id, company_name, company_city) Give expressions in SQL for each of the following queries:
i) Write the statement to create Emp Table.
ii) Write the statement to create Works Table.
iii) Write the statement to create Company Table.
iv) Display names and salary of those employees who are getting salary greater than Rs. 10,000. v) Find the names and cities of residence of all employees who work for “SBBJ Bank”.
vi) Count the employees on the basis of similar salaries.
(6+9)
- o O o -
Post a Comment
Leave a Reply