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

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

HS/XI/V/CT/Paper-III/18
(b) In Foxpro the field name must begin with a ________
2018
(c) ? MOD (1965,100) returns _______
DATABASE MANAGEMENT SYSTEM ( Using Foxpro )
(d) The _______ command can be used to search for
COMPUTER TECHNIQUE ( Paper – III ) data in a database file.
( Vocational Stream )
(e) ? ROUND (1234.6, -2) returns _______.
( Theory )
(f) The _______ command to printer.
Full Marks : 100
(g) The_______ function returns the name of month
Time : 3 hours from a date expression.

The figures in the margin indicate full marks for the questions (h) The_______ function returns the name of year from
a date expression.
General Instructions :
(i) Write all the answers in the Answer Script (i) _______ command create empty character variable.

(ii) Attempt Part –– A Objective Questions serially (j) ? CEILING (189.89) returns_______.
(iii) Attempt all parts of a question together at one place
SEARCH SET PRINT ON LOCATE COPY CMONTH

( PART : A –– OBJECTIVE ) Character integer APPEND INDEX 96
( Marks : 48 ) SPACE( ) 1200 YEAR ( ) 65 190

MONTH ( ) CASE 180 ELSE 1235
1. Fill in the blanks from the list of words/phrases given
below : 1  10  10 2. State whether the following statements are True
or False : 1  10  10
(a) To add more record at the end of any database file
use the command –––––––.
(a) BROWSE can prohibit deletion of records.

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

(3) (4)

(b) Foxpro menu system has no option to deletion of (iii) Display the value of the variable whose name
records. is stored in the variable named company

(c) The field width in the browser window can be (iv) None of the above
changed.

(d) RECALL undelete records deleted from the (b) What happen if we hold the shift key down then
database with PACK. click on file in the main menu?
(i) The close option becomes close all
(e) One can use Foxpro function with SORT and
INDEX. (ii) The current window closes
(iii) The menu unlocks and can be moved
(f) The report window is divided into three parts.
(iv) None of the above

(g) To preview a report while designing it press  p .
(c) Which of the following is the Primary key field in a
(h) The RECORD ( ) function returns the current STUDENT database file –
record number.
(i) NAME

(i) A report can include upto a maximum of 7 page (ii) SECTION
header file. (iii) ROLL_NO

(j) The use of OTHERWISE with DO CASE- ENDCASE (iv) None of the above
is optional.

3. Choose and write the correct answer: (d) What is the appropriate command to explore the
1  10  10
database file –
(a) If the CUSTOMER table is open, what does the (i) BROWSE
following command do:
(ii) APPEND
(i) Display the same value of the company field
(iii) EDIT
(ii) Display the character “company” (iv) MOD

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

(5) (6)

(e) What happens if we redefine a field type from (h) What is the command to open a particular
Numeric to Float? database file–

(i) All values in the field are truncated to 4 decimal (i) USE <database name >

(ii) All values in the field are lost (ii) OPEN <database name >

(iii) Nothing changes (iii) Open

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

(f) What is the function, returns the nearest integer (i) What is the command to print a particular list of
that is greater than or equal to the specific numeric records–
expression –
(i) TO PRN
(i) INT( )
(ii) LIST TO PRINT
(ii) CEILING ( )
(iii) PRINT RECORD TO PRN
(iii) ABS ( )
(iv) None of the above
(iv) MIN ( )

(j) The command that selects an index file/tag for a
(g) What is the extension of database file database file is –

(i) .DB (i) SELECT INDEX

(ii) .DAT (ii) SELECT ORDER

(iii) .DBF (iii) SET ORDER

(iv) .DBE (iv) None of the above

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

(7) (8)

4. Write short notes in not more than three or four 6. (a) Explain the use of SEARCH and LOCATE
sentences each: (Any six) 3  6  18 command in Foxpro. 5 + 5 = 10
(a) Field INDEX
(b) Explain the feature of Foxpro Report.
(b) What is the meaning of “SET DEFAULT TO A:”?
(c) CREATE command
(d) What is an ‘Attribute in DBMS’? 7. (a) What are the advantage of relational database?
(e) What is the purpose of ‘SET TALK OFF’ command? Explain 4 + 6 = 10
(f) SET Clock.
(b) Explain the difference between the following:
(g) What is an ‘entity’ in DBMS?
(i) APPEND and APPEND BLANK
(h) What is the purpose of ‘AND’ operator?
(ii) DOW ( ) and CDOW ( )

DESCRIPTIVE

( Marks : 52 )
8. (a) Explain the concept of ‘IF–ENDIF’ and
‘DO-CASE –END CASE’. Give example. 4 + 6 = 10
PART – A

( Marks : 30 ) (b) What is an ‘Index file’? What is the procedure to
‘Index File’ on multiple fields?

Answer ANY THREE questions from the following

5. (a) What is a database File, Record and Field? Explain.
9. (a) Write a program in Foxpro to print n Fibonacci
(b) Explain the difference between the following– numbers. 5 + 5 = 10

(i) EDIT and CHANGE (b) Explain COPY TO ARRAY AND APPEND FROM
ARRAY.
(ii) SORT and INDEX

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

(9) ( 10 )

PART – B (b) Delete temporarily all the students whose Date of
Admission was in the year 2006. After doing so,
( Marks : 22 ) Restore the Date of Admission.
Answer Question No. 10 and ANY ONE from the rest.
(c) Index on the field ROLL_NO. Use the index field
(ROLL_NO), to find a particular roll number, which
10. Consider a table STUDENT.DBF with the following has been entered earlier.
structure :
(d) Print the structure of the file STUDENT.DBF
Field Name Type (size) Remarks database along with all entities.

ROLL_NO Numeric(5) Roll Number of students
11. What is the function and purpose of the SCATTER and
NAME Character (30) Name of the student GATHER command? 6
STREAM Character (10) Stream of
Or
DEPT Character (10) Department
12. (a) What is a memory variable? Explain. 3+3=6
GENDER Character (1) Gender (M or F)

DOB Date (10) Date of Birth (b) Explain the usage of ‘@’ command.

DOA Date(10) Date of Admission

CLASS Character (12) Class in which he/she study

CITY Character (20) City where he/she belongs

STATE Character (20) State where he/she belongs

Write the commands to complete the following queries:—
4  4  16
(a) Display the Roll No and Date of admission of the
student of “Arts” stream admitted in 2008.

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