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

