Search Header Logo

SQL - Refining the result

Authored by Priteshkumar Bhimani

Special Education, Computers, Education

University

Used 15+ times

SQL - Refining the result
AI

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

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?