Page 363 - Informatics_Practices_Fliipbook_Class12
P. 363

6.  Which one of the following is not a public license?
                a.  CC licenses

                b.  GNU General Public License
                c.  Apache License
                d.  Microsoft Windows License
              7.  Which of the following software tool can be used to view the content of a CSV file?
                a.  Adobe Photoshop                               b.  MS Excel

                c.  MS Paint                                      d.  None of these
              8.  Vanshika has entered the following SQL statement to retreive the lowest salary for each city:
                SELECT MIN(SALARY) FROM TRADER GROUP BY SALARY;
                  But she is not getting the desired result. Which one of the following statement is the correct way of achieving the
                same?
                a.  SELECT MIN(SALARY) FROM TRADER GROUP BY CITY;
                b.  SELECT CITY, MIN(SALARY) FROM TRADER GROUP BY SALARY;
                c.  SELECT CITY, MIN(SALARY) FROM TRADER GROUP BY CITY;
                d.  SELECT CITY, MIN(SALARY) FROM TRADER ORDER BY CITY;
              9.  What will be the output produced on the execution of following SQL statement?

                SELECT POWER(5,2);
                a.  10                                            b.  25

                c.  7                                             d.  32
             10.  ________________ attribute is used to get or set the index labels of the Pandas Series object.
                a.  shape                                         b.  dtype
                c.  index                                         d.  size

             11.  Which of the following SQL data type is used to store fixed length character strings between 1 to 255 characters?
                a.  CHAR                                          b.  VARCHAR
                c.  STRING                                        d.  FLOAT
             12.   What is the purpose of the describe() function in Pandas Series?
                a.  It provides a summary statistics of the Series.

                b.  It returns the first few elements of the Series.
                c.  It calculates the cumulative sum of the Series.
                d.  It checks for missing values in the Series.
             13.   What type of cybercrime is represented when Amrit receives an email from his bank stating that he has won Rs.
                1,00,000, and is required to click on a provided link to claim the prize by sharing his details?
                a.  Plagiarism                                    b.  Cyber stalking
                c.  Eavesdropping                                 d.  Phishing

             14.   Which of the following methods can be used to set the column 'RollNumber' as the index of a DataFrame named
                'df'?

                a.  df.set_index('RollNumber')
                b.  df.index('RollNumber')
                c.  df.set_index(['RollNumber'])
                d.  df.index = 'RollNumber'


                                                                                                Practice Paper 1  349
   358   359   360   361   362   363   364   365   366   367   368