SQL OPERATORS AFL

What does the AND operator do in SQL?

• The AND operator combines conditions and returns true if any condition is true.

• The AND operator combines conditions and returns true only if all conditions are true.

• The AND operator is used to delete records from a table.

If I want to find records that match either condition, which operator should I use?

• NOT

• AND

• OR

What does the NOT operator do in SQL?

• The NOT operator combines two conditions in SQL.

• The NOT operator is used to select all records in SQL.

• The NOT operator adds a condition in SQL.

• The NOT operator negates a condition in SQL.

What will be the result of the following SQL statement?

• Students younger than 10 who are named Bob.

• Students younger than 10 who are not named Bob.

• All students who are not younger than 10.

Which of the following queries will return records of teachers who either have the name 'Mr. Smith' or are older than 30?

• SELECT * FROM teachers WHERE TeacherName = 'Mr. Smith' AND Age > 30;

• SELECT * FROM teachers WHERE TeacherName = 'Mr. Smith' OR Age > 30;

• SELECT * FROM teachers WHERE NOT (TeacherName = 'Mr. Smith' OR Age > 30);