Rajasthan Board Class 12 Question Paper 2020 information Technology and Programming II

 Roll No.

No. of Questions – 30
No. of Printed Pages – 8
   –II
(INFORMATION TECHNOLOGY AND PROGRAMMING–II)
 (Optional)
  , 2020
 3¼ 
 56

     

GENERAL INSTRUCTIONS TO THE EXAMINEES :

(1)    -     

Candidate must write first his / her Roll No. on the question paper compulsorily.

(2)      

All the questions are compulsory.

(3)       -    
Write the answer to each question in the given answer-book only.
SS-03-Info.Tech. (Opt.) [ Turn over

2
(4)      ,         
For questions having more than one part, the answers to those parts are to be written
together in continuity.

(5) -    
       //      
    
If there is any error / difference / contradiction in Hindi & English versions of the
question paper, the question of Hindi version should be treated valid.

(6)      

 1-13 1

 14-24 2

 25-27  3
 
28-30  4

Section Q. Nos. Marks per question
A 1-13 1
B 14-24 2
C 25-27 3
 
28-30 4

(7)   28, 29  30     
Question Nos. 28, 29 and 30 have internal choices.

3
 – 
SECTION – A

1.         

Write any two examples of non-linear data structure. 1

2.     ?

What is Pointer ? 1

3.         ?

What is the complexity of quick sort algorithm ? 1

4.        ?

What is POP operation in stack ? 1

5.       

Define circular linked list. 1

6.     ?

What are tokens ? 1

SS-03-Info.Tech. (Opt.) [ Turn over

4
7.     ?

What are expressions ? 1

8.      ?

What is inline function ? 1

9.     

Define Class. 1

10.      ?

What is constructor overloading ? 1

11.            

Write the prototype of operator function in operator overloading. 1

12.      ?

What is Hybrid inheritance ? 1

13. DBMS  DDL (...)  DML (...)       ?

What is the full form of DDL and DML in DBMS ? 1

5
 – 
SECTION – B

14. PL/SQL      

Write the structure of PL/SQL block. 2

15. MySQL    Aggregate     

Write any four Aggregate functions in MySQL. 2

16. REVOKE   MySQL     ?

What is the use of REVOKE command in MySQL ? 2

17.       ?

What is a bad database ? 2

18. Malloc     

Explain the use of Malloc function. 2

19.        

Write the differences between stable and unstable sorting. 2

SS-03-Info.Tech. (Opt.) [ Turn over

6
20.  
      

Explain infix notation with example. 2

21.          ?

What is node and next in linked list ? 2

22.   --   
Explain call-by-reference in functions. 2

23.         ?

What are the properties of static member function ? 2

24. PL/SQL     ?

What is PL/SQL cursor ? 2

 – 

SECTION – C

25.   X[–15 ..... 10, 15 ..... 40]           
 
1500 ,  X[15] [20]  
        

An array X[– 15 ..... 10, 15 ..... 40] requires one byte of storage. If beginning location is
1500, determine the location of X[15] [20] using column major system. 3

7
26. SQL  group by clause      

Explain the use of group by clause in SQL with example. 3

27.     (functional dependencies)   

Explain functional dependencies in database. 3

28.       



      

Explain Linear Search with example. 4

OR

Explain Bubble sort with example.

29.         



      

Explain various types of looping statements. 4

OR

Explain multiple inheritance with example.

SS-03-Info.Tech. (Opt.) [ Turn over

8
30. Exception    ? PL/SQL     exceptions    


 set operators     
(i) INTERSECT
(ii) EXCEPT
What is exception ? Explain different types of exceptions in PL/SQL. 4
OR
Write the syntax for following set operators :
(i) INTERSECT
(ii) EXCEPT
____________