Responsive image
Responsive image
Responsive image

FINAL EXAMINATION MODEL SET
CLASS 9
Time: 1:30 hrs.        Full Marks: 50          Pass Marks: 20

Group ‘A’ (QBASIC) 35 Marks

1. Answer the following questions (3x2=6)
a. What is an array? List any two advantages of using an array.
b. What is a user defined function? List any two numeric and string function examples.
c. What is loop? List any two conditional branching statements used in QBASIC?

2. a) Convert as instructed (2x1=2)
i. (FCB)16 into Octal     ii. (749)10 to Binary     
b) Perform binary operation (2x1=2)
i. 1101*11-1101            ii. 1101101/110

3. Write the following programs (4x2=8)
a. To display the entered number is prime or composite.
b. To display the area and circumference of a circle having radius 5 cm.
c. To display the greatest number among the list of given numbers (DATA 12,45,10,55,42,88,37)
d. To display the reverse word for any input word by a user.

4. Write a programs to generate the following series and patterns.  (4x2=8)
a. 4, 4, 8, 12, 20,……………..up to 10th terms.
b. 1, 22, 333, 4444, 55555
c. 7, 22, 11, 34, 17,………..up to 12th terms.
d.
       t
       twi
       twite
       twiter

5. Write the output of the given program showing process table. (2)
CLS
N=1768
WHILE N<>0
       R=N MOD 10
       Sum=Sum+R
       N=N\10
WEND
PRINT Sum
END

6. Debug the given program (1)
REM to display sum of odd numbers
CLS
OPTION BASE 1
DIM n(5)
DATA 52,89,41,56,74,10
FOR J=1 TO 10
       READ n
       IF n MOD 2=0 THEN s=s+n
NEXT
PRINT s
EXIT

7. Study the given program and answer the following questions (2x1=2)
CLS
N$= “monitor”
FOR j= 1 TO LEN(N$)
       PRINT LEFT$(n$,j)
NEXT j
END
Questions:
a. Write the numeric and string variables used in the above program?
b. List the library functions used in the above program.

8. Write the following programs       (3x3=9)
a. To check whether the input number is palindrome or not.
b. To display the numbers in ascending order using an array. [DATA 10,5,9,44,68,225,74,88,30,105]
c. To display the total number of vowels and consonants present in word entered by a user.

Group ‘B’(MS-Access) 10Marks

9. Answer the following questions in short: (3x2=6)
a. What is a database and DBMS? 
b. What is a primary key? List any two uses of Query
c. Define Report. List any two uses of form.

10. Select the correct answer: (4x0.5=2)
(a) The maximum size for field name in MS-Access is ……….
(i) 50  (ii) 64   (iii) 65535  (iv) 255
(b) The extension of database file in Access is ……..
(i) .DBF (ii) .MDB (iii) .DMB (iv) .DBM
(c) …...... uniquely identifies any field.
(i) Indexing  (ii) Memo Field (iii) Primary Key (iv) Query
(d) The objects of Access that stores the data is known as ………
(i) Query   (ii) Table (iii) Form  (iv) Report

11. Match the following: (4x0.5=2)


Group A

Group B

dBase

Retrieves data

Indexing data

To store e-mail address

Hyperlink

DBMS

Caption

Searching fast

 

2048 characters



Post Your Comment Here