CBSE-Sample Paper

Class-XII-2010

Business Data Processing

Time allowed : 3 hours

Maximum Marks : 50

Note :- All questions are compulsory.

1. Fill in the blanks :

(i) DML stands for _____________ .
(ii) OLE stands for _____________ .
(iii) JPG stands for ______________ .
(iv) RTF stands for ______________ .
(v) MS-Excel is the tool for _____________ management.
(vi) MS-Access is the tool for _____________ management.
(vii) Address of second cell in the worksheet of MS-Excel is _____________ .
(viii) Extension used in VB is _____________ .
(ix) Extension used in Paintbrush file is _____________ .
(x) Extension of worksheet in MS-Excel is _____________ .
(xi) Extension of database in MS-Access is ____________ .
(xii) Events are used in _____________ .
(xiii) Create or Use is used in __________ package.
(xiv) _________ is operator used for building complex condition.

2. Multiple choice questions :

(i) Which of the following is not a part of MS-Office ?

• MS-Word
• MS-Excel
• Tally
• VB

(ii) Which of the following is not supported by MS-Word ?

• .RTF
• .DOC
• .TXT
• .EXE

(iii) Address of second cell in a worksheet is

• C2
• 2
• 2C
• None of the above

(iv) Which of the functions is used for building complex condition ?

• Relation operators
• Arithmetic operators
• Logical operators
• None of the above

(v) Identify the multirow function

• Avg
• Create
• Delete
• None of the above

(vi) Active Control is associated with

• DOS
• VB
• MS-Excel
• None of the above

(vii) Following is/are a file format :

• .dbf
• .word
• .excel
• None of the above

(viii) Following is extension of Paintbrush file :

• .doc
• .pdf
• .dbf
• None of the above

(ix) JPG is a file format used for

• Moving picture compression
• Sound compression
• Text compression
• None of the above

(x) Tuple, Attribute are used in

• VB
• C language
• Database Management Package
• None of the above

(xi) VB uses

• 1 for true and 0 for false
• 1 for true and 0 for false
• 0 for true and 1 for false
• None pf the above

(xii) Which field is used to import another document in MS-Access ?

• Text
• OLE
• Numeric
• None of the above

(xiii) Which of the following is not a DML ?

• Create table
• Insert into
• Delete from
• Update

(xiv) Many programs use _________ control on a form to enable the user to enter data.

• Text box
• Combo box
• Date box
• All of the above

3. Define the following with example :

• Tuple
• Query
• Worksheet
• Relational operator
• Attribute
• ComboBox

4. Short questions

1. What is a logical operator ?
2. Give example of a DML.
3. Compare Global and Local Variable.
4. Define Degree of a Relation.
5. Explain For next loop.
6. What is CommandButton in VB ?
7. What is ComboBox in VB ?
8. What is the use of day book ?
9. Explain two types of data in VB.
10. What do you understand by Macro ?

5. Long questions :

(i) How can MS-Access import MS-Excel worksheet ?
(ii) How can we record Macros, run it and assign to Buttons in MS-Excel ? .
(iii) What are properties of Reports and Sub-reports ? How can Sub-report be linked to Main report in MS-Access ?
(iv) Write a program in VB to generate an even number series upto nth term.
(v) Write a function in VB to accept a number in TextBox and arrange number in increasing order.
(vi) Give the output of the following commands in MS-Excel :
(a) MID (“RANU PRIYA”, 3,7) RTRIM (“RAM”)
(b) LEFT (“TECHNOLOGY”, 2)
(c) LEFT (“CYBER LAW”, 3)
(d) LEFT (“ITACT2000”, 3)
(vii) Define the follpwing functions :

• PV( )
• FV( )

(viii) What is Primary Key ? Explain with example.
(ix) Compare UPDATE and UPDATE CANCEL.
(x) How can graphics be positioned on a Worksheet ?