Page 378 - Informatics_Practices_Fliipbook_Class12
P. 378

CBSE Sample Question Paper


                                            Class: XII Session: 2023-24

                                             INFORMATICS PRACTICES
                                                       Code 065

        Maximum Marks: 70                                                                            Time: 3 hours
        General instructions
        •   This question paper contains five sections, Section A to E.
        •   All questions are compulsory.
        •   Section A has 18 questions carrying 01 mark each.
        •   Section B has 07 Very Short Answer type questions carrying 02 marks each.
        •   Section C has 05 Short Answer type questions carrying 03 marks each.
        •   Section D has 02 questions carrying 04 marks each.
        •   Section E has 03 questions carrying 05 marks each.
        •   All programming questions are to be answered using Python Language only.
                                                        Section -A
         1.  A _____________ is a device that connects the organisation's network with the outside world of the Internet.
                                                                                                              [1]

            a. Hub                                              b.  Modem
            c.  Gateway                                         d. Repeater
         2.  When e-waste such as electronic circuit boards are burnt for disposal, the elements contained in them create a
            harmful chemical called ________which causes skin diseases, allergies and an increased risk of lung cancer.   [1]
            a. Hydrogen                                         b. Beryllium
            c.  Chlorine                                        d. Oxygen
         3.  Copyright, Patent and Trademark comes under:                                                     [1]
            a. Intellectual Property Right                      b. Individual Property Right
            c.  Industrial Property Right                       d. International Property Right
         4.  Predict the output of the following query:                                                       [1]

          SELECT MOD (9,0);
            a. 0                                                b. NULL
            c.  NaN                                             d. 9
          5.  Which of the following SQL functions does not belong to the Math functions category?            [1]
            a. POWER()                                          b. ROUND()
            c.  LENGTH()                                        d. MOD()
         6.  _____________ is not a FOSS tool.                                                                [1]
            a. Libre Office                                     b. Mozilla Firefox
            c.  Google Chrome                                   d. Python
         7.  CSV stands for:                                                                                  [1]
            a. Column Separated Value                           b. Class Separated Value
            c.  Comma Separated Value                           d. Comma Segregated Value
         8.  Raj, a Database Administrator, needs to display the average pay of workers from those departments which have
            more than five employees. He is experiencing a problem while running the following query:         [1]

            SELECT DEPT, AVG(SAL) FROM EMP WHERE COUNT(*) > 5


          364  Touchpad Informatics Practices-XII
   373   374   375   376   377   378   379   380   381   382   383