MBOSE Class 11 Question Paper 2019 for Computer Technique Paper - III

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

HS/XI/V/CT/Paper-III/19
(b) ________ moves the record pointer n records below
2019 the present record position.

DATABASE MANAGEMENT SYSTEM ( Using Foxpro ) (c) The default file extension name used with
program files is _______.
COMPUTER TECHNIQUE ( Paper – III )
(d) To add a comment to an executable command,
( Vocational Stream ) prefix the comment with _______.
( Theory )
(e) _______ permanently removes deleted records
from the database.
Full Marks : 100
Time : 3 hours (f) _______ command pauses operation; “Press any
key...” prompt.

The figures in the margin indicate full marks for the questions (g) _______ will allow us to change the structure of
General Instructions : any database.

(i) Write all the answers in the Answer Script (h) The command_______ to display all the records
(ii) Attempt Part –– A Objective Questions serially in screen/monitor.

(iii) Attempt all parts of a question together at one place (i) _______ information means to group, arrange or
classify it in some known order.

( PART : A –– OBJECTIVE ) (j) The _______ command to printer.

( Marks : 48 ) List of Words/Phrases/Keywords:

.Dat M STRU LIST WAIT DISPLAY
1. Fill in the blanks from the list of words/phrases given
below : 1  10  10 ** EIGHT PRN .PRG MODI STRU

.DAT SORTING DELETE PACK &&
(a) The field name can be up to ––––––– characters
long and must begin with a letter. SHIFT STOP SKIP KILL @@

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

(3) (4)

2. State whether the following statements are True or 3. Choose and write the correct answer: 1  10  10
False : 1  10  10
(a) Which of the following is the database, where we
(a) SET CONFIRM ON cursor advance to the next field can store any amount of data, pictures, digitized
/ record only on pressing the Enter key.
sound etc.

(b) RECALL undelete records deleted from the (i) General
database with PACK.
(ii) Memo
(c) BROWSE has a facility to turn off the vertical
(iii) Numeric
gridlines.
(iv) Float
(d) The Edit (change) window can be repositioned
anywhere on the screen.
(b) Which of the following are considered as an
(e) A database file is use cannot be copied but can attribute –
be renamed.
(i) School

(f) One can use foxpro functions with SORT and (ii) Roll No.
INDEX. (iii) Primary key

(g) One can index a database file in the descending (iv) None of the above
order in all cases.
(c) The function to remove leading and trailing space
(h) Data stored in an element of an array cannot be
from a character expression is –
modified.
(i) TRIM ( )
(i) The report window is divided into parts. (ii) LTRIM ( )

(j) Condition and scope can be used with SCATTER. (iii) RTRIM ( )
(iv) ALLTRIM ( )

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

(5) (6)

(d) ‘ACCEPT’ command creates a type of variable (g) Which of the following command will give the
– program execution a pause –
(i) Numeric
(i) PAUSE
(ii) Memo
(ii) WAIT
(iii) Character
(iv) None of the above (iii) CASE

(iv) None of the above

(e) Which of the following appropriate command to
determine whether or not Foxpro displays
response to certain commands on the screen or (h) The purpose of the EXIT command in Foxpro is
a window – to

(i) SET TALK ON (i) Take out of a conditional loop

(ii) SET STATUS ON (ii) Take out of Foxpro

(iii) SET RESOURCE ON (iii) Transfer the control to a different procedure
(iv) None of the above (iv) None of the above

(f) Which of the following symbol used to an
(i) Round (189,89,0) returns
executable command, prefix the comment with –
(i) 188
(i) **
(ii) 191
(ii) &&

(iii) == (iii) 190

(iv) (iv) 189.9

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

(7) (8)

(j) What will be the function returns the square root DESCRIPTIVE
of 120 – ( Marks : 52 )

(i) SQT ( ) PART – A

(ii) SQRT (120) ( Marks : 30 )

(iii) SQT (120) Answer ANY THREE questions from the following

(iv) None of the above
5. (a) Write short notes on the following functions:
(Any Two) : 2 1 2  2 12  5
(i) SET CENTUARY
4. Write short notes of the following in not more than
(ii) SET STATUS BAR
three or four sentences each: (Any six) 3  6  18
(iii) SET REFRESH
(a) The .OR. operator Distinguish between: (Any Two)
(b) 2 1 2  2 12  5
(b) SET RELATION (i) FIND and SEEK
(ii) Display Structure and List Structure
(c) DISPLAY command
(iii) DELETE AND PACK
(d) DELETE command
6. (a) Briefly explain the Compound index file in Foxpro. 4
(e) COUNTER FOR
(b) What is the purpose of REPLACE command? Give
its syntax with example. 6
(f) The ‘DATABASE’ files

(g) The ‘INDEX’ file 7. (a) Explain with example the usage of any two of the
following : 3+3=6
(h) LOCATE Command (i) ALLTRIM ( )
(ii) AT ( )
(i) PACK command
(iii) CMONTH ( )

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

(9) ( 10 )

(b) Write the syntax of the @...SAY command and (a) Display those students list who takes books, which
@... GET command. 2+2=4 were published in the year 2014.
(b) Display those books name starts with the alphabet
8. (a) What is a variable in DBMS program? Explain
‘A’.
with suitable example. 2+2=4
(c) Display those books list which are in hand of the
(b) Write short notes on the use of the following
Librarian.
functions: 23  6
(d) Take a printout of those books name, whose Price
(i) FLOOR ( )
is more than Rs. 200.
(ii) DAY ( )
(iii) ROUND ( ) 10. Define the memory variable. Explain the three ways
to create memory variable in Foxpro. 2+4=6
PART – B

( Marks : 22 ) 11. Explain briefly the use of ‘SCAN’ and ‘ENDSCAN’ in a
Foxpro program. What is the use of ‘LOOP’ an ‘EXIT’
Answer Question No. 10 and ANY ONE from the rest.
in the ‘DO-WHILE’ --- ‘ENDDO’ structure? 2+4=6
9. Consider the following table LIBRARY.DBF with the
structure details : 4  4  16 

FIELD NAME TYPE (SIZE) REMARK EXAMPLE
ISBN Numeric A unique number LB001, LB002,...
BK _NAME Character (80) Book Name Foxpro 2.5, Programming
SUBJECT Character(25) Subjects Macro Economics.
AUTHOR Character(50) Writer’s name Fundamental of ‘Python’
PRICE Numeric(8) Price of the book Rs. 439.50
EDITION Numeric(4) Year of Publication 2012
COPIES Numeric(3) Total Copy purchased 460
QWS Numeric(3) Quantity With Students 205
QOH Numeric(3) Quantity On Hand 309

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