MySQL Questions and Answers – Condition Types – 1

This set of MySQL Multiple Choice Questions & Answers (MCQs) focuses on “Condition Types – 1”.

1. Select odd one out?
a) Equality Conditions
b) Inequality Conditions
c) Range condition
d) Between
View Answer

2. The following MySQL query belongs to which condition types?

SELECT fname
FROM person
WHERE title=’TELLER’;

a) Equality condition
b) Inequality condition
c) Range condition
d) All of the mentioned
View Answer

3. The following MySQL statement belongs to which condition types?

SELECT fname
FROM person
WHERE fed_id=’111-11-111’;

a) Equality condition
b) Inequality condition
c) Range condition
d) All of the mentioned
View Answer

4. The following MySQL statement belongs to which condition types?

SELECT fname
FROM person
WHERE dept_id= (SELECT dept_id FROM department WHERE names=’s’);

a) Equality condition
b) Inequality condition
c) Range condition
d) All of the mentioned
View Answer

5. Is the following MySQL statement belongs to the “Equality condition”?

SELECT product_type.name, product.name
FROM product_type INNER JOIN Product
ON product_type.dept=Product.dept
WHERE product_type.name=’customers_accounts’;

a) Yes
b) No
c) Depends
d) None of the mentioned
View Answer

6. What is the meaning of “Equality Conditions”?
a) Equal to
b) Not equal to
c) Both Equal to and Not equal to
d) None of the mentioned
View Answer

7. What is the meaning of “Inequality Condition”?
a) Not equal to
b) Equal to
c) Both Not equal to and Equal to
d) None of the mentioned
View Answer

8. Does the following MySQL statement belong to the “Inequality condition”?

SELECT product_type.name, product.name
FROM product_type INNER JOIN Product
ON product_type.dept=Product.dept
WHERE product_type.name<>’customers_accounts’;

a) Yes
b) No
c) Depends
d) None of the mentioned
View Answer

9. Does the following MySQL statement belong to the “Inequality condition”?

SELECT product_type.name, product.name
FROM product_type INNER JOIN Product
ON product_type.dept=Product.dept
WHERE product_type.name! =’customers_accounts’;

a) Yes
b) No
c) Depends
d) None of the mentioned
View Answer

Sanfoundry Global Education & Learning Series – MySQL Database.

To practice all areas of MySQL Database, here is complete set of 1000+ Multiple Choice Questions and Answers.