CBSE Sample Paper Class 12 Business Data Processing 2012

Advertisements

 

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 ?

For further information regarding CBSE Sample Paper Class 12 Business Data Processing, connect with us on facebook, google+ and twitter.


Ask a Question:

  • which operator(s) has (have) the highest order of precedence in arithmetic expressions?

    bishal limbu on 30 Jan 2013
  • the question paper of office data processing 2012 final exams of eastcape midlands college

    xolelwa saul on 30 Jan 2013
  • what is dos operating system?explain the internal and exteranal commands?

    poonam sahay on 09 Jan 2013
  • What are properties of Reports and Sub-reports ? Define the following with example :

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

    poonam sahay on 09 Jan 2013
  • write a program in VB to generate an even number series upto nth term? write a function in VB to accept a number in text box and arrange number in increasing order?

    radhika on 17 Mar 2012
  • What are properties of Reports and Sub-reports ? How can Sub-report be linked to Main report in MS-Access ?

    pooja rani on 15 Feb 2012
  • iv) Write a program in VB to generate an even number series upto nth term

    susang on 12 Mar 2011
  • ms excel is the tool used for which
    management in buisness data procesing

    indu on 12 Mar 2011
  • 3. Define the following with example :

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

    samir on 07 Jan 2011
  • 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

    samir on 07 Jan 2011