CUET (UG) entrance exam Question Bank Solutions

To skip NaN values in a calculation, you can specify the ______ attribute.  

Which command is correct to display the total number of all ITEMS in the STOCK data frame?

Which command is correct to display the total QUANTITY of all ITEMS in the STOCK? 

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

In general, a file is basically a collection of all related ______.

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

WWW stands for ______.

HTML stands for ______.

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

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

A file is a

The MAX () function finds the

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.

Data can be stored permanently on ______.

Expansion of SMIP is ______.

Which of the following is not an aggregate function?

The programmers who break into secure systems for malicious purpose are