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

Skip to content

Programs
Quiz
Tutorials
Mock Questions
Blog

Register For Free

QUIZ Time Starts !

5 minutes

Thanks you have successfully attempted the quiz.

SQL Basic Part -4

Fill out the form to attempt test.

1 / 10

How do you delete all rows in a table without removing the table itself?

DELETE FROM table

DROP TABLE table

TRUNCATE TABLE table

CLEAR TABLE table

2 / 10

How can you remove duplicates from a column in SQL?

SELECT DISTINCT column

SELECT UNIQUE column

SELECT WITHOUT DUPLICATES column

SELECT REMOVE DUPLICATES column

3 / 10

How do you use the BETWEEN operator in SQL?

WHERE column BETWEEN 1 AND 10

WHERE column LIKE '1-10'

WHERE column > 1 AND < 10

WHERE column BETWEEN '1' AND '10'

4 / 10

Which operator is used to combine multiple conditions in a WHERE clause?

AND

OR

NOT

BETWEEN

5 / 10

What does the LIMIT clause do in SQL?

Limits the number of rows returned

Limits the number of columns returned

Limits the query execution time

Limits the number of tables used

6 / 10

Which SQL function would you use to find the number of characters in a string?

LEN()

LENGTH()

SIZE()

CHAR_LENGTH()

7 / 10

Which of the following is not a valid SQL data type?

BOOLEAN

TEXT

STRING

VARCHAR

8 / 10

What is the result of the query: SELECT 1 + 1;?

2

1+1

NULL

Syntax error

9 / 10

How can you retrieve the first 10 rows from a table in SQL?

SELECT TOP 10 * FROM table

SELECT * FROM table LIMIT 10

SELECT * FROM table OFFSET 0 LIMIT 10

SELECT * FROM table

10 / 10

What is the default sorting order in SQL when using ORDER BY?

Descending

Ascending

Alphabetical

No sorting is applied by default

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