CUET-UG SERIES Computer-science
Query Using Sql
5 previous year questions.
Volume: 5 Ques
Yield: Medium
High-Yield Trend
5
2023 Chapter Questions 5 MCQs
01
PYQ 2023
medium
computer-science ID: cuet-ug-
What is the output of the following SQL query ?
SELECT * FROM STUDENTS WHERE SName like ‘%S’ and age > 18;
SELECT * FROM STUDENTS WHERE SName like ‘%S’ and age > 18;
1
Select details of all those students whose name ends with 'S' and age greater than 18
2
Select details of all those students whose name starts with 'S' and age greater than 18
3
Select details of all those students whose name starts and ends with 'S' and age is greater than 18
4
Select details of all those students whose name starts with 'S' or age greater than 18
02
PYQ 2023
medium
computer-science ID: cuet-ug-
What will be returned by the given query ?
SELECT INSTR("DBITBTTSIT", “IT”);
SELECT INSTR("DBITBTTSIT", “IT”);
1
2
2
3
3
10
4
-2
03
PYQ 2023
medium
computer-science ID: cuet-ug-
Which of the following statement is NOT correct ?
A. By default, ORDER by clause sorts the result set in decreasing order
B. SUM() function is used to count the total no. of records in a table
C. By default, ORDER BY clause sorts the results set in increasing order
D. AVG() is an aggregrate function
E. The WHERE clause is used to specify filtering conditions for groups
Consider the correct answer from the options given below :
A. By default, ORDER by clause sorts the result set in decreasing order
B. SUM() function is used to count the total no. of records in a table
C. By default, ORDER BY clause sorts the results set in increasing order
D. AVG() is an aggregrate function
E. The WHERE clause is used to specify filtering conditions for groups
Consider the correct answer from the options given below :
1
A, C and D only
2
B, C and D only
3
A, B and E only
4
A, B and C only
04
PYQ 2023
medium
computer-science ID: cuet-ug-
What will be the output of the given SQL Query SELECT DAY("2023-03-01);
1
Thursday
2
1
3
2023-03-01
4
3
05
PYQ 2023
medium
computer-science ID: cuet-ug-
Mohan wants to display all the attributes and all the tupIes of the table 'Teacher', help him to choose the correct SQL statement :
(A) Select % from teacher ;
(B) Select from teacher ;
(C) Select all from teacher ;
(D) Select * from teacher ;
Choose the correct answer from the options given below :
(A) Select % from teacher ;
(B) Select from teacher ;
(C) Select all from teacher ;
(D) Select * from teacher ;
Choose the correct answer from the options given below :
1
(D) only
2
(A) and (B) only
3
(B), (C) and (D) only
4
(A), (B) and (D) only