SQL - Refining the result
Authored by Priteshkumar Bhimani
Special Education, Computers, Education
University
Used 15+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which signs are used for string pattern in SQL?
% and _
% and #
_ and #
# and #
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Choose output for following sql statement.
Select * from employee where fname LIKE 'a%';
Give all the data from emplyee table
Give all the data from employee table in which fname end with 'a'
Give all the data from employee table in which fname start with 'a'
None
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
what is the output of sql statement,
Select * form t1 where t1 Like '_t%'
Give all the data from t1 table
Give all the data from t1 table in which t1 column has second position data with t.
Give all the data from t1 table in which t1 column has first position data with t.
None
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which operator is used to select the values within the ranges?
LIKE
RANGES
BETWEEN
NONE
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Select correct sql statement for given information.
"all the data from product table in which price of the product will within the 10 and 20."
None
SELECT * FROM ProductsWHERE Price BETWEEN 10 AND 20;
SELECT * FROM Product where price 10 and 20;
SELECT * FROM ProductsWHERE Price BETWEEN 10 OR 20;
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which keyword is used to sort the data in sql?
LIKE
Order by
Group by
none
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
By default, in which sorted form sql will will sorting the data If we used order by?
Ascending
Descending
Do not allow to sort
None
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
