NIELIT QUESTION PAPER
O LEVEL (M1-R4)
JANUARY 2019
IT TOOLS & BUSINESS SYSTEMS
M1-R4: IT TOOLS & BUSINESS SYSTEMS
Note:-change in the examination pattern of o/a/b level course. So, there will be only MCQ in theory paper not subjective question.
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. (1*10=10)
1.1 Which is the technology used in the
evaluation of aptitude test?
(A) OCR
(B) OMR
(C) MICR
(D) MCR
Optical mark recognition (also called optical mark reading and OMR) is the process of reading information that people mark on surveys, tests and other paper documents. OMR is used to read questionnaires, multiple choice examination papers in the form of shaded areas.
1.2
SQL stands for :
(A) Standard Query Language
(B) Structured Query Language
(C) Shortest Query Language
(D) System Query Language
SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.
1.3
Which of the following is an impact
printer?
(A) Laser
(B) Ink-jet
(C) Dot-matrix
(D) None of the options
Examples of Impact printers are: Dot Matrix Printer. Drum Printer. Line Printer.
An impact printer is a type of printer that works by direct contact of an ink ribbon with paper
1.4
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
Crtl a is for select all
Crtl x for cut
Crtl v for paste
Crtl c for copy
1.5
ROUND(1363.45,–2) returns
(A) 1400
(B) –1364
(C) 1363.45
(D) 1464
Round -2 means that last digit is 00 like 1800 end with double zero without decimal.
Round 2 means that last digit with two decimal number.
Round 0 means write the without round figure and decimal. Like 2899.78 round 0 is 2899.
1.6 The number of bits used to store a BCD
digit is :
(A) 2
(B) 4
(C) 6
(D) 8
A Binary Coded Decimal (BCD) is a type of binary representation for decimal values where each digit is represented by its 4 bit binary equivalent.
Binary-coded decimals are an easy way to represent decimal values, as each digit is represented by its own 4-bit binary sequence which only has 10 different combinations.
The following represents the 4-bit binary representation of decimal values:
1.7 Numbers in base 8 are called as
(A) Octal System
(B) Hexadecimal System
(C) Decimal System
(D) Binary Numbering System
Answer:-
Number system in computer
Decimal -base 10 (0-9)
Hexadecimal- base 16 (0-9)(A-F)
Binary- base 2 (0,1)
Octal - base 8 (0-7)
1.8
A collection of worksheets is called as
(A) Excel Sheets
(B) Workbook
(C) Excel Worksheets
(D) Excel Book
Each page is called a worksheet, and a collection of one or more worksheets is called a workbook (which is also sometimes called a spreadsheet file).
1.9
The binary number 1110 is equal to the
decimal number ________.
(A) 3
(B) 1
(C) 7
(D) 14
1110 to change in decimal number
First count all the numbers in 1110 there is 4 number. Use n-1 formula
N=4
n-1=4-1
=3
(2×1)^3+(2×1)^2+(2×1)^1+(2×0)^0
=8+4+2+0
=14
1.10 Which of the following is used to create
newspaper style columns ?
(A) Format Tabs
(B) Table Insert Table
(C) Insert Textbox
(D) Format Columns
Newspaper articles, Newsletters, and Flyers—are often written in column format. Word also allows us to adjust your columns by adding column breaks.
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. (1×10=10)
2.1 MICR stands for Magnetic Ink
Character Reader.
False
MICR STANDS magnetic ink character recognition.
2.2 Database can contain table, query and
report.
True
The answer is 'true'. Database contains table, query, and report.
Explanation:
A database is more like a tool used for collecting and organizing the information. It can store information about products, persons, orders, along with specifications.
A computerized dB can be defined as a container of objects. One dB can have more than one table.
A database is more like a container as it can hold various types of objects. A typical Access Database has tables, reports, forms, queries, Macros, and modules.
2.3 Absolute cell referencing always refer to
the same cell in spreadsheet.
True
If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a "$" before the column letter if you want that to always stay the same.
2.4 Volatile memory is directly accessible
by the CPU.
True is the correct answer for the above question.
Explanation:
Volatile memory is a memory which is used when the system power is on. It maintains the data at that time. It transfers the data to the nonvolatile memory when the system's power is off. The Ram is used for volatile memory.
It is directly accessed by CPU because CPU is the only part of the computer system which accessed the memory directly and the volatile memory is also part of the memory.
The above -question statement states that the CPU directly accessed the volatile memory which is the correct statement. Hence true is the correct answer for the above statement.
Non-volatile memory is memory that retains its values even when power is removed.
2.5 Many operating systems are designed
as collection of program modules.
True
Operating System is a collection of programs that manages hardware resources. It is system service provider to the application programs. It is link to interface the hardware and application programs.
The kernel is the central module of an operating system (OS). It is the part of the operating system that loads first, and it remains in main memory.
An operating system has three main functions:
(1) manage the computer's resources, such as the central processing unit, memory, disk drives, and printers,
(2) establish a user interface
(3) execute and provide services for applications software.
2.6 Multitasking is also called parallel
processing.
True
True multitasking is the ability of a processor or operating system to execute and process more than one task at a time, rather than switching between them. It is a multitasking technique that enables the underlying hardware or software system to perform multiple tasks in parallel.
2.7 Page setup option is in Table menu in
MS Word.
False
Page Setup option is in table menu in MS Word - This statement is false. The Page Setup option is under the Layout ribbon in MS Word
2.8 Maximum zoom percentage in word
document is 500.
True
The correct answer is 500. The minimum zoom percentage available in MS Word documents is 10%. The maximum zoom percentage in MS Word document is 500%. Zoom-in is done to get a close-up view of the file or zoom out to see more of the page at a reduced size.
2.9 A string of 8 Bits is called Byte.
True
True, the group of 8 bits is used to represent a byte.
Explanation:
The bit is defined as the basic unit of information theory and computing. The single-bit 0 or 1 in any binary value. The single-bit 0 or 1 separately called as bit. The group of 4-bit collectively called nibble and it is represented as 1111 or 0000. And the group of 8-bit collectively called a byte. it is represented as 0000 0000 or 1111 1111. And the byte is used to represent the binary number.
2.10 The Recycle Bin is a folder that provides a convenient place to store frequently used documents, graphics and other files.
False
Like the Apple's Trash application, the Recycle Bin is a location where deleted files or folders are temporarily stored in every version of Microsoft Windows since Windows 95. The Recycle Bin allows users to recover files that were deleted in Windows. It is on the desktop.
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. (1×10=10)
3.1 A supercomputer’s speed measured in
A. Artificial-Logic Unit
3.2 ALU stands for
B. Oracle
3.3 Computers have several additional storage location called
C. Nanoseconds or Picosecond
3.4 First all-electronic computer was
D. Arithmetic-Logic Unit
3.5 ASCII stands for
E. Random Access Memory
3.6 Number system we use for our day-to-day
activities
F. Register Access Memory
3.7 RAM stands for
G. Mark-I
3.8 SELECT is
H. Registers
3.9 Popular RDBMS
I. Linux
3.10 Open Source Operating System
J. Decimal
K. Octal
L. American standard code for
information interchange
M. SQL command
Answer:-
3.1 A supercomputer’s speed measured in
C. Nanoseconds or Picosecond
3.2 ALU stands for
D. Arithmetic-Logic Unit
3.3 Computers have several additional storage location called
H. Registers
3.4 First all-electronic computer was
G. Mark-I
3.5 ASCII stands for
L. American standard code for information interchange
3.6 Number system we use for our day-to-day
activities
J. Decimal
3.7 RAM stands for
E. Random Access Memory
3.8 SELECT is
M. SQL command
3.9 Popular RDBMS
B. Oracle
popular relational database management system (RDBMS)
3.10 Open Source Operating System
I. Linux
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. (110=10)
A. F7
B. F4
C. Table
D. Undo
E. F5
F. Binary Coded Decimal
G. Redo
H. Program
I. Record
J. =
K. &
L. 1024
M. Kernel module
4.1 Computer can execute a prerecorded list of instruction called a ____ H. Program_____.
4.2 To cancel the last editing, we use the ____ D. Undo_____ button.
4.3 The short cut key for slide show is ____ E. F5______.
4.4 The key for spell check in MS Word is___ A. F7______.
4.5 Formula in MS-Excel begins with_____ J. = ____ sign.
4.6 __C. Table _______is a complete collection of data displayed in rows & columns.
4.7 BCD stands for_F. Binary Coded Decimal _______.
4.8 The central module of an operating system is called___M. Kernel module _______.
4.9 1 GB is equivalent of ____L. 1024 ____ MB.
4.10 Data items grouped together for storage purpose is called a _I. Record_ ____
Part-2
5.
(a) Explain about Multitasking
operating system in detail.
(b) Convert (B5A)16 to Octal.
(c) Explain about the hardware
components of general-purpose
computers. (5+5+5=15)
6.
(a) Write notes on features of
PowerPoint.
(b) Explain common characteristic of
the computer.
(c) Explain in detail about system
software and application
software.
(5+5+5=15)
7.
(a) Explain the binary number
system.
(b) Compare Compiler, Interpreter
and Assembler
(c) What is Linux and what are its
features ? (4+6+5=15)
8.
(a) Explain about Mail-Merge facility
in MS-Word with proper steps.
(b) What is a Relational Database ?
What is a key ? What are
different keys in database ?
(c) Explain about significance of
information technology in
education.
9. Differentiate between any three of the
following:
(a) Open Source Software and
Proprietary Software
(b) RAM and ROM
(c) SPAM and VIRUS
(d) TEMPLATE and WIZARD
