CBSE Class 12 Information Practices HOTs

Please refer to CBSE Class 12 Information Practices HOTs. Download HOTS questions and answers for Class 12 Informatics Practices. Read CBSE Class 12 Informatics Practices HOTs for All Chapters below and download in pdf. High Order Thinking Skills questions come in exams for Informatics Practices in Class 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 Class 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 Class 12. These HOTS questions with answers for Class 12 Informatics Practices will come in exams and help you to score good marks

HOTS Questions All Chapters Class 12 Informatics Practices with Answers

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.

SECTION – B

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.

CBSE_Class_12_information_Set_A_4

SECTION – C

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

DECLARE

v_empno NUMBER[4];

v_empname varchar2(20);

BEGIN

Select empno, ename, sal Into v_empno, v_ename FROM emp FOR empno = 1234;

END;

c) Find the O/P in the given PL/SQL block. 2

Declare

Count Number;

Num1 Number;

Begin

Count :=10;

For num1 IN 5..8

Loop

If Mod (num1,2)=0 then

Count :=count – num1;

Else

Count := count + 2 * num1;

End if;

Dbms_output.put_line(count);

End Loop;

End;

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.

CBSE_Class_12_information_Set_A_5

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

SOLUTIONS

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