CBSE Class 12 Information Practices HOTs

INFORMATICS PRACTICES – Class - XII

SET – Higher Order Thinking Skills

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

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

SECTION-A

1. Answer the following questions :

   (a) What do you know about the LAMP suit of programs? 2

   (b) If the two related entities are STUDENT AND TEACHER, which type of relationship is shown by them? Also draw the ER model for this relationship.

   (c) Why high performance database and machines are needed for data warehouse? 

   (d) Name the Information Systems that produce the following reports: 

       (i) Invoicing detail

       (ii) Recruitment Summary Report.

   (e) Suggest the situations where we need the following data gathering techniques: 

       (i) On – Site Observation    (ii) Interview

2. Answer the following questions :

   (a) Can you explain the difference between the following two statements: 

        Text1.Text

        Text1(Index).Text

   (b) A variable is Local but it has Global Lifetime, which type of variable it is? 

   (c) Dolly declares two variables as follows but none of the declaration is correct,  can you suggest why?

        i) Dim i% as Integer       ii) Dim 1A as Integer

   (d) Can you skip arguments in a function call? How? 

   (e) Roshan create an MDI application, but when he runs the application and open the child form the menus of MDI form will disappear, Can you suggest the reason why?

   (f) Give the use of Table type, Snap Shot, Forward Only and Dynamic Type Recordset? 

3. Answer the following questions:

   (a) What is Read Only View? Give an example of it. 

   (b) Give one advantage and one disadvantage of a serial execution of transaction. 

   (c) How are errors in a PL/SQL block be managed? Name the errors raised when  a query returned:

        (i) No rows        (ii) Many rows

   d) Suggest the parameter modes for the following: 

       i) Passed value must not get changed

       ii) A value is to be received from a procedure but used in any expression

   e) Compare and Contrast triggers and constraints.

 

 7. Answer the questions based on the table Metro given below.

 

1) Answer the following questions:

SECTION A

 

 

a) LAMP - Linux        Apache             Mozilla                   PHP                 ½ x 4= 2

 

b) Many to Many Relationship is there.                                          1 for Type, 1 for ER model 2

 

c) Since DW stores a large volume of data to support and accommodate possible types 2 of queries. To efficiently store and process and quesry on such large volumes of data, high performance platforms are needed that include high performance RDBMS, high performance O/S and high performance H/W.

 

d)  i) The Invoice Management System produce invoicing details. 1

ii) The Human Resource Development System produce Recruitment Summary Report. 1

 

e) i) If the closer look of the real system is needed onsite observation is helpful. 1

For any manufacturing unit it is a well suited data gathering technique.

ii) Interview helps to extract as much information as possible, as vital as possible, as 1 honest as possible.

To know the performance of a product it is used.

 

2) Answer the following questions:

a) Text1.Text -        It is a text control. ½

Text1(index).Text - It is a control array of text. ½

 

b) STATIC variable has local scope and global lifetime. 1

 

c) i) In Dim i% as Integer, since % is a type declaration for Integer so we can not use 1

it as a part of variable name.

ii) In Dim 1A as Integer, name of a variable can not starts with a  digit. 1

 

d) Yes, if we declare arguments as OPTIONAL then this argument can be skip while 1 calling function.

 

e) If the MDI as well as Child form both having their own menus, then when child form is 1 loaded its menus takes over the menus of parent form and then parent menu bar is disappear. 

 

f) Use of each Recordeset - 1 mark 1 x 4 = 4

 

3) Answer the following questions:

 

a) A Read Only View does not allow any updation of data on the base table. 1

Create view V_Read_Only_EMP as select * from EMP WITH READ ONLY 1

 

b) Advantage  -                Correct Execution – as only one transaction is running at a time 1

and if the I/P is correct then definitely the O/P is correct.

 

Disadvantage - Inefficient Resource Utilization 1

 

c) Errors in a PL/SQL block are managed by means of exception handling. 1

i) NO_DATA_FOUND ½

ii) TOO_MANY_ROWS ½

 

d) The parameter modes are: 2

i) IN

ii) OUT

 

e) Triggers affect only those row where insertions take place after the trigger is created 1 whereas a constraints can be made to affect all rows in the table.

 

Triggers can be used to define custom constraints, which might not be possible 1 through the inbuild constraints.

 

SECTION – B

 

4. a) 

       Sub My_Arr_Procedure( )

        a = 5

        Do Until a = 0

                Print a

                a = a - 1

      Loop

End sub

 

i) A Procedure can’t return a value.                                     Function MyFun ( byVal a as Integer ) MyFun = a + a – 10

ii) A function can not be called by Call Statement.                End Function 

 

c) Write a VB program to enter a number and print the product of its digit, as if a number 4 entered is 234 then the program gives o/p as 24. 

 

5)  a) Private sub CmdClear_Click ( ) 1

 

    TxtAmt. Text = “ “

    TxtDisc.Text = “ “

    TxtNet.Text = “ “

 

End Sub

 

b)  Private sub Form_Load ( ) 2

 

   TxtDisc.Enabled = FALSE

   TxtNet.Enabled = FALSE

   OptCase.Value = TRUE

   TxtAmt.Setfocus

 

End Sub

 

c) Private sub TxtAmt_Change ( ) 2

        If Val (TxtAmt.Text) < = 0 then

        Msgbox “Pls enter a valid amount”

        Txt.Amt = “ “

     End If

End Sub

 

d) Private sub CmdCalc _ Click ( ) 5

If Option1.Value = True Then

 

If Val(Text1.Text) < 10000 Then

          Text2.Text = 20

          net = Val(Text1.Text) - Val(Text2.Text) 

   Else

          Text2.Text = 25

          net = Val(Text1.Text) - Val(Text2.Text)

   End If 

ElseIf Option2.Value = True Then

          If Val(Text1.Text) < 15000 Then

          Text2.Text = 10

          net = Val(Text1.Text) - Val(Text2.Text)

Else

 

          Text2.Text = 15

          net = Val(Text1.Text) - Val(Text2.Text)

          End If 

ElseIf Option3.Value = True Then

        If Val(Text1.Text) < 10000 Then

        Text2.Text = 10

        net = Val(Text1.Text) - Val(Text2.Text) 

Else 

       Text2.Text = 12

       net = Val(Text1.Text) - Val(Text2.Text)

    End If 

End If 

      Text3.Text = net

End Sub

 

SECTION – C

 

6)  a) Declare 2

           X number:=2; 

Begin

 

          For I In 1..10

          Loop 

               Dbms_output.put_line(X);

                   X:=X+2;

               End Loop;

End;

 

b) DECLARE 

                 V_empno NUMBER  (4);

                 V_empname varchar2 (20);

                 S_salary ; 

BEGIN

 

Select empno, ename, sal INTO v_empno, v_empname, S_salary FROM emp WHERE empno = 1234;

 

END; 

 

c) 20

14

28

20

 

d) Declare 4

          Y Date;

         X number;

 

Begin

 

           Y := ‘&Enter_Date’;

           X := To_Number(SUBSTR(Y,8,4));

           If Mod ( X, 4) = 0 then

                        Dbms_Output.Put_Line ( ‘Leap Year’ ); 

     Else

 

                Dbms_Output.Put_Line (‘Not a Leap Year’);

     End if;

End; 

 

8) a) Select Distinct (MT_Dest) from Metro; 2

 

b) Select MT_Origin, count (*) from Metro Group by MT_Origin; 2 

 

c) Declare 

Cursor Cur_metro IS Select MT_KM, MT_No from Metro where MT_Dest=’ABC’;

Rec Metro%RowType;

Begin 

Open Cur_metro;

Loop

Fetch Cur_metro Into Rec; 

Exit when Cur_metro%NOTFOUND;

If Rec.MT_KM > 15 then

Update Metro set MT_Dest=’XYZ’ where MT_No=Rec.MT_No; 

End if; 

 

d) Create or replace procedure TIME (T IN Number) AS  

RecMetro  Metro%ROWTYPE; 

Begin

 Select * Into RecMetro from Metro where MT_Time = T;

Dbms_output.put_line (RecMetro.MT_NO || RecMetro.MT_Origin || ….. );

End ;