List of top Computer Science Questions on SQL asked in CUET (UG)

Given table 'StudAtt' with structure as (Rno, Attdate, Attendance). Identify the suitable command to add a primary key to the table after creation.
Note: We want to make both Rno and Attdate columns as primary key.
A __________ value is specified for the column, if no value is provided.
The SELECT command when combined with DISTINCT clause is used to:
____________________________________ is used to search for a specific pattern in a column.

Give the output of the query:  SELECT MONTH("2010-03-05"); 

Match List-I with List-II:
List-I (Aggregate function)List-II (Description)
(A) count(marks)(III) Count all non null values of marks column
(B) count()(I) Count all rows
(C) avg(marks)(II) Finding average of non null values of marks
(D) sum(marks)(IV) Finding sum of all marks
Given Relation: \texttt{STUDENT} \begin{center} \begin{tabular}{|c|c|c|} \hline SNO & SNAME & MARKS
\hline 1 & Amit & 20
2 & Karuna & 40
3 & Kavita & NULL
4 & Anuj & 30
\hline \end{tabular} \end{center} Find the value of: \begin{verbatim} SELECT AVG(MARKS) FROM STUDENT; \end{verbatim}

Given the following table:

ENOSALARY
A1014000
B109NULL
C5086000
A3052000

State the output of the following query:

SELECT COUNT(SALARY) FROM EMPLOYEE;  

Match List-I with List-II.
List-IList-II
(A) SUBSTR()(II) To extract a substring from a string.
(B) TRIM()(IV) To remove spaces from both sides of the string.
(C) INSTR()(I) To find the position of a substring in a string.
(D) LEFT()(III) To extract characters from the left side of the string.
After establishing the connection to fetch the data from the table of a database in SQL into a DataFrame, which of the following function will be used?
(A) pandas.read__sql__query()
(B) pandas.read__sql__table()
(C) pandas.read__sql__query__table()
(D) pandas.read__sql()
Single row functions are also known as ________ functions.
Ms Ritika wants to delete the table 'sports' permanently. Help her in selecting the correct SQL command from the following.
Which of the following are text functions? (A) MID()
(B) INSTR()
(C) SUBSTR()
(D) LENGTH()
State the output of the following query: \[ \text{SELECT LENGTH(MID('INFORMATICS PRACTICES',5,-5));} \]
Match List-I with List-II:
List-IList-II
(A) group by(III) having
(B) mid()(IV) text function
(C) count()(II) aggregate function
(D) mod()(I) math function
What will be the format of the output of the NOW() function?
State the output of the following query: \[ \text{SELECT ROUND(9873.567,-2);} \]