Course: MySQL

Topic: MySQL SQL Basics Quiz

Total Time: 5 Minutes

Difficulty Level: medium

Q1: What is the purpose of the AND operator in MySQL?

(1 point)

A. It returns rows when any condition is true

B. It returns rows only when all conditions are true

C. It reverses a condition

D. It sorts the result

Q2: What is the purpose of the OR operator?

(1 point)

A. It returns rows when both conditions are true

B. It returns rows when at least one condition is true

C. It returns rows only when no condition is true

D. It removes duplicate rows

Q3: What does the NOT operator do?

(1 point)

A. It combines conditions

B. It sorts results

C. It reverses a condition

D. It limits output

Q4: Which query selects users who are active and older than 25?

(1 point)

A. WHERE status = 'active' OR age > 25

B. WHERE status = 'active' AND age > 25

C. WHERE status = 'active' NOT age > 25

D. WHERE status = 'active' XOR age > 25

Q5: Which condition excludes users from the city "Pune"?

(1 point)

A. WHERE city = 'Pune'

B. WHERE city <> 'Pune'

C. WHERE NOT city = 'Pune'

D. Both b and c

Q6: Which operator has the highest precedence?

(1 point)

A. OR

B. AND

C. NOT

D. All have equal priority

Q7: Which query selects users who are either from Delhi or Mumbai and are active?

(1 point)

A. WHERE city = 'Delhi' OR city = 'Mumbai' AND status = 'active'

B. WHERE (city = 'Delhi' OR city = 'Mumbai') AND status = 'active'

C. WHERE city = 'Delhi' AND city = 'Mumbai' AND status = 'active'

D. WHERE city IN ('Delhi','Mumbai','active')

Q8: Which query selects users who are not from Chennai and not inactive?

(1 point)

A. WHERE city != 'Chennai' OR status != 'inactive'

B. WHERE city != 'Chennai' AND status != 'inactive'

C. WHERE NOT city = 'Chennai' OR NOT status = 'inactive'

D. WHERE city = 'Chennai' AND status = 'inactive'

Q9: Which expression is logically equivalent to NOT (age > 30 OR status = 'inactive')?

(1 point)

A. age <= 30 AND status != 'inactive'

B. age <= 30 OR status != 'inactive'

C. age > 30 AND status = 'inactive'

D. age < 30 AND status = 'inactive'

Q10: Which query correctly selects users whose status is neither 'blocked' nor 'deleted'?

(1 point)

A. WHERE status != 'blocked' OR status != 'deleted'

B. WHERE status NOT IN ('blocked','deleted')

C. WHERE NOT status = 'blocked' OR NOT status = 'deleted'

D. WHERE status <> 'blocked' OR status <> 'deleted'

MySQL Quiz Instructions

Welcome to the MySQL AND, OR, NOT Quiz.

This quiz tests your understanding of the AND, OR, and NOT operators in MySQL, which are used to combine and control multiple conditions in SQL queries. These logical operators are commonly used with the WHERE clause to filter records based on more than one condition. In real-world database applications, you often need to apply multiple filters at the same time. Understanding how AND, OR, and NOT work helps you write accurate and efficient queries. This quiz focuses on how logical conditions are evaluated in MySQL. Read the instructions carefully before you begin.

Quiz Format

Total Questions: 10
Difficulty Level: Medium
Question Type: Multiple Choice
Each question has one correct answer.

Timing

Total time limit: 5 minutes
Move through the questions steadily without rushing.

Scoring

Each correct answer = +1 point
No negative marking
Maximum Score = 10 points

How to Play

Read each question carefully and analyze the SQL query provided.
Understand how the AND operator works when combining conditions.
Learn how the OR operator expands filtering criteria.
Focus on how the NOT operator reverses a condition.
Observe how multiple logical operators work together in a single query.
Understand operator precedence in logical expressions.
Identify correct and incorrect query results based on conditions.
Pay attention to how parentheses affect evaluation.
Choose the option that best represents correct MySQL logical behavior.
Once you move to the next question, you cannot return to previous ones.

Rules

Do not refresh or close the quiz window during the attempt.
Avoid using notes, books, or online help.
Keep track of the timer throughout the quiz.

Before You Start

You can revise the topic here: MySQL AND, OR, NOT Tutorial

After Submission

Your score will be displayed instantly.
Review the correct answers to understand mistakes.
This will help you confidently combine conditions in MySQL queries.

Programming Language

Web Development

Other Languages

Programming Language

Web Development

Other Languages

Course: MySQL

Topic: MySQL SQL Basics Quiz

Total Time: 5 Minutes

Details required to play the Quiz

Topic: MySQL SQL Basics Quiz

MySQL Quiz Instructions

Welcome to the MySQL AND, OR, NOT Quiz.

Latest Blogs

Quick Links

Our Tutorials