MBOSE Class 11 Question Paper 2020 for Computer Techniques

Total No. of Printed Pages ––9
HS/XI/V/CT/Paper-I/20

2020

COMPUTER FUNDAMENTALS, OPERATING SYSTEMS
AND UTILITIES
COMPUTER TECHNIQUE ( Paper – I )
( Vocational Stream )
( Theory )

Full Marks : 100
Time : 3 hours

The figures in the margin indicate full marks for the questions
General Instructions :
(i) Write all the answers in the Answer Script
(ii) Attempt Part –– A Objective Questions serially
(iii) Attempt all parts of a question together at one place

( PART : A –– OBJECTIVE )
( Marks : 48 )
SECTION– I
( Marks : 30 )

1. Fill in the blanks from the list of words/phrases given
below: 1  10  10

(a) While typing a paragraph, one does not have to
press Enter key to move to the next line. This
feature is called _________.

HS/XI/V/CT/Paper-I/20

(8) (3)

( PART : B - DESCRIPTIVE ) 2. True or False: 1  10  10
( Marks : 52 )
(a) An ink jet printer is slower than a laser printer.
GROUP - I
( Marks : 36 )
(b) The shortcut key to save a document is Shift+S.

Answer ANY SIX questions:
(c) A High Level Language is machine dependent.
5. Write a short note on the characteristics of computers. 6

6. How do you differentiate an Interpreter from a (d) To cancel the last editing, we can use the undo
Compiler? How do they differ from an Assembler? button.
4+2=6
7. Give the syntax and explain the purpose of the (e) DEL and ERASE are two commands with a
following commands: 3+3=6 different purpose.
i. ATTRIB
ii. XCOPY (f) XCOPY is an external command.

8. What is meant by cell referencing? Explain the
difference between Relative and Absolute cell (g) The command for listing the files in specified
referencing. 2+4=6 directory and all subdirectories is DIR/S.

9. What are anchored and floating toolbars. 2+4=6 (h) The default alignment settings in EXCEL for text
and values are right and left respectively.
10. What is a recycle bin? How will you recover and remove
deleted files/folders from recycle bin? What is the (i) Every octal digit can be represented as an eight
default size of the recycle bin? 2+3+1=6 bit binary number.

11. What are Bullets and Numbering and why are they (j) Information stored in secondary memory is
used in a document? 3+3=6 permanent.

HS/XI/V/CT/Paper-I/20 HS/XI/V/CT/Paper-I/20

(5) (6)

(d) A storage that supplements the primary internal iii. both i. and ii. are correct
storage of a computer
iv. none of the above
i. secondary storage
ii. primary storage
(h) Which file in MSDOS contains external commands
iii. back-end storage that are loaded during booting process?
iv. background storage. i. IO.SYS
ii. MSDOS.SYS
(e) Software designed for a specific purpose is called
iii. COMMAND.COM
as
iv. CONFIG.SYS.
i. system program
ii. application program
iii. specific program (i) The REN command

iv. assembly program i. is used to change the name of the file or files
you specify
ii. cannot be used to rename files across drives
(f) A button is
iii. cannot be used to move files to a different
i. a graphical representation of an option location
ii. a command that activates an option iv. all of the above
iii. like one on a household appliance that
activates an action
(j) To display the names of files present in the
iv. all of the above
directory in wide format, the command used is
i. dir/p
(g) A folder is
ii. dir/s
i. an organizational tool used to store files
iii. dir/w
ii. synonymous with directory, but folder is the
newer term iv. None of the above

HS/XI/V/CT/Paper-I/20 HS/XI/V/CT/Paper-I/20

(4) (7)

3. Multiple Choice Questions: 1  10  10 SECTION – II

(a) The basic operations performed by a computer
( Marks : 18 )
are

i. Arithmetic operation
4. Write short notes in not more than three sentences
ii. Logical operation each (Any six). 3  6  18

iii. Storage
a. System Software.
iv. All of the above
b. List the steps to convert an existing text into a
table in Word.
(b) Which file in MSDOS contains internal
commands that are loaded during booting
process? c. Distinguish between RAM and ROM.

i. IO.SYS
d. What are tab stops? List down the various types
ii. MSDOS.SYS
of tabs supported in Word.
iii. COMMAND.COM

iv. CONFIG.SYS e. What is meant by Font? How is it useful in
formatting characters?

(c) An Assembly Language is
f. What is a Hard Disk?
i. Processor independent

ii. Processor dependent g. Explain the terms Superscript and Subscript text.

iii. Problem dependent
h. Mention two differences between internal and
iv. None of the above external commands in DOS.

HS/XI/V/CT/Paper-I/20 HS/XI/V/CT/Paper-I/20

(2) (9)

(b) The DOS command used to rename files is 12. What is usefulness of PowerPoint? 6
_________.

(c) All dot-matrix printers are _________ devices. GROUP – II

( Marks : 16 )
(d) A built-in number that identifies a location in
storage is the _________.
Answer any two questions:
(e) The number of bits in 4 bytes is _________.
13. What is an Assembly language? How does it differ from
a High Level Language. 4+4=8
(f) The speed at which a microprocessor executes
instructions is called ________ speed.
14. What is meant by scrolling in MSWord? Write down
(g) A _________ chart shows the proportional size of the shortcut keys to: 2  1 6  8
items that make up a data series to the sum of the (i) Create a New document
items. (ii) Open and existing document
(iii) Save a document
(h) The shortcut key to paste text in a document is
_________. (iv) Copy text in a document
(v) Cut text in a document
(i) The intersection of a column and row is known as (vi) Paste text in a document
________.

15. What do the terms Desktop and Icons mean? Explain
(j) The scanner is an example of an ________ device.
what are check boxes and radio buttons in Windows.
List of words/phrases:
2 4  8
16. Explain the difference between Left, Center, Right and
Ctrl+C 16 NEWNAME memory 32 Input Justified alignments. When you do think left
justification is preferable over justified alignment?
non-impact impact Ctrl+V RENAME or REN address word wrap
4+4=8
worksheet bar cell processing Ctrl+X pie


HS/XI/V/CT/Paper-I/20 HS/XI/V/CT/Paper-I/20

(8) Total No. of Printed Pages ––8
HS/XI/V/CT/Paper-II/20
UNIT– III
2020
11. Write a note on ‘switch’? Mention its syntax with
example? 3+3=6 COMPUTER PROGRAMMING IN C
COMPUTER TECHNIQUE ( Paper - II )
12. What is the purpose of ‘while’ statement? When is
the logical expression evaluated. What is the minimum ( Vocational Stream : Theory )
number of times that a while loop can be executed? 6
Full Marks : 100
Time : 3 hours
l3. What is a Union? What are the declaration of a Union?
Explain with example? 2+4=6
The figures in the margin indicate full marks for the questions
General Instructions :
UNIT – IV
(i) Write all the answers in the Answer Script
(ii) Attempt Part –– A Objective Questions serially
14. What are arguments? What is their purpose? What
other term is sometimes used for an argument? (iii) Attempt all parts of a question together at one place
3+2+2=7
15. What are function prototype? What is their purpose?
( PART : A –– OBJECTIVE )
Where are function prototype normally placed in a
program? 3+2+2=7 ( Marks : 50 )

SECTION – I
16. How arguments are passed to functions? What is the
difference between ‘passing by value’ and ‘passing by 1. Fill in the blanks from the list of words/phrases given
reference’. 3 12  3 12 = 7 at the end: 1 20  20
(a) The expression containing all the integer

operands is called _______ expression.

(b) The operator _______ cannot be used with real
operands.

HS/XI/V/CT/Paper-II/20 HS/XI/V/CT/Paper-II/20

(6) (3)

(d) In ‘switch’ statement, each case instance value (m) The statement is used to alter normal
must be _______? sequence of execution by transferring control to
some other part of program.
(i) Constant

(ii) Variable (n) The statement is use to bypass the
remainder of the current pass through a loop.
(iii) Special symbol
(o) Return statement returns only
(iv) None of the above
expression.

(p) When a function call itself, each innovation gets
(e) Recursive functions are executed in a?
a fresh set of variables, independent of
(i) First In First Out order the previous invocation.

(ii) Load balancing (q) An array always contains data of type.
(iii) Parallel Fashion
(r) Array elements can be accessed .
(iv) Last In First Out order
(s) A contiguous list can be implemented using an
.
4. Write the following in not more than 4 to 5 sentences
each (Any five) : 3  5  15
(t) A pointer variable can be assigned of
(a) Identifiers in C ordinary variable.

(b) Bitwise operators List of Phrases/words :
(c) What is Algorithm? Integer Macro Reserved Value Address
(d) ‘Comma’ operator String Six String constant Automatic Integer
(e) Operator precedence Float Logical Continue Seven *
goto randomly Sizeof Single value real
(f) ‘Type Cast’ in C language
union array Same structure %
(g) What are ‘members’ in structure.

HS/XI/V/CT/Paper-II/20 HS/XI/V/CT/Paper-II/20

(4) (5)

2. State whether the following statements are True or 3. Choose the correct option from the following questions:
False: 110  10 1 5  5
(a) A ‘C’ variable cannot start with
(a) One cannot have octal or hexadecimal integer
(i) An alphabet
constants in C.
(ii) A number
(b) Unsigned integers can have values ranging from
negative minimum to a positive maximum. (iii) A special symbol other than underscore

(iv) Both (ii) and (iii).
(c) A ‘char’ type has an equivalent integer
interpretation; so it is really a special kind of
short integer.
(b) What is right way to initialization array?
(d) When a variable ‘ i’ is incremented with the
operation i++ in a statement, it means that ‘i’ (i) int num [6] = {2, 4, 12, 5, 45, 5};
has to be incremented before the statement is
executed. (ii) int n { } = {2, 4, 12, 5, 45, 5};

(e) Relational operators have lower precedence than (iii) int n {6} = {2, 4, 12}
arithmetic operators.
(iv) int n (6) = {2, 4, 12.5, 45, 5};
(f) The ‘e’ in getche function means it echoes the
character that is typed.

(g) It is not possible to have formatted input/output (c) ‘Bitwise’ operators can operate upon?
in C.
(i) Double and chars
(h) Every C program must have a main ( ) function.
(ii) Floats and doubles
(i) It is not possible to have nested ‘if-else’
statements in C.
(iii) Int and floats
(j) It is not possible to have switch statements nested
within while or for loops. (iv) Ints and chars.

HS/XI/V/CT/Paper-II/20 HS/XI/V/CT/Paper-II/20

(2) (7)

(c) C supports as many as relational SECTION – II
operands.
( PART : B – DESCRIPTIVE )

(d) An expression that combines two or more ( Marks : 50 )
relational expressions is termed as
expression. Answer ANY TWO questions from each UNIT

(e) The operator returns the number of
bytes the operand occupies. UNIT– I

(f) A consists of any number of consecutive 5. What is ‘typedef’ in C? Explain its advantage with
character, enclosed in a double quotation marks. example. 2+4=6

(g) All character are represented internally as 6. Name and describe the basic data types in C. Explain. 6
.
7. Describe two different ways that floating–point
(h) An automatic variable does not retain its constants can be written. What special rules apply in
once control is transferred out of its each case? 6
defining function.

(i) The data type double is actually double precision UNIT– II
type of data.
8. Write a note on the ‘for’ loop using its syntax? Give
(j) In C ‘while’ is word. example. 4+2=6

(k) #define statement call for simplest type of 9. What is an operator? Describe several different types
substitution. of operators that are included with the C language.
2+4=6
(l) The else portion of the ‘if-else’ statement is 10. Explain the five arithmetic operators in C. Summarize
. the rules associated with their use. 3+3=6

HS/XI/V/CT/Paper-II/20 HS/XI/V/CT/Paper-II/20

( 10 ) Total No. of Printed Pages ––10

HS/XI/V/CT/Paper-III/20
(a) Find out the number of employees working in
various departments in the OFFICE database
2020
[TOTAL command can be use].
DATABASE MANAGEMENT SYSTEM ( Using Foxpro )

(b) Modify the OFF_REP to display the serial number COMPUTER TECHNIQUE ( Paper – III )
before the name of employee.
( Vocational Stream )

( Theory )
(c) Modify the OFF_REP file to display the following
at the end of the report: Full Marks : 100
(i) The sum of the Basic Salary field Time : 3 hours
(ii) The Maximum Basic Salary
The figures in the margin indicate full marks for the questions
General Instructions :
(d) Modify the OFF_REP report file to show the
following at the end of the report: (i) Write all the answers in the Answer Script

(i) The average Basic Salary (ii) Attempt Part –– A Objective Questions serially

(ii) The minimum Basic Salary (iii) Attempt all parts of a question together at one place

10. Write short note on ABS( ) function with example. 4 ( PART : A –– OBJECTIVE )
( Marks : 50 )
11. Mention the function of BETWEEN ( ) function and its
use. 4
1. Fill in the blanks from the list of words/phrases given
below : 1  10  10

(a) ACCEPT creates a ––––––– type variable.

HS/XI/V/CT/Paper-III/20 HS/XI/V/CT/Paper-III/20

(8) (3)

DESCRIPTIVE 2. State whether the following statements are True or
False : 1  10  10
( Marks : 50 )

PART – A (a) Normally, the size of the SORT file is the same as
the original database file. However it can be less
( Marks : 30 ) in some case.

(b) Only one relation can be established out of a
Answer ANY THREE questions from the following
database file.

5. (a) What is the function of ‘SET STATUS ON’ (c) B-CITY and B.CITY are equivalent.
2
command.
(d) A single SET RELATION command can link only
(b) What are the data types available in Foxpro?
8 two files.
Explain them with example.
(e) USE SALES IN 5 open SALE. dbf in work area 5.

6. (a) What is the function of SEEK command? Explain
with example. 6
(f) Copy STRUCTURE TO NEW copies the structure
(b) What is indexing a database file? What are its of the current file and the .CDX files.
importance? Explain. 4
(g) JOIN creates a new database file by joining two
or more database file.
7. (a) What is a Report in Foxpro? What are its features? 6
Explain. (h) The SUM command sums up the specified
numeric variables.
(b) What is a ‘Quick Report’ in Foxpro? 4
(i) Only numeric and character expression can be
used with MIN ( ).
8. (a) What is ‘Gather’ and ‘Scatter’ commands? Explain. 6
(j) If one enters COUNT after opening a database
(b) What is “??” command in Foxpro? Explain giving file, Foxpro displays the number of records in the
example. 4 database file.

HS/XI/V/CT/Paper-III/20 HS/XI/V/CT/Paper-III/20

(5) (6)

(d) What happens if you redefine a field type from (g) The _______ command clears all data from the
Numeric to Float? screen

(i) All value in the field are truncated to 4 (i) Release
decimal places
(ii) Clear
(ii) All values in the field are lost
(iii) Restore
(iii) Nothing changes
(iv) None of the above
(iv) None of the above

(e) Can you enter duplicate values in a field with a (h) ROUND (189, 89,0) returns ______
unique index?
(i) 190
(i) Yes
(ii) 189
(ii) Yes, but we get a warning message
(iii) 278
(iii) No, any duplicate value is rejected
(iv) None of the above
(iv) None of the above

(i) CTOD ( ) is the reverse of the _______ function
(f) The command to modify a report format file is –
(i) STAR ( )
(i) Edit

(ii) Modify (ii) DTOC ( )

(iii) Next (iii) String ( )

(iv) None of the above (iv) None of the above

HS/XI/V/CT/Paper-III/20 HS/XI/V/CT/Paper-III/20

(4) (7)

3. Choose and write the correct option: 1  10  10 (j) For each LOCATE the program must use a
corresponding _______.
(a) Which file is used to write the different types of
Foxpro program?
(i) Case
(i) Report File
(ii) ENDCASE
(ii) Label File

(iii) Program (iii) ENDDO

(iv) Index File (iv) None of the above

(b) What happens if you hold the shift key down the
click on File in the main menu? 4. Write short notes of the following in not more than
(i) The close option becomes close all three or four sentences each: (Any Five) 4  5  20

(ii) The current window stores (a) Define a database
(iii) The menu undocks and can be moved
(iv) None of the above (b) The ZAP command

(c) WAI command
(c) What does the command 3+8 do if you are on the
first record of the Customer Table? (d) THE STRUCTURE of a database
(i) Store 11 in the primary key of the current
record (e) THE LOCATE command
(ii) Moves to Rec. 11
(f) What is a loop?
(iii) Display the numeric value 11
(iv) None of the above (g) The AND operator

HS/XI/V/CT/Paper-III/20 HS/XI/V/CT/Paper-III/20

(2) (9)

(b) Foxpro provides the ––––––– command for sorting PART – B
records stored in a database file. ( Marks : 20 )

(c) The field name can be up to ten characters long Answer Question No. 10 and ANY ONE from the rest
and must begin with a –––––––.
9. Creat a Report file OFF_REP for the OFFICE database
(d) The LIST command lists ––––––– records on screen. file as given in the following table–

(e) A database file must be in ––––––– before we can
apply any command on it. LIST OF EMPLOYEES

(f) While defining the structure for a database file, PAGE : 1
we need to assign a unique ––––––– for each field.
Name of Employee Department Date of Joining Basic Salary
(g) The ––––––– command can be used to search for
John Sales 12/02/15 14000
data in a database file.
Christopher Finance 04/03/13 15000
(h) To add more record at the end of any database
Radha Finance 02/04/12 16400
file use the command –––––––.
Rahul Purchase 06/05/15 14560
(i) The ––––––– command is used to exit from Foxpro
to DOS. Rubel Finance 19/06/16 13550

Joseph Purchase 20/01/14 18000
(j) To define the page length for a report, select page
layout from ––––––– menu. Henry Sales 02/04/14 19000

Prabhu Purchase 04/06/11 20800
Lists of Words/Phrases/Keywords:
Nayak Finance 06/03/12 16900
Character LOCATE String SEEK Use

INDEX SORT Fieldno Letter All Based on the above table, write the commands to
perform the following task: 4  4  16
APPEND Quit Report Form EXIT

HS/XI/V/CT/Paper-III/20 HS/XI/V/CT/Paper-III/20