CBSE SAMPLE QUESTION PAPER Class XIIth  -   Informatics Practices

 

Time: 3 Hours                                                                                                                                                Max. Marks: 70

General Instructions:

(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 each.

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

                                                    

                                                               SECTION -A

Q1) Answer the following questions:

       a) Discuss the terms FLOSS and Shareware.         (2)

       b) Explain the terms: Data Mining and Data Warehousing.                         (2)

       c) Write one example each of "one to many" and "many to many" relationships between two entity sets.            (2)

       d) Elaborate the term SDLC explaining its essential components using a sample case study.       (2)

       e) What is meant by Client Sever Computing? Differentiate b/w One-Tier and Two-Tier Client Server.             (2)

Q2) Answer the following questions:

       a) What is a Bound Control? Name any two data ware properties of bound controls.          (2)

       b) What is Selection statement? Name any two selection statements that VB provides.              (2)

       c) Why do we write comments in a program? What are the two ways of writing comments in VB?  (2)

       d) Differentiate between Modular Programming and Object Oriented programming.            (2)

       e) What is the difference between a function and a sub procedure? Write one example of each.       (2)

Q3) Answer the following questions:

       a) What is the difference between local and stored procedures? Write one advantage of stored procedures.            (2)

       b) Write two points of differences between SQL and PL/SQL.       (2)

       c) Differentiate between IN and OUT mode of PL/SQL procedure? Give an Example.       (2)

       d) What is the purpose of Cursors?            (2)

       e) How are triggers similar and different to Constraints?      (2)                                                         

                                                               SECTION - B

Q4) Read the following data entry screen in a Shoppers Stop with four types of Membership and answer the following questions:

 

              

 

     a) Write the code to display rate of the item in the Rate text box as soon as the user enters any item in the Item Text box.                (3)

     b) For Class A Membership discount is 10%, for Class B Membership discount is 8%, for Class C Membership

         discount is 5% and for Class D Membership discount is 3%. Discount should be automatically displayed in the

         Discount Text Box as soon as the Membership is selected. Write the code for the same.                                           (3)

     c) Write the code to calculate the Gross Amount in the Calculate Gross Amount Command Button.                 (2)

     d) Write the code to display Msg Box function saying "Thank You Visit Again" in the Thank You Command Box.                   (2)

Q5) a) Write the output that the following code segment will generate:                                                                           (2)

            code="Informatics practices"

            Print Mid (LTrim( "Computer Science" ),1,6)+"One"

            Print (9*3>8+3) And (4^3 < 6/2)

            Print Val ("l6 fruits") + Len(code)

            Print InStr("Computers", "pu")                       

       b) Find the value of Sum generated by the code:             (3)

              sum = 0

              For i = 5 To 10

                    For j = -2 To i - 1

                          Select Case (i + j + 1)

                          Case -1, 0

                                   sum = sum + i

                          Case 1, 2, 3

                                   sum = sum + j

                          Case Else

                                    sum = sum + i + j

                          End Select

                      Next j

              Next i

              Print sum

       c) Write a function in VB that take input two numbers and returns 0 if they are equal, -1 of first is greater and +1 if second is greater.                                                             (2)

       d) Rewrite the given code using select case statement:                                        (3)

            If code = "A" Then

               Print " Student got 90% and above"

            ElseIf code = "B" Then

               Print " Student got 80% and above "

            ElseIf code = "C" Then

               Print " Student got 70% and above "

            ElseIf code = "D" Then

               Print " Student got 60% and above"

            ElseIf code = "E" Then

               Print " Student got 50% and above "

            Else

               Print " Fail"

            End

                                                                  SECTION - C

Q6) a)  Write a SQL query to display the data of all the employees from emp table whose date_of_ joining is between

             08/08/2001 and today's date. Order the query in the descending order of date_of_ joining.                                (2)

       b) Create a view to display all the employees from emp table who belong to deptno=100 and there salary is less than 5000.        (2)

       c) Write the output of the following PL/SQL code.            (2)

            DECLARE

                x CHAR(8) := 'COMPUTER';

                i NUMBER;

                BEGIN

                FOR i IN 1..3 LOOP

                DBMS_OUTPUT.PUT_LINE (SUBSTR (x, -8, i));

                END LOOP ;

                END;

      d)   Write the output of the following PL/SQL code.            (2)

            BEGIN

                FOR i IN REVERSE 1..25 LOOP

                IF MOD (i, 2)=0 THEN

                DBMS_OUTPUT.PUT_LINE (TO_CHAR (i*5));

                END IF;

                END LOOP;

                END;

      e)   Write a PL/SQL function to display employee information whose empno is taken as input from the user in the form of a Parameter.                                                           (2)

Q7) Answer the questions based on the student table given below:   

           

Column name	Data type	Size	Constraint
Rollno	Number	4	Primary key
Name	Varchar	20	Not Null
Class	Varchar	4	-
Stream	Varchar	10	-
Marks	Number	2	Default 0

      a)   Write the query to create the Student table.       (2)

      b)   Write a PL/SQL trigger to show the current record deleted from the table after each time the deletion operation is

             performed on the table.            (3)

      c)   Write program code to declare and use an Explicit Cursor to display the marks increased by 10%.                    (3) 

      d)  Write a PL/SQL procedure EDSAL to find out whether the marks of a Student with Rollno = 1234 is less than 33 or not.

            If it is less then 33, modify the marks of a Student by increasing it by 15%.         (2)

 

 

Tips: 1. Read the question paper properly. 2. Don't waste the time for the question about which you are in doubt. 3. As far as possioble attempt the questions in the serial order. 4. Leave atleast one or two line after every question. 5 Before leaving do revise all paper. ÙæðÅUÑ- Øã °· âñ{ÂÜ ÂðÂÚ ãñ ÁMÚè Ùãè´ ç· §âè ×ð¢ âð ÂÚèÿææ ×ð´ ÂýàÙ ¥æ°¢Ð

RITIKA BISHT KVIMA, PGT COM SCI