CBSE Class 12 Computer Science Question paper 2010 Set 02

CBSE Class 12 Computer Science Question paper 2010 (2). Students can download the last year question papers using the link below. Free download of examination question papers with solutions.Last 10 year question papers should be practised to get better marks in examinations.

1.  (a) What is the difference between Local Variable and Global Variable? Also, give a suitable C++ code to illustrate

          both.                                                                                                                                

     (b) Write the names of the header files, which is/are essentially required to run/ execute the following C++ code:

          void main ( )                                                                                                                      

          {          char C, String [ ] = "Excellence Overload";

                     for (int I=0; String [ I ] ! = '\ 0'; I ++ )

                     if (String [I] ==' ')

                               cout<<end1; 

                      else

                       {             C=toupper(String[I]);

                                     cout<<C ; 

                       }

           }

      (c) Rewrite the following program after removing the syntactical errors (if any). Underline each correction.

           #include[iostream.h]

           typedef char Text(80) ;

           void main ( )

            {       Text T= "Indian";

                    int Count=strlen(T) ;

                    cout<<T<<'has'<<Count<< 'characters' <<end1;

            }

2.  (a) An array P[20] [50] is stored in the memory along the column with each of its element occupying 4 bytes.

          1ocation of P[15][10], if P[0][0] is  stored at 5200.                                                                

     (b) Write SQL commands for the following statements:

     (i) To display the details of all WORKERs in descending order of DOB.

     (ii) To display NAME and DE;SIG of those WORKERs, whose PLEVEL is either P001 or P002.

     (iii) To display the content of all the WORKERs table, whose DOB is in  between '19-JAN-1984' and '18-JAN-1987'.

     (iv) To add a new row with the following:

          19, 'Daya Kishore', 'Operator', 'P003', '19-Jun-2008', '11-Jun-1984'

     (c) Give the output of the following SQL queries:                                                                        

     (i) SELECT COUNT (PLEVEL), PLEVEL FROM WORKER GROUP BY PLEVEL;

     (ii) SELECT MAX (DOB), MIN (DOJ) FROM WORKER;

     (iii) SELECT Name, Pay FROM WORKER W, PAYLEVEL P WHERE W. PLEVEL = S. PLEVEL AND P.ECODE<13 ;

     (iv) SELECT PLEVEL, PAY+ALLOWANCE FROM PAYLEVEL WHERE PLEVEL= 'P003' ;

 Please click the link below to download pdf file of CBSE Class 12 Computer Science Question paper 2010 (2).