CBSE Class 12 Information Practices HOTs

Download HOTS questions and answers for Class 12 Informatics Practices. Read CBSE Class 12 Information Practices HOTs below and download in pdf. High Order Thinking Skills questions come in exams for Informatics Practices in Standard 12 and if prepared properly can help you to score more marks. You can refer to more chapter wise Class 12 Informatics Practices HOTS Questions with solutions and also get latest topic wise important study material as per NCERT book for Class 12 Informatics Practices and all other subjects for free on Studiestoday designed as per latest CBSE, NCERT and KVS syllabus and pattern for Grade 12

All Chapters Class 12 Informatics Practices HOTS

Class 12 Informatics Practices students should refer to the following high order thinking skills questions with answers for All Chapters in standard 12. These HOTS questions with answers for Grade 12 Informatics Practices will come in exams and help you to score good marks

HOTS Questions All Chapters Class 12 Informatics Practices with Answers



SET – Higher Order Thinking Skills


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


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: 



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


4. Do as directed:
a) Rewrite the following code using DO …. LOOP WHILE construct without changing output. 2 
Sub My_Arr_Procedure( )
a = 5
    Print a
    a = a - 1
Loop While a < > 0
End Sub
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. Read the following case study and answer the questions that follow:
The Cotton County showroom has computerized its billing. A new bill is generated for each customer. The showroom allows three different payment modes. The discount rate is based on the payment mode. The following screen shot used to generate the bill:
a) Write code for the CmdClear command button to clear all the textboxes. 1 b) Write the code for the form load event of FrmDiscount so as to 2
i) Disable the TxtDisc and the TxtNet textboxes and set default choice in the option button as cash.
ii) Set the focus to the TxtAmt textbox. 
c) Write the code for the change event of the TxtAmt textbox to ensure that the user does 2 not enter a negative  or  a  zero  value. If  a  negative or a zero value is entered then the textbox should be made blank and a warning message should be displayed. 
d) Write code for the CmdCalc command button to display the discount rate and net price 5 in the TxtDisc  and  TxtNet  textboxes  respectively.  Note  that  net price is calculated as shopping amount – discount amount. The discount  amount is  calculate  according to the discount rate which is based on the payment mode  and  total shopping amount according to the following table.


6. Do as Directed:
a) Write a PL/SQL script to print numbers 2,4,6,8,10,….,20 using for loop. 2
b) Find the error(s), if any, in the following code: 2 
     v_empno NUMBER[4]; 
     v_empname varchar2(20);
    Select empno, ename, sal Into v_empno, v_ename FROM emp FOR empno = 1234; 
c) Find the O/P in the given PL/SQL block. 2 
Count Number;
Num1 Number; 
Count :=10; 
For num1 IN 5..8 
       If Mod (num1,2)=0 then 
       Count :=count – num1; 
    Count := count + 2 * num1; 
End if; 
 End Loop; 
d) Write a PL/SQL function CHECK_YEAR that accepts a date from the user and 4 returns 1 if the year is a leap year and returns 0 otherwise.

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


a) Write the SQL command to display the different destination without repetition. 2
b) Write the SQL command to display number of metros starting from each MT_Origin. 2
c) Write the PL/SQL code to change the destination OF ALL METROS ENDING AT “ABC”     3
Station to “XYZ” station which are covering a distance of more than 15 km.
d) Write the PL/SQL code to create a stored procedure TIME to display the details of all the 3 metros which start at a particular time of the day which is entered by the user. The time should be accepted as a parameter.
SET – Higher Order Thinking Skills
1) Answer the following questions:
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
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.
4. a) 
       Sub My_Arr_Procedure( )
        a = 5
        Do Until a = 0
                Print a
                a = a - 1
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
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) 
          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)
          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) 
       Text2.Text = 12
       net = Val(Text1.Text) - Val(Text2.Text)
    End If 
End If 
      Text3.Text = net
End Sub
6)  a) Declare 2
           X number:=2; 
          For I In 1..10
               End Loop;
                 V_empno NUMBER  (4);
                 V_empname varchar2 (20);
                 S_salary ; 
Select empno, ename, sal INTO v_empno, v_empname, S_salary FROM emp WHERE empno = 1234;
c) 20
d) Declare 4
          Y Date;
         X number;
           Y := ‘&Enter_Date’;
           X := To_Number(SUBSTR(Y,8,4));
           If Mod ( X, 4) = 0 then
                        Dbms_Output.Put_Line ( ‘Leap Year’ ); 
                Dbms_Output.Put_Line (‘Not a Leap Year’);
     End if;
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;
Open Cur_metro;
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; 
 Select * Into RecMetro from Metro where MT_Time = T;
Dbms_output.put_line (RecMetro.MT_NO || RecMetro.MT_Origin || ….. );
End ;

More Study Material

CBSE 12 Informatics Practices All Chapters HOTS

We hope students liked the above HOTS for All Chapters designed as per the latest syllabus for 12 Informatics Practices released by CBSE. Students of 12 should download the High Order Thinking Skills Questions and Answers in Pdf format and practice the questions and solutions given in above 12 Informatics Practices  HOTS Questions on daily basis. All latest HOTS with answers have been developed for Informatics Practices by referring to the most important and regularly asked topics that the students should learn and practice to get better score in school tests and examinations. Studiestoday is the best portal for 12 students to get all latest study material free of cost.

HOTS for Informatics Practices CBSE 12 All Chapters

Expert teachers of studiestoday have referred to NCERT book for 12 Informatics Practices to develop the Informatics Practices 12 HOTS. If you download HOTS with answers for the above chapter daily, you will get higher and better marks in 12 test and exams in the current year as you will be able to have stronger understanding of all concepts. Daily High Order Thinking Skills questions practice of Informatics Practices and its study material will help students to have stronger understanding of all concepts and also make them expert on all critical topics. You can easily download and save all HOTS for 12 Informatics Practices also from without paying anything in Pdf format. After solving the questions given in the HOTS which have been developed as per latest course books also refer to the NCERT solutions for 12 Informatics Practices designed by our teachers

All Chapters HOTS Informatics Practices CBSE 12

All HOTS given above for 12 Informatics Practices have been made as per the latest syllabus and books issued for the current academic year. The students of 12 can refer to the answers which have been also provided by our teachers for all HOTS of Informatics Practices so that you are able to solve the questions and then compare your answers with the solutions provided by us. We have also provided lot of MCQ questions for 12 Informatics Practices in the HOTS so that you can solve questions relating to all topics given in each chapter. All study material for 12 Informatics Practices students have been given on studiestoday.

All Chapters CBSE 12 HOTS Informatics Practices

Regular HOTS practice helps to gain more practice in solving questions to obtain a more comprehensive understanding of All Chapters concepts. HOTS play an important role in developing an understanding of All Chapters in CBSE 12. Students can download and save or print all the HOTS, printable assignments, and practice sheets of the above chapter in 12 Informatics Practices in Pdf format from studiestoday. You can print or read them online on your computer or mobile or any other device. After solving these you should also refer to 12 Informatics Practices MCQ Test for the same chapter

CBSE HOTS Informatics Practices 12 All Chapters

CBSE 12 Informatics Practices best textbooks have been used for writing the problems given in the above HOTS. If you have tests coming up then you should revise all concepts relating to All Chapters and then take out print of the above HOTS and attempt all problems. We have also provided a lot of other HOTS for 12 Informatics Practices which you can use to further make yourself better in Informatics Practices.

Where can I download latest CBSE HOTS for 12 Informatics Practices All Chapters

You can download the CBSE HOTS for 12 Informatics Practices All Chapters for latest session from

Can I download the HOTS of All Chapters 12 Informatics Practices in Pdf

Yes, you can click on the link above and download topic wise HOTS Questions Pdfs for All Chapters 12 for Informatics Practices

Are the 12 Informatics Practices All Chapters HOTS available for the latest session

Yes, the HOTS issued by CBSE for 12 Informatics Practices All Chapters have been made available here for latest academic session

How can I download the 12 Informatics Practices All Chapters HOTS

You can easily access the link above and download the 12 HOTS Informatics Practices All Chapters for each topic

Is there any charge for the HOTS with solutions for All Chapters 12 Informatics Practices

There is no charge for the HOTS and their answers for All Chapters 12 CBSE Informatics Practices you can download everything free

What does HOTS stand for in 12 Informatics Practices All Chapters

HOTS stands for "Higher Order Thinking Skills" in All Chapters 12 Informatics Practices. It refers to questions that require critical thinking, analysis, and application of knowledge

How can I improve my HOTS in 12 Informatics Practices All Chapters

Regular revision of HOTS given on studiestoday for 12 subject Informatics Practices All Chapters can help you to score better marks in exams

Are HOTS questions important for All Chapters 12 Informatics Practices exams

Yes, HOTS questions are important for All Chapters 12 Informatics Practices exams as it helps to assess your ability to think critically, apply concepts, and display understanding of the subject.