SQL Basic Quiz Part 5 - Learn DA-DS Course in Hindi

Programs
Quiz
Tutorials
Mock Questions
Blog

QUIZ Time Starts !

5 minutes

Thanks you have successfully attempted the quiz.

SQL Basic Part -5

Fill out the form to attempt test.

1 / 10

How do you retrieve the second highest salary from a salaries table?

SELECT MAX(salary) FROM salaries WHERE salary < (SELECT MAX(salary) FROM salaries)

SELECT TOP 2 salary FROM salaries ORDER BY salary DESC

SELECT salary FROM salaries LIMIT 2

SELECT MIN(salary) FROM salaries WHERE salary > (SELECT MIN(salary) FROM salaries)

2 / 10

Which of the following operators can be used to compare a column value with a range of values?

BETWEEN

NOT LIKE

3 / 10

Which SQL keyword is used to remove duplicates from the result set?

REMOVE

UNIQUE

DISTINCT

NO_DUPLICATES

4 / 10

Which of the following clauses cannot be used in a SELECT statement?

ORDER BY

GROUP BY

HAVING

DELETE

5 / 10

What does the MIN() function in SQL do?

Returns the minimum value of a column

Returns the maximum value of a column

Returns the average value of a column

Returns the first value in a column

6 / 10

How do you find the last 10 rows from a query result?

SELECT * FROM table LIMIT 10 OFFSET 10

SELECT * FROM table ORDER BY column DESC LIMIT 10

SELECT TOP 10 * FROM table

SELECT * FROM table LIMIT 10

7 / 10

Which of the following is a valid SQL query to update a record?

UPDATE table SET column = value WHERE condition

UPDATE table VALUES column = value

UPDATE table COLUMN value

UPDATE table condition

8 / 10

What does the UPDATE statement do in SQL?

Deletes existing records

Modifies existing records

Adds new records

Retrieves records

9 / 10

Which clause is used to sort the result set in ascending or descending order?

WHERE

ORDER BY

LIMIT

HAVING

10 / 10

What does the NOT NULL constraint do in SQL?

Ensures the column does not contain NULL values

Ensures the column has a default value

Ensures the column is unique

Ensures the column is indexed

Your score is

Welcome to DADS Course

Email : info@techpratham.com

Phone (India) : +91-8882178896

WhatsApp : +91-8384036614

Resourses

Student Registration
Dashboard

Quick Links

Contact Us
About US

Support

Refund Policy
Privacy Policy
FAQs