SQL Basic Quiz Part 2 - 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 -2

Fill out the form to attempt test.

1 / 10

How would you retrieve rows where the column value is not equal to a specific value?

WHERE column != value

WHERE column NOT = value

WHERE column =! value

WHERE column <> value

2 / 10

What does the NOT operator do in SQL?

Inverts the result of a query

Replaces NULL values

Returns only matching values

Excludes values matching a condition

3 / 10

How would you combine multiple conditions using the AND operator in a WHERE clause?

WHERE column1 = 10 AND column2 = 20

WHERE column1 AND column2

WHERE column1 = 10 AND column2

WHERE column1 = 10 OR column2

4 / 10

What data type should you use to store integer values in SQL?

VARCHAR

INT

DATE

FLOAT

5 / 10

How would you retrieve 10 records starting from the 21st record?

SELECT * FROM table LIMIT 20, 10

SELECT * FROM table OFFSET 20 LIMIT 10

SELECT * FROM table LIMIT 10, 20

SELECT * FROM table OFFSET 10 LIMIT 20

6 / 10

What is the purpose of the LIMIT clause in SQL?

Limits the number of rows returned

Limits the columns in a result

Limits the query execution time

Limits the size of the table

7 / 10

How do you use the LIKE operator to find all records where the name starts with 'A'?

WHERE name LIKE 'A%'

WHERE name LIKE '%A'

WHERE name LIKE 'A_'

WHERE name = 'A%'

8 / 10

What does the LIKE operator do in SQL?

Matches exact values

Finds records that contain a specific pattern

Finds records that are larger than a value

Filters results by numeric range

9 / 10

How would you check if a value in a column is within a list of specific values (e.g., 1, 2, 3)?

WHERE column IN (1, 2, 3)

WHERE column LIKE '1, 2, 3'

WHERE column = (1, 2, 3)

WHERE column NOT IN (1, 2, 3)

10 / 10

What is the purpose of the IN operator in SQL?

To check if a value matches any value in a list

To find values within a range

To join two tables together

To group records based on column

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