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.


Tags: 12th cbse result of arts baldeep kaur rollno 2699744schoolno25255, it bdp dtp class xii vocational subject sample paper, sample problem exams in data processing, solved previous years question papers 12th business data processing


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