Class – XII
Subject – Informatics Practice
MM: 70 TIME: 3hrs
Note: (i). This question paper is divided into 3 sections
(ii). Section A consists of 30 Marks.
(iii). Section B and Section C are of 20 marks.
(iv). Answer the questions after carefully reading the text.
[SECTION - A]
Q.1) Answer the following questions:
a) How is a back-end linked to a database and a server? 2
b) What is the difference between Freeware & Free software? 2
c) Write a short note on PHP. 2
d) What are the major steps involved in SDLC? 2
e) Write a VB program to obtain the greatest among 3 numbers. 2
Q.2) Answer the following questions:
a) Differentiate Public Sub and Private Sub. 2
b) “Visual Basic is not an Object Oriented Language” Justify this statement. 2
c) How is a standard module different from a form module? Explain with example. 2
d) Why do we need Control structures ? mention the classification of Control structures With Syntaxes ? 2
e) What do you understand by the term Record Source of an ADO data control? 2
Q.3) Answer the following questions:
a) Explain the function SUBSTR() and INSTR() with a suitable example. 2
b) Write the syntax to create an explicit cursor and Trigger. 2
c) what do you understand by term Many to One relationship 2
d) Differentiate between if then and if-then- else conditional statements in VB with examples. 2
e) what is the default option of Create Table command. 2
[SECTION – B]
Q.4) Read the following case study and answer the questions that follow:
Mr. Anil Sharma of High Income Finance Company needs to calculate the interest and amount due from his clients. He asks his software programmer to design an interest calculator which will calculate the compound interest and amount due if a person takes a loan for 5, 10 or 15 years. The programmer opts for Visual Basic Language to develop this and create the following form:
| Object Type | Object Name | Description |
| Form | frm Interest Calc | The main form object |
| Text Box | TxtPrincipal | To enter the principal |
| txtRate | To enter the interest rate | |
| txtInterest | To display the compound interest | |
| txtAmount | To display the amount due | |
| Comand Button | cmdResult | Button for calculation |
| cmdGrade | Button for grade | |
| cmdClear | Button for clear the text boxes | |
| cmdExit | For close |
a) Write the code to disable the textboxes txtInterest and txtAmount in the form load event of frm Interest Calc. 2
b) Write the code for cmdClear command button to clear all the textboxes and set default choice in the Option Buttons as 5 years. Also set the focus to txtPrincipal. 2
c) Write the code for the Change event of the textboxes txtPrincipal and txtRate to ensure that the user enters only numeric values in them. 2
d) Write the code for the Click event of the command button cmdCalculate to calculate the compound interest and amount depending on the principal, rate and time. The compound interest is calculated as P * (1 + R / 100) ^ T and amount as (Principal + Compound Interest). 4
Q.5) Answer the following questions:
a) Find the error from the following code segment and rewrite the corrected code underlining the correction made(VB):
Function Wishing(st as string and L as integer) as String
For i= 1 to L
If Left(st,2)=HB then
Wishing =”Happy Birth Day”
Else if Left(st,2)=’HN’
Wishing =”Happy New Year”
Next i
End Wishing
b) Find the output of the following code segment:
i) Print 5 and 6
ii) p=4
for k=4 to 1 step -1
d=(k mod 2)*p
print d;”#“;
p=p-1
Next k
c) Change the following code using Do While loop without affecting the output.
Sum=0
For I=0 to 4
For J=0 to I-1
Select Case(I+J+1)
Case -1,0
Sum=sum+1
Case 1,2,3
Sum=sum+2
Case Else
Sum=sum+3
End Select
Next : Next
d) Write a function funLcm that takes two numbers from the user and return LCM (Least Common Multiple). 4
[ SECTION – C]
Q.6) Answer the following questions:
a) Find the output of the following code:-
DECLARE
X NUMBER :=1;
Y NUMBER := 4;
Z NUMBER(4);
BEGIN
LOOP
Z := ( 2*X+ 3*Y) -13 ;
IF X+Y <=13 THEN
DBMS_OUTPUT.PUT_LINE( TO_CHAR(Z) );
ELSE
EXIT;
END IF;
X:=X+4;
Y:= Y-2;
END LOOP ;
END; 2
b) Find the errors from the following code segment and rewrite the corrected code underlining the correction made :
CREATE OR REMOVE PROCEDURE DEBIT(ACC NUMBER(6), AMT NUMBER(9,2) RETURN A
DECLARE
Y BALANCE%TYPE;
X NUMBER;
BEIGN
SELECT ACCNO, BALNC MOVETO Y FROM BALANCE WHERE ACCNO:=ACC;
UPDATE TABLE BALNCAE SET BALNC=BALNC+AMT WHERE AMOUNT =AMT;
SELECT BALNC MOVETO X FROM BALANCE WHERE ACCNO=ACC;
RETURN X;
END; 2
c) How is implicit cursors different from explicit cursors ? 2
d) Write a PL/SQL script to increment the salaries of employees as per following specifications: For Salesmen if Salary + Comm > 2500 then 10% of Salary as increment
Otherwise 12% of Salary as increment
For Analysts 20% increment, For Clerks 12% increment, For Managers 25% increment 4
Q.7) Answer the following questions:
a) What are anchored variables in PL/SQL? 2
b) What are the characteristics of a Data Warehouse? 2
c) How is a 3-tier computing model more effective than a 2-tier computing model? 2
d) Find the sum of the series 2+8+16+32+64+…up to n terms. 4
or
Write a PL/SQL program that checks whether an input number is Even or Odd.
More Sample Papers: Click here