CBSE Question Paper 2007 class 12 Informatics Practices

myCBSEguide App

myCBSEguide App

Complete Guide for CBSE Students

NCERT Solutions, NCERT Exemplars, Revison Notes, Free Videos, CBSE Papers, MCQ Tests & more.

Download Now

 

CBSE Question Paper 2007 class 12 Informatics Practices conducted by Central Board of Secondary Education, New Delhi in the month of March 2007. CBSE previous year question papers with solution are available in myCBSEguide mobile app and cbse guide website. The Best CBSE App for students and teachers is myCBSEguide which provides complete study material and practice papers to CBSE schools in India and abroad.

CBSE Question Paper 2007 class 12 Informatics Practices

Download as PDF

CBSE Question Paper 2007 class 12 Informatics Practices

General Instructions:

  • This question paper is divided into 3 sections.
  • Section A consists of 30 marks.
  • Section B and Section C are of 20 marks each.
  • Answer the questions after carefully reading the text.

Section-A

1. Answer the following questions:

(a) Define (i) Freeware (ii) Shareware (2)
(b) Write one point of difference between front end and back end with one example of each. (2)
(c) Write one example each of “one to many” and “many to many” relationships between two entity sets. (2)
(d) What is the purpose of Data Mining? (2)
(e) During System Development Life Cycle, in which phase is the scope and true nature of problem determined? Explain in brief with the help of an example. (2)

2. Answer the following questions:

(a) How many value(s) does a Procedure and a Function return? (2)
(b) Distinguish between Single Document Interface and Multiple Document Interface. Write one example each of SDI and MDI type application. (2)
(c) What is Selection statement? Name any two selection statements that VB provides. (2)
(d) What are Events? What are Event Procedures? How are they related? (2)
(e) What is a Bound Control? Name any two data-aware properties of bound controls. (2)

3. Answer the following questions:

(a) Which statement must be present in a simple loop (Loop. Endloop) so that it does not become an infinite loop? (1)
(b) Suggest parameters mode (IN/OUT/IN OUT) for the following: (1)
(i) Parameter can be used as a normal variable.
(ii) Passed value must not get changed.

(c) Write two points of differences between SQL and PL/SQL. (2)
(d) How are triggers similar to Constraints? Write one point. (2)
(e) What is the purpose of cursor in PL/SQL? Name the types of cursors used in PL/SQL. (2)
(f) Why do we use Rollback statement? Explain in brief with the help of an example. (2)


Section-B

4. Read the following case study and answer the questions that follow:
ABC Company has developed the following interface to enter and display data related to Income tax of employees.
CBSE Question Paper 2007 class 12 Informatics Practices

The form details of the above form are given in the following table:

Object Type Object Name Description
FormFrmSalaryThe main Form Object
Text boxTxtEmpCodeTo enter code of Employee.
TxtNameTo enter Name of Employee.
TxtlncomeTo enter Taxable Income of Employee.
TxtlTaxTo display Income tax
TxtEdTaxTo display Educational tax
TxtSurchargeTo display Surcharge
TxtTotalTaxTo display Total Tax to be paid by the
employee.
Command ButtoncmdCalculateTo calculate Income tax, Education
Tax, Surcharge and Total Tax
cmdClearTo clear all the values in Text boxes
cmdExitTo close the application.

Write code to implement the following:

(a) When the form loads text boxes for Income tax, Education Tax, Surcharge and Total Tax Amount should be disabled. They should be enabled only when Calculate command button is clicked. (2)
(b) Taxable Income entered should be numeric data. (2)
(c) When the user clicks the Clear command button, textboxes EmpCode and EmpName should be set to blank and other textboxes should be set to zero. (2)
(d) When Calculate command button is clicked, Income tax, Education Tax, Surcharge and Total Tax (sum of Income Tax, Education Tax, Surcharge) is displayed in their respective text boxes based on the following criterion. (4)

Taxable Income Income Tax Education Tax Surcharge
UptoRs. 1,00,000NilNilNil
Rs. 1,00,001 to 1,50,00010% of the
amount exceeding
Rs. 1,00,000
2% of Taxable
Income
Nil
Rs. 1,50,001 to 2,50,000Rs. 5,000+20% of
amount exceeding
Rs. 1,50,000
2% of Taxable
Income
Nil
Rs. 2,50,001 and aboveRs. 25,000+30% of
the amount exceeding
Rs. 2,50,000
2% of Taxable
Income
l% of
Taxable
Income.

5. Answer the following questions:

(a) How many times will the following loop execute? (2)
1 = 6
Do While I > = -1
I -1-2
Print I
Loop

(b) Write the output that the following code segment will generate (2)

String1 = “Class XII”
String2 = “XI”
Print String1 + String2
print InStr (String1, String2)
Mid (LCase(String1), 6, 3)
Print Int(4.7) + Len(String 2)

(c) Rewrite the following code using If Elself 2
Select Case Code
Case Is > 45
Message1 = “Ersor”
Case10 To 20
Message 1 = “Accounts”
Case 21 To 30
Message 1 = “Personnel”
Case 31 To 45
Message 1 = “EDP”
Case Else
Message 1 = “Access Denied”
End Select

(d) Write a function that receives two integers as arguments and returns the following: 4
0 if both are equal
– 1 if first is greater than the second
1 if second is greater than the first


Section-C

6. Read the questions given below and answer accordingly:

(a) Write PL/SQL cursor declaration to store Employee code(EMPNO), Employee name(ENAME) of employees from Emp table who are located (LOC) in Delhi. (2)

(b) Write the output produced by the following code in PL/SQL (2)

declare
cnt number;
num number;
begin
cnt: – 8;
num : = 4;
while cnt>4 loop
num : = num-2;
cnt: = cnt-1;
if cnt>4 then
dbms_output.put_line(cnt);
end if;
end loop;
dbms_output.put_line(num);
end;

(c) Find error(s) in the following PL/SQL code and rewrite the correct code after underlining the corrections made. (2)

DECLARE
CTR NUMBER;
SUM1 NUMBER;90/1 6
BEGIN
CTR: = 0;
SUM1: = 0;
LOOP
SUM1: = SUM1 + CTR;
PRINT(TO_CHAR(SUM1));
CTR: = CTR-2;
IF CTR > 2 THEN
EXIT;
END LOOP;

(d) Create a procedure called Select employee that selects the first name, last name, join date, and salary for employee with employee code 100 from EMP table into variables and displays values stored in these variables.

Table Emp consists of fields with field names: ID,
FIRST_NAME, LAST_NAME, JOIN_DATE, SALARY 4

7. Answer questions based on the table Student given below:

Table: Student

Column Name Data Type Size Description Constraint
RollNumberNUMBER2Student’s Roll
number
Primary key
NameVARCHAR225Name of StudentNOT NULL
ClassVARCHAR23Class of Student
StreamVARCHAR215Stream opted by
the Student
TotalMarksNUMBER8,2Total marks scored
by the student
GradeVARCHAR21Grade scored by
the student
Can be’ A’
or ‘B’ or ‘C

(a) Write SQL command to display Roll numbers, names, Total marks and grades of all the students in “Nonmedical” stream sorted by Total marks in descending order. (2)

(b) Write SQL command to create a view consisting of all students in “Medical” stream and who have scored “A” grade. (2)

(c) Write PL/SQL Procedure that takes in Student’s Roll number as a parameter and increases Total marks of that student by 2% (as he/she is a Sports person.) (3)

(d) Create a Trigger to display the name and stream of Student(s) whose record(s) is/are being deleted from the Student table. (3)

These are questions only. To view and download complete question paper with solution install myCBSEguide App from google play store or log in to our student dashboard.

Download myCBSEguide App

CBSE Question Paper 2007 class 12 Informatics Practices

Download class 12 Informatics Practices question paper with solution from best CBSE App the myCBSEguide. CBSE class 12 Informatics Practices question paper 2007 in PDF format with solution will help you to understand the latest question paper pattern and marking scheme of the CBSE board examination. You will get to know the difficulty level of the question paper.

Previous Year Question Paper for class 12 in PDF

CBSE question papers 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005 and so on for all the subjects are available under this download link. Practicing real question paper certainly helps students to get confidence and improve performance in weak areas.

To download CBSE Question Paper class 12 Accountancy, Chemistry, Physics, History, Political Science, Economics, Geography, Computer Science, Home Science, Accountancy, Business Studies and Home Science; do check myCBSEguide app or website. myCBSEguide provides sample papers with solution, test papers for chapter-wise practice, NCERT solutions, NCERT Exemplar solutions, quick revision notes for ready reference, CBSE guess papers and CBSE important question papers. Sample Paper all are made available through the best app for CBSE students and myCBSEguide website.




Test Generator

Test Generator

Create Papers with your Name & Logo

Try it Now (Free)

Leave a Comment