Mastering SQL Conditions

What is the purpose of the SQL WHERE clause?

• To create new database tables.

• To sort records in ascending order.

• To join multiple tables together.

• To filter records based on specified conditions.

How do you use the AND operator in a SQL query?

• The AND operator is used only in JOIN statements.

• Use the AND operator in the WHERE clause to combine conditions.

• You can only use the AND operator in the GROUP BY clause.

• Use the OR operator in the SELECT clause to combine conditions.

What is the effect of using the OR operator in SQL?

• The OR operator is used to delete rows from a table.

• The OR operator returns rows that satisfy at least one of the given conditions.

• The OR operator only works with numeric data types.

• The OR operator returns rows that satisfy all of the given conditions.

Explain the function of the NOT operator in SQL.

• The NOT operator is a function that retrieves all records from a table.

• The NOT operator combines multiple conditions in SQL.

• The NOT operator negates a condition in SQL, returning true for false conditions.

• The NOT operator is used to sort data in SQL.

How does the LIKE operator work in SQL?

• The LIKE operator is only applicable to numeric data types.

• The LIKE operator is used to search for a specified pattern in SQL.

• The LIKE operator is used to create new tables in SQL.

• The LIKE operator is used to delete records in SQL.

What is the syntax for combining multiple conditions in a SQL query?

• Use 'NOT' operator to combine conditions.

• Use semicolons to separate conditions.

• Use 'AND' and 'OR' operators to combine conditions.

• Combine conditions using 'XOR' operator.

Can you use AND and OR together in a SQL statement? If so, how?

• You cannot use AND and OR together in a SQL statement.

• Yes, you can use AND and OR together in a SQL statement.

• Using AND and OR together is not allowed in SQL.

• AND and OR can only be used separately in SQL.

What will the following SQL statement return: SELECT * FROM users WHERE age > 18 AND city = 'New York'?

• A list of users who are older than 18 and live in New York.

• A list of users who are older than 18 regardless of their city.

• A list of users who are younger than 18 and live in New York.

• A list of users who are older than 18 and live in Los Angeles.

How would you write a SQL query to find names that start with 'A'?

• SELECT name FROM table_name WHERE name LIKE 'B%';

• SELECT name FROM table_name WHERE name LIKE 'A%';

• SELECT name FROM table_name WHERE name = 'A';

• SELECT name FROM table_name WHERE name NOT LIKE 'A%';

What is the result of using NOT with a condition in SQL?

• It inverts the truth value of the condition.

• It evaluates the condition as true regardless of its actual value.

• It returns the original condition unchanged.

• It combines the condition with AND.