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

