CUET (UG) entrance exam Question Bank Solutions

______ 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?

An error object does not have information of:

What error is returned by the following statement if the file does not exist? 

f = open("A.txt")

Which of the following is not a valid plotting function of 'pyplot'?  

The data taken from a digital footprint can be used for: 

The char() function in MySql is an example of ______.