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

Informatics Practices — 2006 (Set I — Delhi)

SECTION - A

Q. 1. Answer the following questions:

1. Explain the term Metadata using suitable example. 2
2. What is a Financial Accounting system? Name any two entities or tables that could be a part of this system. 2
3. What is feasibility study with reference to SDLC? Explain. 2
4. Explain the concept of object-oriented modeling. 2
5. Define Data Warehousing using suitable example. 2

Q. 2. Answer the following questions:

1. What do you understand by the term Event Driven Programming? Explain. 2
2. Write the names of any two properties and any two methods, which are common to the checkbox object and option button object. 2
3. Differentiate between the DriveListBox and DirListBox. Also name the most important property of each of these controls, which needs to be set by the user. 2
4. What is the purpose of the Common Dialog control? List any two methods of the Common Dialog Control. 2
5. What do you understand by the term data-bound controls? Name any two data-bound controls that can be used on a form. 2

Q. 3. Answer the following questions:

1. What do you understand by the term Equi - Join? Give an example. 2
2. Explain the difference between the SUBSTR and INSTR function of SQL with the help of an example. 2
3. What are group functions of SQL? Name any two group functions. 2
4. Differentiate between the COMMIT and ROLLBACK commands of SQL. 2
5. Explain the usage of the IN OUT parameter of a PL/SQL procedure with the help of an example. 2

SECTION – B

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

The Pizza Cafe has computerized its billing. The following is the data entry screen used at their outlet. The outlet offers two different types of pizzas, regular and pan pizzas. The price of a regular pizza is Rs. 90 and that of a pan pizza Rs. 110. The user can choose to have three different types of extra toppings if he wants. Each extra toppings costs Rs. 20.

The list for the above form is as follows

1. Write the commands to disable the textboxes txtKate, txt’l’opping, txtAmount and cmdAmount. 2
2. Write the code for cmdRate to calculate the rate of the pizza and display it in txtRate depending on the type of pizza selected by the customer. It should also enable the cmdAmount button. 4
3. Write the code for cmdAmount to calculate the total amount and display it in txtAmount. The total amount is calculated by first finding the cost of extra toppings selected by the customer. Remember that each extra topping costs Rs. 20 therefore if the user selects 2 toppings the cost of the toppings will be Rs. 40. Then add it to the rate and multiply the resultant amount by the quantity ordered. 4

Q. 5. Answer the following questions:

1. Find the errors from the following code segment and rewrite the corrected code underlining the correction made. 2
   Dim num=10, las Integer
   I = I
   Do While 1 < 5
            1 = 1 + 2
        If num > 15
            num = 0
        Else
            num = num — 3
         Endlf
   End While
2. Give output of the following statements: 2
   (a) INSTR (LTRIM (“INTERNATIONAL”), “na”)
   (b) INT (4 - 7 * 3/2 + 5)
3. Change the following code using FOR loop without effecting the output 2
   Dim count, and
   ans = 1
   count = 20
   DO
   ans = ans * count
   count = count -2
   LOOP UNTIL count < = 10
   Print ans
4. Write a Visual Basic procedure which takes a number as argument and dis plays whether it is prime or not. A prime number is one, which is not divisible by any number other than by 1 and by itself. 4

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
            A NUMBER: = 10;
            B NUMBER: = 2;
            BEGIN
                     WHILE B < 12 LOOP
                              IF A > B THEN
                                       DBMS_OUTPUT.PUT_LINE (TO_CHAR(A));
                              ELSE
                                       DBMS_OUTPUT.PUT_LINE(TO_CHAR(B));
                              END IF;
                              A : = A — 4;
                              B : = B + 3;
            END LOOP;
            END;
2. Find the errors from the following PL/SQL code and rewrite the corrected code underlining the correction made. 2
   CREATE ASWELLAS REPLACE TRIGGER DEPT_UP
               AFTER UPDATE ON DEPT FOR_EVERY ROW
   DECLARE
               v_num NUMBER (3);
   BEGIN
               SELECT COUNT (*) INTO v_num FROM Emp WHERE Dept ‘1O1’;
   IF v_num > 5
               Raise_application_error (—20001, ‘Cannot exceed 5’);
   END;
3. What do you understand by % ROWCOUNT with reference to cursors? What will happen if you use the %ROWCOUNT attribute of a cursor that is not open? 2
4. Write a PL/SQL procedure called FACTORIAL that takes an integer as parameter, finds its factorial and display it. (Factorial of a number is the product of all whole numbers less than and equal to that number. For example, factorial of 4 = 4 x 3 x 2 x 1 = 24). 4

Q. 7. Answer the questions base on the table CLUB given below:

Table : CLUB

1. Write the SQL command to create the table Club including the constraints. 2
2. Write the SQL command to display the details of the all the members whose type is “Permanent” and fees is more than Rs. 1000. 2
3. Write a Pl/SQL code to increase the fees by 5% for a member number accepted from the use if the type of the membership is “Temporary”. 3
4. Write Pl/SQL code using and explicit cursor to display the details of all the “permanent” members whose age is greater than 50. The code should also display the average membership fees of all such members. 3

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