Page 379 - Informatics_Practices_Fliipbook_Class12
P. 379

GROUP BY DEPT;
                Which of the following is a correct query to perform the given task?
                a. SELECT DEPT, AVG(SAL) FROM EMP WHERE COUNT(*) > 5 GROUP BY DEPT;
                b. SELECT DEPT, AVG(SAL) FROM EMP HAVING COUNT(*) >
                  5 GROUP BY DEPT;
                c.  SELECT DEPT, AVG(SAL) FROM EMP GROUP BY DEPT WHERE COUNT(*) > 5;
                d.  SELECT DEPT, AVG(SAL) FROM EMP GROUP BY DEPT HAVING COUNT(*) > 5;
             9.  Predict the output of the following query:                                                       [1]

                SELECT LCASE (MONTHNAME ('2023-03-05'));
                a. May                                             b. March
                c.  may                                            d. march
              10. Which of the following command will show the last 3 rows from a Pandas Series named NP?         [1]
                a. NP.Tail( )                                      b. NP.tail(3)
                c.  NP.TAIL(3)                                     d. All of the above
            11. With reference to SQL, identify the invalid data type.                                            [1]
                a. Date                                            b. Integer
                c.  Varchar                                        d. Month
            12. In Python Pandas, while performing mathematical operations on series, index matching is implemented and all
               missing values are filled in with _by default.                                                     [1]

                a. Null                                            b. Blank
                c.  NaN                                            d. Zero
              13. By restricting the server and encrypting the data, a software company's server is unethically accessed in order to
               obtain sensitive information. The attacker blackmails the company to pay money for getting access to the data,
               and threatens to publish sensitive information unless price is paid. This kind of attack is known as:   [1]
                a. Phishing                                        b. Identity Theft
                c.  Plagiarism                                     d. Ransomware
              14. In SQL, the equivalent of UCASE() is:                                                           [1]
                a. UPPERCASE ()                                    b. CAPITALCASE()
                c.  UPPER()                                        d. TITLE ()
              15. Collection  of  hyper  linked  documents  available  on  the  internet  is  known as _____________.  [1]
                a. Website                                         b. Webpage
                c.  Web Server                                     d. Web Hosting
              16. _____________ is a non-profit organization that aims to build a publicly accessible global platform where a
               range of creative and academic work is shared freely.                                              [1]
                a. Creative Cost                                   b. Critical Commons
                c.  Creative Commons                               d. Creative Common
              17. Assertion (A): MODEM stands for modulator-demodulator.                                          [1]
                Reasoning (R): It is a computer hardware device that converts data from a digital format to analog and vice versa.
                a. Both A and R are true and R is the correct explanation for A
                b. Both A and R are true and R is not the correct explanation for A
                c.  A is True but R is False
                d. A is false but R is True
              18. Assertion (A): To use the Pandas library in a Python program, one must import it.               [1]
                Reasoning (R): The only alias name that can be used with the Pandas library is pd.
                a. Both A and R are true and R is the correct explanation for A
                b. Both A and R are true and R is not the correct explanation for A
                c.  A is True but R is False
                d. A is false but R is True

                                                                                     CBSE Sample Question Paper  365
   374   375   376   377   378   379   380   381   382   383   384