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
About Query Using Sql - CUET-UG
Query Using Sql is a vital chapter for CUET-UG aspirants. Mastering the concepts covered in this chapter is essential for securing a top rank.
By rigorously practicing the previous year questions associated with this chapter, you can identify high-yield topics, understand the examiner's perspective, and boost your confidence during the actual exam.
Frequently Asked Questions
Why focus on Query Using Sql PYQs?
Analyzing PYQs for this specific chapter reveals the most frequently tested concepts and the typical complexity of questions, allowing you to tailor your study plan efficiently.
How to best use this analysis?
Review the topic breakdown to see which sub-topics within Query Using Sql carry the most weight. Then, tackle the questions iteratively to solidify your understanding.