CBSE Guess > Papers > Question Papers > Class XII > 2006 > Informatics Practices > Compartment Delhi Set - I

Informatics Practices — 2006 (Set I — Compartment Delhi)

SECTION - A

Q. 1. Answer the following questions:

1. Explain the term Business Computing with two examples. 2
2. What do you understand by the term UML? 2
3. What is Client Server Computing? 2
4. Give an example for one-to-one and one-to-many entity relation. 4

Q. 2. Answer the following questions:

1. Differentiate between Event Driven Programming and Object Oriented Programming. 2
2. What is Iteration? Name two statements which provide iteration in Visual Basic. 2
3. Explain the term ADO. 2
4. What is Variable Life Time? What is the Life Time of the following variables? 4
   (i) Local variable
   (ii) Public variable
   (iii) Module variable

Q. 3. Answer the following questions:

1. Differentiate between Decision Control and Looping Control structure in context with PL/SQL. 4
2. What do you understand by the term Implicit Cursor in PL/SQL? 2
3. Differentiate between DBMS_OUTPUT.PUT_LINE ( ) and DBMS_ OUTPUT.PUT( ) statements. 2
4. Define a TRIGGER with two examples. 2

SECTION - B

Q. 4. Read the following case study and answer the questions given below:

ABC FINANCIAL company provides personal loans to customers on request. The programmer is assigned the responsibility of designing an EMI calculator. He decides to use Visual Basic to develop this and the following form is created.

The List for the above from is as follows:

1. Write the code to disable the text boxes txtlnterest and txtEMI. 2
2. Write cmdClear to clear all text boxes and set default choice in the option button as 5 years. Also set focus to txtLoanAmt. 2
3. Write code to assign the caption to Command Buttons cmdCalculate and cmdClear. 2
4. Write code for the Click event of the Command Button cmdCalculate to calculate the interest using the formula P * (1 + R) “T — P, where P is the loan amount, R is the interest rate (fixed as 11%), and T is the number of years. And the value of EMI is calculated as EM! = (Loan Amount + Interest) I (no. of years*12) 4

Q. 5. Answer the following questions:

1. The following code is to print all numbers which are squares but less than 50. Find the errors in the following code segment and rewrite the corrected code under lining the correction made. 2
   Dim square As integer, num As Integer
   num = 1
   square num * num
   Do
           Print square
           square = num * num
   Loop square > = 50
2. Find the output of the following code segment: 2
   For x = ASC (“A”) To ASC (“E”)
           For y ASC (“A”) to x
                   Print Chr(y);
           Next y
           Print
   Next x
3. Rewrite the following code using If ... Else instead of Select Case. 2
   Select Case          Round (Avg)
   Case Is = 100
                Grade = “A”
   Case 75 To 99
               Grade = “B”
   Case 60 To 74
               Grade = “C”
   Case 50 To 59
               Grade = “D”
   Case Is <50
               Grade = “E”
   End Select
   Print Grade
4. Write a Visual Basic procedure which will take two integer values X and Y as arguments and display the following : 4
   (i) X to the power of Y
   (ii) The highest number among X and Y

SECTION - C

Q. 6. Read the questions given below and answer accordingly:

1. Write the output produced by the following part of code in PL/SQL: 2
   DECLARE
          Num NUMBER;
          V NUMBER : = 0;
   BEGIN
          For Num IN 2 ...5
          LOOP
                 V : = V + Num * Num;
                 DBMS_OUTPUT.PUT_LINE(V);
          END LOOP;
   END;
2. Refer the following table STUDENT and give the output produced by the PL/SQL code given: 2
   TABLE : STUDENT

   NAME	AGE	MARKS
   RAJA SIMON WILSON MARY	17 16 18 17	325 480 390 450

   DECLARE
          T_NAME VARCHAR2(1 0);
          T_AGE NUMBER(2);
          T_MARKS NUMBER(3);
   BEGIN
          T_AGE : = 17;
          SELECT MARKS INTO T MARKS FROM STUDENT
                 WHERE AGE > T_AGE;
          IF T_MARKS > 350
                 DBMS_OUTPUT.PUT_LINE (T_MARKS);
   END;
3. Differentiate between Scalar and composite data type in PL/SQL. 2
4. Write a PL/SQL function chkPrime that takes one number as argument and returns a value 1 if the number passed is Prime else will return a value zero. 4

Q. 7. Answer the questions based on the table CARS given below:

TABLE : CARS

1. Write SQL command to create the table CARS including the constraints. 2
2. Write the SQL command to display the details of all cars whose colour is the same as the colour of Model_No M_800. 2
3. Write PL/SQL code to increase the Price of all cars by 5%. 2
4. ) Write FL/SQL block to delete all cars with a particular Model Number from the table CARS, where the value of Model Number is accepted from the user. 4

Informatics Practicess 2006 Question Papers Class XII
Delhi		Outside Delhi		Compartment Delhi
	Set I		Set I		Set I