Data Analytics intership Quiz 8

What is the purpose of the SQL AND operator?

• • Retrieves records that meet either condition.

• Retrieves records that meet both conditions.

• • Retrieves records that do not meet the conditions.

• Retrieves records without any conditions.

In SQL, the OR operator is used to:

• • Combine multiple conditions and retrieve records that meet all conditions.

• • Combine multiple conditions and retrieve records that meet any of the conditions.

• • Exclude records that meet a specific condition.

• • Sort records in ascending or descending order.

What is the purpose of the SQL NOT operator?

• • Retrieves records that do not meet a specific condition.

• Retrieves records that meet a specific condition.

• • Combines multiple conditions using logical OR.

• • Sorts records based on a specified column.

Which of the following SQL queries uses the AND operator correctly?

• • SELECT * FROM employees WHERE salary > 50000 AND department = 'IT';

• • SELECT * FROM employees WHERE salary > 50000 OR department = 'IT';

• • SELECT * FROM employees WHERE salary > 50000 NOT department = 'IT';

• • SELECT * FROM employees WHERE salary > 50000 AND/OR department = 'IT';

The SQL query SELECT * FROM products WHERE NOT category = 'Electronics'; will retrieve:

• • All products in the 'Electronics' category.

• • All products not in the 'Electronics' category.

• • All products with a NULL category.

• • All products with a specified category.

Which SQL operator is used to filter the result set based on multiple conditions, allowing the retrieval of records that meet both conditions?

• AND

• OR

• NOT

• BETWEEN

In SQL, the IN operator is used for:

• Pattern matching in string columns.

• Specifying a range of values.

• Combining multiple conditions with logical AND.

• Filtering records based on a list of values

The SQL query SELECT * FROM customers WHERE country IN ('USA', 'Canada', 'UK'); will retrieve records for customers from:

• • Only the USA.

• • USA, Canada, and UK.

• • Any country except the specified ones.

• • Canada and UK only.

What does the SQL LIKE operator do?

• • Matches exact values in a column.

• • Performs arithmetic calculations.

• • Compares two columns for equality.

• • Matches patterns in string columns using wildcards

The SQL IS NULL operator is used to:

• • Check if a column is empty.

• • Retrieve records where a column has a specified value

• • Check if a column contains numeric values.

• • Retrieve records where a column is not empty.