CBSE Sample Paper 2009 Class XII Informatics Practices (IP)


Ask a Question

Sample Paper – 2009

Class – XII

Subject – Informatics Practices

Time allowed: 3 hours Maximum Marks: 70

NOTE:

(i) All questions are compulsory. .

(ii) Answer the questions after carefully reading the text.

Section – A

1. Answer the following Questions :

a) What is information system? Write different types of information system? 2

b) What does object modeling technique mean? Why do we use UML? 2

c) How can you differentiate interviewing from questionnaires? . 2

d) Define Generalization and Specialization. 2

e) What is Metadata and data dictionary? 2

2. Answer the following questions:

a) What is variable lifetime? Which variable has longest lifetime? 2

b) What is Container control? How can a picture box be used as a container? 2

c) Write the differences between ADODB and ADODC data control? 4

d) Which loop executes when the given condition is False? Explain with an example. 2

3. Answer the following Questions :

a) State any two advantages of PL/SQL over SQL. 2

b) What is trigger? Name the statements for which triggers are executed. 2

c) Write the differences between DDL and DML/ 2

d) Write the differences between procedure and function? 2

e) Define Transaction and define the different types of transaction? 2

Section – B

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

Paradise Company is a dealer of goods. The company’s programmer has made the following from to calculate the total cost of the order of the customers. The total cost is calculated as per the following criteria.

For Units Price For wholesalers Price for Retailers
1-30 Rs. 100/- Rs. 80/-
31-70 Rs. 90/- Rs. 70/-
>70 Rs. 60/- Rs. 50/-

Special customers are given a discount of 20%.

Object Type

Object Name

Description

Form

FrmParadise

Main Form

Text Box

txtUnitOrdered

To enter Unit Ordered

txtTotalCost

To show calculated cost

Check Box

chkSpCust

To be checked if customer is special

Option Button

optWholesalerl

To Provide customer type

optRetailer

Command Button

cmdCalcCost

To calculate total cost

cmdClear

To clear the entered values

cmdQuit

To close the application

CBSE Sample Papers 2009

  1. Write the commands to disable the text boxes txtPercentage and txtGrade. 1
  2. Write the code for text boxes txtFirstTerm or txtSecondTerm which accept only numeric data. 1
  3. Write the code for cmdCalcPer to calculate the percentage after finding the total marks of first term and second term (assuming that both marks are out of 100). Also ensure that NCC cadets get an increment of 5% in their percentage. 3
  4. Write the code for cmdCalcGrade to calculate the grade depending on the stream selected according to the criteria given above. 3
  5. Write the code for cmdClear command button to clear all the text boxes and check box. Also write the code for cmdExit to close the application. 2

Q.5 Read the following text and answer the questions that follow:

(a) Find out the Error(s) in the code fragment if any: 2

Private Sub Ret(ByVal num As Integer)

Dim sum1 As Integer

For I = 1 to num

Sum1 = sum1 + num

Next

Ret = Sum1

End Sub

(b) Find the Output of the following code segment: 2

x = “class” (2)
Print (5 * 4 > 8 + 3) And (3^2 <>

(c) Re-write the following code segment using a Select Case construct: 2

IF a = 1 THEN

Picoutput.print “Earth”

Elseif a >=3 and a<=4 Then

Picoutput.print “ Mars”

Elseif a = 5 OR a = 7 Then

Picoutput.print “Saturn”

END IF

(d) Write a program in VB to enter any number and display all the even and odd numbers upto that number and find their respective sums. 4

SECTION-C

6 (a) Write the output produced by the following PL/SQL code segment when gross_sale entry by the user is 3850. 2

VARIABLE amount NUMBER;

DECLARE

actual_sale NUMBER (9,2):= &gross_sale;

BEGIN

IF actual_sale> 2000 THEN

actual_sale:= actual_sale – 500;

ELSE

actual_sale:= actual_sale – 100;

END IF;

:amount= actual_sale;

END;

/

PRINT amount

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

DECLARE

v_no Emp.Ename & ROWTYPE;

v_sal NUMBER (7,2)=1000;

BEGIN

LOOP

SELECT sal TO v_sal FROM Emp WHERE Eno=v_no;

v_no = v_no + 1;

EXIT FOR v_no > 5;

END LOOP;

END;


(c) Explain the usage of %TYPE attribute in variable declaration in a PL/SQL block within the help of an example. 2

(d) Write a PL/SQL procedure that calculates and displays the volume of a box. The procedure takes three parameters for length, width and height of the box respectively. The last two parameters are optional having a default value of –1. If the last two parameters are not passed then the volume of a box having sides equal to the first parameter is to be calculated. 4

7. Answer the following questions: 2+3+2+3=10

CUSTOMER

Column Name

Data Type

Size

Constraint

Cust_id

Custname

Permanent_address

Postall_address

Tot_purchase_cost

Number

Varchar2

Varchar2

Varchar2

number

7

30

20

20

7,2

Primary key

Not null

Not less than 2000

a) Write the SQL Command to create the above table including its Constraints.

b) Write a PL/SQL cursor to select the total No. of people who earn <>

10000/- to 20000/- in a month. insert both groups into SunEmp Table.

b) Write a trigger to avoid data entry for emp table having e_name=’Manpreet Singh’.

d) Write a pl/sql function to calculate salary with 25% bonus to the highest salary paid EMP.