CUET (UG) entrance exam Question Bank Solutions for Computer Science\Information Practices

The name “Pandas” is derived from the term ______.

Python pandas was developed by ______.

The school offers Wi-Fi to the students of Class XII, and emails were received by all the students regarding the expiry of their passwords. Instructions were also given to renew their password within 24 hours by clicking on the particular URL provided. What do you think they should do?

Which of the following error is also known as Syntax Error?

______ is used to get a specified day of the month for a given date.

______ keyword is used to find out the number of values in a column?

Which method is used to get the row-id of the last modified row?

Which of the following belongs to an "aggregate function"?

The MAX () function finds the

Which of the following digital footprints can be created without the user's consent?

Assertion (A): To create a series from array, we have to import the NumPy module and then use array () method.

Reason (R): NumPy is an open-source numerical Python library. NumPy contains a multi-dimensional array and matrix data structures.

Consider the table STUDENT given below:

State the command that will give the output as:

(i) select Name from student where Class ='XI' and Class='XII';

(ii) select name from student where not Class='XI' and Class='XII';

(iii) select name from student where City="Agra" or City="Mumbai";

(iv) select name from student where City in("Agra", "Mumbai");

Choose the correct option:

Consider the table STUDENT given below:

State the command to display the average marks scored by students of each gender who are in class XI?

(i) Select Gender, avg(Marks) from STUDENT where Class= "XI" group by Gender;

(ii) Select Gender, avg(Marks) from STUDENT group by Gender where Class="XI";

(iii) Select Gender, avg(Marks) group by Gender from STUDENT having Class="XI";

(iv) Select Gender, avg(Marks) from STUDENT group by Gender having Class = "XI";

Choose the correct option:

What will be the output of the following SQL statement? 

SELECT DAY NAME (2022-04-08) 

Assertion (A): COUNf function ignores DISTINCT

Reason (R): DISTINCT ignores the duplicate values.

What types of errors are also known as parsing errors?

What will be the output for the following code?

x = ""hello""
if not type(x) is int:
raise TypeError(""Only integers are allowed"")

The only exception that is raised when the program is syntactically incorrect:

What exception will be thrown in the following case?

>>> import math

>>> math .sqrt(– 4)

Which of the following is not an aggregate function?