Page 15 - IPP-12-2024

(ii) By disturbing biodiversity and causing harm to ecosystems
(iii) By being harmful to microorganisms in the soil and plants
(iv) All of these
Ans. (iv) All of these
7. The default delimiter character of CSV file is ______________. (1)
(i) :(colon) (ii) \t(tab)
(iii) ,(comma) (iv) ;(semicolon)
Ans. (iii) , (comma)
8. Rakesh, a database administrator (DBA) at a university, is trying to retrieve department-wise number of
students who have not attempted examination more than once. (1)
Which of the following is the correct query to perform the given task?
(i) SELECT DEPARTMENT,COUNT(*)
AS 'TOTAL_ATTEMPTS' FROM STUDENTS
GROUP BY DEPARTMENT
HAVING TOTAL_ATTEMPTS<=1;
(ii) SELECT DEPARTMENT, COUNT (*) FROM STUDENTS

HAVING EXAM_STATUS = "F"
GROUP BY DEPARTMENT;
(iii) SELECT * FROM STUDENTS
WHERE EXAM_STATUS = "F"
GROUP BY DEPARTMENT;
(iv) SELECT * FROM STUDENTS

GROUP BY DEPARTMENT;
WHERE EXAM_STATUS = "F";
Ans. (i) SELECT DEPARTMENT, COUNT(*)
AS 'TOTAL_ATTEMPTS' FROM
STUDENTS GROUP BY DEPARTMENT
HAVING TOTAL_ATTEMPTS<=1;
9. Predict the output of the following query: (1)

SELECT length(upper(rtrim("i am great ")));
(i) 10 (ii) 15
(iii) I AM GREAT (iv) I am great

Ans. (i) 10
10. Which of the following commands will show the first 8 rows from a Pandas Series named sries? (1)
(i) sries.head(8) (ii) sries.tail(8)
(iii) sries.head() (iv) None of these

Ans. (i) sries.head(8)
11. Which of the following SQL functions, when applied to the date "2023-12-24", would output SUNDAY? (1)
(i) DAYOFMONTH() (ii) DAYOFNAME()
(iii) DAYOFWEEK() (iv) DAYNAME()

Ans. (iv) DAYNAME()
12. Which of the following data structures is used to analyze the data in pandas? (1)
(i) Dataframe (ii) Series
(iii) Both (i) and (ii) (iv) None of these
Ans. (iii) Both (i) and (ii)

2 MODEL TEST PAPER