Page 321 - IT-802_class_12
P. 321

iii.  This portal is a one point source to access all Indian Government websites at all levels and from all sectors. Name the portal.  1
                iv.   REEMA wants to arrange names of students in alphabetical order in the student table. Give the MYSQL command to create
                   a sorted list.                                                                                  1
                v.  .................... is not an aggregate function.                                             1
                   (a)  Sum()            (b)  Count()             (c)  Round()             (d)  Avg()
                vi. Give one benefit of online reservation.                                                        1

                                              SECTION B: SUBJECTIVE TYPE QUESTIONS

            Answer any 3 out of the given 5 questions on Employability Skills.                         (2 × 3 = 6 marks)
            Answer each question in 20 – 30 words.
                Q 7.   Explain any two methods to deal with stress.                                            ½ + 1½
                Q 8.   What are the essential components of effective written communication?                       2
                Q 9.     Explain the concept of "eco-friendly consumerism." How does conscious consumer behavior influence market trends
                       and encourage sustainable production practices?                                             2
                Q 10.     Write down the steps to protect your spreadsheet in Calc?                                2
                Q 11.   What are the two major functions performed by an Entrepreneur?                             2

            Answer any 3 out of the given 5 questions.                                                 (2 × 3 = 6 marks)
                Q 12.   Give the output of the following code segment-                                           1+1
                   public class main {
                      public static void main(String[] args) {
                          int day = 4;
                          switch (day) {
                          case 6:
                          System.out.println("Today is Saturday");
                          break;
                       case 7:
                          System.out.println("Today is Sunday");
                          break;
                      default:
                          System.out.println("Looking forward to the Weekend");
                     }
                  }
                }
                Q 13.   Explain Drop table with Cascade command in My SQL.                                       1+1
                Q 14.     Explain any two operations performed on database.                                        2
                Q 15.     A hospital is making database of its doctors and patients. Doctor table includes doc code, idoc name, dept. Give
                       details of Patient Table along with its schema.                                           1+1
                Q 16.   Find error and rewrite the correct code                                                  1+1
                  i == 0;
                  while (i < 5)
                      { System.out.println(i)
                      i++;
            Answer any 2 out of the given 3 questions.                                                 (3 × 2 = 6 marks)
                Q 17.   Complete the code in JAVA using a loop to print "Yes" 5 times:                         1+1+1
                   ______ (int i = 0; i < 5; _______ )

                  {
                  ______(”yes”);
                  }
                                                                                                                319
                                                                                    CBSE Sample Question Paper  319
   316   317   318   319   320   321   322