CBSE Question Paper 2010 class 12 Informatics Practices

• 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

Q1. Answer the following questions

(a) Expand the terms OSS and W3C. (2

(b) What are the following software used for? (2)

(i) PHP

(ii) MySQ

(c) Name any four application areas of databases. (2)
(d) What are the different types of relationships that can be depicted through an ER model? Explain the concept of ER Model using the case study of a Ticket Reservation System that has three entities Ticket, Passenger and Train. Assume that each passenger can buy more than one ticket. (4)

Q2. Answer the following questions

(a) Differentiate between the FOR … NEXT and FOR EACH … NEXT loop of Visual Basic giving a suitable example of each. (2)
(b) Name and explain the usage of any two types of modules available in Visual Basic. (2)
(c) What are data-aware controls? Name any two ActiveX data-aware controls that can be used on a form (2)
d) Explain the term ADO object model. Differentiate between the Connection Timeout and Command Timeout properties of. the Connection object. (2)

Q3. Answer the following questions

(a) Differentiate between row-level and statement-level triggers. (2)
OR
(2 Marks for giving one example of each)

(b) Define the terms Candidate key and Foreign key with respect to a database. (2)

(c) Differentiate between DDL and DML commands. Give one example of each type of command (2)

(d) Mention any two advantages of PL/SQL as compared to SQL. (2)

(e) Name the keyword used to (2)

(i) Allow duplicate rows in a query.

(ii) Avoid duplicate rows in a query.

SECTION – B

4. Read the following case study and answer the questions that follow:

Mr. Presi of Super Store decided to computerize the billing department. The accounts manager at Super Store is creating billing software to generate the bill during the sale period. A new bill is generated for each item sold. The discount is given based on the item category. An additional discount of 5% is given to the Store Membership Card holders. The following is the data entry screen used at the store:

The list of controls for the above form is as follows:

(a) Write the code for the CmdClear command button to clear all the textboxes except the TxtBillDate textbox (2)

(b) Write the code for the form load event of FrmBill so as to: (2)

(i) Display the system date in the TxtBillDate textbox.
(ii) Disable the TxtBill Date, TxtDisc and TxtFinal textboxes

(c) Write the code for the change event of the TxtPrice textbox to ensure that the user does ‘not enter a negative or a zero value. If a negative or a zero value is entered then the textbox should be made blank and a warning message should be displayed. (3)

(d) Write the code for the CmdCalc command button to display the discount and final price in the TxtDisc, and TxtFinal textboxes respectively. Note that Final price is calculated as price – discount and the discount is calculated based on the category and price according to the following table. Also, remember to give an additional 5% discount for membership card holders i.e if the ChkMember checkbox is checked. (4)

Q5. Answer the following questions

(a) Find the errors from the following code segment and rewrite the corrected code underlining the correction made. (2)

Private Function IsPrime (num As Integer) As Bool
Dim limit As Integer
limit = num / 2
FOR ctr = 2 TO limit
If num Modulo ctr = 0 Then
Exit For loop
End If
Next
IsPrime = IIf(ctr > limit, True, False)
End Sub
(b) Find the output of the following code: (2)

Dim astr as string
Dim I as Integer
I = 1
astr = “Come”
Do while I <= Len (astr)
Print Mid (astr, I)
I = I + 1
LOOP

(c) Rewrite the following code using If Then Else construct without affecting the output: (2)

Dim a As Integer
a = 1
Select Case a
Case 1
Print “Sunday”
Case 2 To 6
Print “WeekDay”
Case 7
Print “Nearing Weekend”
End Select

(d) Write a Visual Basic procedure that takes a number as argument and displays the sum of all the digits in the number. For example, if the argument passed is 354, the procedure should display (12 (i.e. 3+5+4)).

Section – C

Q6. Read the questions given below and answer accordingly:

a) Write the output produced by the following PL/SQL code: (2)

DECLARE
A NUMBER;
B NUMBER;
TEMP NUMBER;
BEGIN
FOR X IN 1.. 4 LOOP
TEMP: A;
A: = B
B: = TEMP;
A := A + 1;
B := B – 1;
DBMS_OUTPUT. PUT_LINE (‘A =‘ | | A);
DBMS_OUTPUT. PUT_LINE (‘B = ‘ | | B);
END LOOP;
END;
(2 Marks for attempting or identifying that variables have not been initialized)

OR

(2 Marks to be awarded if either Q6.(b) or (c) or (d) is answered correctly)

b) Find the errors from the following PL/SQL code and rewrite the corrected code underlining the correction made (2)

DECLARATION
V_MNO MOVIES.MOVIENO%TYPE;
V_TITLE MOVIES.TITLE%TYPE;
V_PRICE MOVIES.PRICE%TYPE;
BEGIN
V_MNO EQUALS 101
LOOP
SELECT TITLE, PRICE, RATING INTO V_TITLE, V_PRICE,
V_RATE FROM MOVIES
WHERE MOVIE NO = V_MNO;
DBMS_OUTPUT.PUT TEXT (V_TITLE ||‘ ‘|| V_PRICE);
EXIT WHEN V_RATE < 4;
V_MNO : = V_MNO + 1;
LOOP END;
END;

c) Differentiate between the IN and IN OUT modes of a parameter in a PL/SQL block. (2)
d) Write a PL/SQL Function POWER that takes two numbers as arguments and returns the value of the first number raised to the power of the second. (4)

Q7. Answer the questions based on the table CompLab given below:

Table: Complab

(a) Write the SQL command to create the table CompLab including the constraints. (2)
(b) Write the SQL command to display the details of the item with the maximum It Cost. (2)
(c) Write the PL/SQL code to increase the item cost by 10% for an item code accepted from the user if the date of purchase of the item is later than 12-Oct-2005. (3)
(d) Write the PL/SQL code to create a stored procedure Disp Details to display the details of all the items with It Cat as ‘H’. The code should also display the total quantity of all such Items. (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 2010 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 2010 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.

• Physics
• Chemistry
• Mathematics
• Biology
• Accountancy
• Business Studies
• Economics
• History
• Geography
• Political Science
• Physical Education
• Computer Science
• Informatics Practices
• English Core
• Hindi Core
• Hindi Elective
• Other Subjects

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.