Test Your PostgreSQL 'AND' and 'OR' Operators Knowledge with This Quiz

Progress

True / False

In PostgreSQL, the AND operator is used to combine multiple conditions where all conditions must be true.

True False

The AND operator in PostgreSQL ensures that all combined conditions must be true for the overall condition to be true.

True / False

In PostgreSQL, the OR operator is used to combine multiple conditions where at least one condition must be true.

True False

The OR operator in PostgreSQL ensures that if at least one of the combined conditions is true, the overall condition is true.

True / False

In PostgreSQL, the AND and OR operators can be used together in a single SQL query.

True False

The AND and OR operators can be used together in PostgreSQL to form complex logical conditions in SQL queries.

True / False

In PostgreSQL, the AND operator has higher precedence than the OR operator.

True False

The AND operator has higher precedence than the OR operator, meaning AND conditions are evaluated before OR conditions unless parentheses are used.

True / False

In PostgreSQL, column1 = 'value1' OR column2 = 'value2' AND column3 = 'value3' is equivalent to (column1 = 'value1' OR column2 = 'value2') AND column3 = 'value3'.

True False

Due to operator precedence, the original condition evaluates column2 = 'value2' AND column3 = 'value3' first, not the entire expression inside parentheses.

True / False

In PostgreSQL, parentheses can be used to override the default precedence of AND and OR operators.

True False

Parentheses can be used to explicitly define the order of evaluation in logical expressions, overriding the default operator precedence.

True / False

In PostgreSQL, the query SELECT * FROM table WHERE (condition1 AND condition2) OR condition3 will return all rows that satisfy either condition3 or both condition1 and condition2.

True False

The query will return rows where condition3 is true or both condition1 and condition2 are true due to the use of parentheses.

True / False

In PostgreSQL, combining multiple AND and OR operators without parentheses may lead to unintended query results.

True False

Without parentheses, the default precedence of AND over OR can lead to unexpected results if not explicitly controlled.

True / False

In PostgreSQL, using WHERE (condition1 OR condition2) AND (condition3 OR condition4) ensures that either condition1 or condition2 must be true, and either condition3 or condition4 must be true.

True False

The parentheses ensure that the OR conditions are evaluated first, making sure at least one condition from each group is true.

Q10

True / False

In PostgreSQL, WHERE condition1 AND NOT (condition2 OR condition3) is a valid way to exclude rows where either condition2 or condition3 is true.

True False

This query structure is valid and ensures that rows where either condition2 or condition3 is true are excluded, combining AND with NOT and OR.

Q11

Single Choice

In PostgreSQL, which of the following queries will return rows where age is greater than 25 and city is 'New York'?

SELECT * FROM employees WHERE age > 25 OR city = 'New York'; SELECT * FROM employees WHERE age > 25 AND city = 'New York'; SELECT * FROM employees WHERE age < 25 AND city = 'New York';SELECT * FROM employees WHERE age > 25 AND city = 'Los Angeles';

The query uses the AND operator, which requires both conditions (age > 25 and city = 'New York') to be true.

Q12

Single Choice

What will the following PostgreSQL query return? SELECT * FROM students WHERE grade = 'A' AND grade = 'B';

All students with grade 'A' or 'B' All students with grade 'A' All students with grade 'B'No rows

Since a grade cannot be both 'A' and 'B' simultaneously, the query will return no rows.

Q13

Single Choice

: Which of the following queries uses the OR operator correctly in PostgreSQL?

SELECT * FROM orders WHERE order_date = '2024-08-01' OR order_date = '2024-08-02'; SELECT * FROM orders WHERE order_date = '2024-08-01' AND order_date = '2024-08-02'; SELECT * FROM orders WHERE order_date = '2024-08-01' AND order_date = '2024-08-02' OR order_date = '2024-08-03';SELECT * FROM orders WHERE order_date OR '2024-08-01';

The OR operator is used correctly to return rows where the order_date is either '2024-08-01' or '2024-08-02'.

Q14

Single Choice

In PostgreSQL, which of the following queries will return rows where either status is 'Active' or city is 'Boston'?

SELECT * FROM clients WHERE status = 'Active' AND city = 'Boston'; SELECT * FROM clients WHERE status = 'Active' OR city = 'Boston'; SELECT * FROM clients WHERE status = 'Inactive' AND city = 'Boston';SELECT * FROM clients WHERE status = 'Active' AND city != 'Boston';

The query returns rows where either the status is 'Active' or the city is 'Boston'.

Q15

Single Choice

Given the PostgreSQL query SELECT * FROM sales WHERE amount > 5000 AND (region = 'North' OR region = 'South');, what will it return?

A) Sales with amount greater than 5000 only in the North region Sales with amount greater than 5000 only in the South region Sales with amount greater than 5000 in either the North or South regionsSales with amount less than 5000 in either the North or South regions

The query returns rows where amount is greater than 5000 and region is either 'North' or 'South'.

Q16

Single Choice

In PostgreSQL, what will the following query return? SELECT * FROM inventory WHERE quantity < 10 AND (item_type = 'Electronics' OR item_type = 'Furniture');

All items with quantity less than 10 in any category All items with quantity less than 10 in Electronics or Furniture All items in Electronics or Furniture categoriesNo items at all

The query filters rows where quantity is less than 10 and item_type is either 'Electronics' or 'Furniture'.

Q17

Single Choice

What will the following PostgreSQL query return? SELECT * FROM employees WHERE (salary > 60000 AND department = 'HR') OR (salary < 30000 AND department = 'IT');

Employees with salary greater than 60000 in HR and less than 30000 in IT Employees with salary greater than 60000 in any department Employees with salary greater than 60000 in HR or salary less than 30000 in ITAll employees

The query uses a combination of AND and OR operators to return rows where salary > 60000 in HR or salary < 30000 in IT.

Q18

Single Choice

In PostgreSQL, which of the following queries will return rows where age is between 20 and 30 and country is either 'USA' or 'Canada'?

SELECT * FROM users WHERE age >= 20 AND age <= 30 OR country = 'USA' AND country = 'Canada'; SELECT * FROM users WHERE age >= 20 AND age <= 30 AND (country = 'USA' OR country = 'Canada'); SELECT * FROM users WHERE age >= 20 AND (age <= 30 OR country = 'USA') AND country = 'Canada'SELECT * FROM users WHERE (age >= 20 OR age <= 30) AND (country = 'USA' AND country = 'Canada');

The query correctly combines AND and OR operators to return users within the age range of 20-30 from either the USA or Canada.

Q19

Single Choice

What will the following PostgreSQL query return? SELECT * FROM projects WHERE (start_date = '2024-01-01' AND end_date = '2024-12-31') OR (status = 'Completed' AND priority = 'High');

Projects that started and ended in 2024 Projects that are either completed and high priority or span the year 2024 Projects with high priorityo projects

The query uses both AND and OR to return projects that either span the year 2024 or have been completed with high priority.

Q20

Single Choice

Which of the following PostgreSQL queries is most likely to be part of a certification exam and uses AND and OR operators effectively?

SELECT * FROM transactions WHERE amount > 10000 AND currency = 'USD' OR status = 'Pending' AND (region = 'Europe' OR region = 'Asia'); SELECT * FROM transactions WHERE amount > 10000 OR currency = 'USD' AND status = 'Pending' OR (region = 'Europe' AND region = 'Asia'); SELECT * FROM transactions WHERE amount > 10000 AND currency = 'USD' AND status = 'Pending' OR region = 'Europe' OR region = 'Asia';SELECT * FROM transactions WHERE amount > 10000 AND (currency = 'USD' OR currency = 'EUR') AND (status = 'Pending' OR status = 'Completed') AND (region = 'Europe' OR region = 'Asia');

This query effectively combines multiple AND and OR conditions to filter transactions based on amount, currency, status, and region. It demonstrates complex query writing skills that are often required in certification exams.

Q21

Multiple Choice

Identify the SQL scripts that correctly use the 'AND' and 'OR' operators to filter rows in PostgreSQL.

SELECT * FROM employees WHERE salary > 50000 AND (department_id = 10 OR department_id = 20); SELECT * FROM employees WHERE salary > 50000 OR department_id = 10 AND department_id = 20; SELECT * FROM employees WHERE salary > 50000 AND department_id = 10 OR department_id = 20;SELECT * FROM employees WHERE salary > 50000 AND department_id IN (10, 20);

The 'AND' operator is used to combine multiple conditions, and the 'OR' operator is used to specify multiple alternatives. The correct scripts will demonstrate how to use both operators effectively in PostgreSQL.

Q22

Multiple Choice

Select the SQL scripts that correctly use the 'AND' and 'OR' operators with string values in PostgreSQL.

SELECT * FROM customers WHERE city = 'New York' AND (status = 'Active' OR status = 'Pending'); SELECT * FROM customers WHERE city = 'New York' AND status = 'Active' OR status = 'Pending'; SELECT * FROM customers WHERE (city = 'New York' AND status = 'Active') OR status = 'Pending';SELECT * FROM customers WHERE city = 'New York' OR status = 'Active' AND status = 'Pending';

Using the 'AND' and 'OR' operators with string values requires careful attention to condition grouping. The correct scripts will demonstrate how to use these operators with string values in PostgreSQL.

Q23

Multiple Choice

Determine the SQL scripts that correctly use the 'AND' and 'OR' operators with subqueries in PostgreSQL.

SELECT * FROM products WHERE price < 100 AND (supplier_id IN (SELECT supplier_id FROM suppliers) OR category_id IS NULL); SELECT * FROM products WHERE price < 100 AND supplier_id IN (SELECT supplier_id FROM suppliers) OR category_id IS NULL; SELECT * FROM products WHERE price < 100 OR supplier_id IN (SELECT supplier_id FROM suppliers) AND category_id IS NULL;SELECT * FROM products WHERE (price < 100 AND supplier_id IN (SELECT supplier_id FROM suppliers)) OR category_id IS NULL;

The 'AND' and 'OR' operators can be combined with subqueries to filter rows based on complex conditions. The correct scripts will demonstrate how to use these operators with subqueries in PostgreSQL.

Q24

Multiple Choice

Identify the SQL scripts that correctly use the 'AND' and 'OR' operators with JOINs in PostgreSQL.

SELECT * FROM orders WHERE order_date BETWEEN '2023-01-01' AND '2023-12-31' AND (customer_id IN (SELECT customer_id FROM customers) OR status = 'Pending'); SELECT * FROM orders o JOIN customers c ON o.customer_id = c.customer_id WHERE order_date BETWEEN '2023-01-01' AND '2023-12-31' OR status = 'Pending'; SELECT * FROM orders WHERE order_date BETWEEN '2023-01-01' AND '2023-12-31' AND customer_id IN (SELECT customer_id FROM customers) OR status = 'Pending';SELECT * FROM orders WHERE order_date BETWEEN '2023-01-01' AND '2023-12-31' AND (customer_id IN (SELECT customer_id FROM customers) OR status = 'Pending');

The 'AND' and 'OR' operators can be used with JOINs to filter rows based on conditions in related tables. The correct scripts will demonstrate how to use these operators with JOINs in PostgreSQL.

Q25

Multiple Choice

Select the SQL scripts that correctly use the 'AND' and 'OR' operators with multiple conditions in PostgreSQL.

SELECT * FROM employees WHERE salary > 60000 AND (job_id = 'IT_PROG' OR hire_date > '2020-01-01'); SELECT * FROM employees WHERE salary > 60000 AND job_id = 'IT_PROG' OR hire_date > '2020-01-01'; SELECT * FROM employees WHERE salary > 60000 OR (job_id = 'IT_PROG' AND hire_date > '2020-01-01');SELECT * FROM employees WHERE (salary > 60000 AND job_id = 'IT_PROG') OR hire_date > '2020-01-01';

Using 'AND' and 'OR' operators with multiple conditions requires careful grouping to ensure correct logical evaluation. The correct scripts will demonstrate how to handle multiple conditions using these operators in PostgreSQL.

Q26

Multiple Choice

Determine the SQL scripts that correctly use the 'AND' and 'OR' operators with window functions in PostgreSQL.

SELECT employee_id, job_id, RANK() OVER (ORDER BY salary DESC) AS rank FROM employees WHERE job_id = 'SA_REP' OR salary > 70000; SELECT employee_id, job_id, DENSE_RANK() OVER (ORDER BY salary DESC) AS rank FROM employees WHERE job_id = 'SA_REP' OR salary > 70000; SELECT employee_id, job_id, ROW_NUMBER() OVER (ORDER BY salary DESC) AS rank FROM employees WHERE job_id = 'SA_REP' OR salary > 70000;SELECT employee_id, job_id, RANK() OVER (ORDER BY salary DESC) AS rank FROM employees WHERE job_id = 'SA_REP' AND salary > 70000;

The 'AND' and 'OR' operators can be used with window functions to filter and rank results based on complex conditions. The correct scripts will demonstrate how to use these operators with window functions in PostgreSQL.

Q27

Multiple Choice

Identify the SQL scripts that correctly use the 'AND' and 'OR' operators with EXISTS in PostgreSQL.

SELECT * FROM employees WHERE EXISTS (SELECT 1 FROM departments WHERE departments.department_id = employees.department_id) OR manager_id IS NULL; SELECT * FROM employees WHERE department_id IS NOT NULL OR EXISTS (SELECT 1 FROM departments WHERE departments.department_id = employees.department_id); SELECT * FROM employees WHERE department_id = NULL AND EXISTS (SELECT 1 FROM departments WHERE departments.department_id = employees.department_id);SELECT * FROM employees WHERE EXISTS (SELECT 1 FROM departments WHERE departments.department_id = employees.department_id) AND manager_id IS NULL;

The 'AND' and 'OR' operators can be combined with EXISTS to filter rows based on conditions in related tables or null values. The correct scripts will demonstrate how to use these operators with EXISTS in PostgreSQL.

Q28

Multiple Choice

Determine the SQL scripts that correctly use the 'AND' and 'OR' operators with UNION in PostgreSQL.

SELECT employee_id, city, status FROM employees WHERE city = 'San Francisco' AND (status = 'Active' OR status = 'Pending') UNION SELECT contractor_id, city, status FROM contractors WHERE city = 'San Francisco' AND (status = 'Active' OR status = 'Pending'); SELECT employee_id, city, status FROM employees WHERE city = 'San Francisco' AND status = 'Active' UNION SELECT contractor_id, city, status FROM contractors WHERE city = 'San Francisco' AND status = 'Pending'; SELECT employee_id, city, status FROM employees WHERE city = 'San Francisco' OR (status = 'Active' AND status = 'Pending') UNION SELECT contractor_id, city, status FROM contractors WHERE city = 'San Francisco' AND (status = 'Active' OR status = 'Pending');SELECT employee_id, city, status FROM employees WHERE city = 'San Francisco' AND (status = 'Active' OR status = 'Pending') UNION ALL SELECT contractor_id, city, status FROM contractors WHERE city = 'San Francisco' AND (status = 'Active' OR status = 'Pending');

The 'AND' and 'OR' operators can be used with UNION to filter and combine results from multiple tables based on complex conditions. The correct scripts will demonstrate how to use these operators with UNION in PostgreSQL.

Q29

Multiple Choice

Identify the SQL scripts that correctly use the 'AND' and 'OR' operators with DISTINCT in PostgreSQL.

SELECT DISTINCT department_id FROM employees WHERE location_id IN (1, 2) AND manager_id IS NOT NULL; SELECT DISTINCT department_id FROM employees WHERE location_id = 1 AND location_id = 2 AND manager_id IS NOT NULL; SELECT DISTINCT department_id FROM employees WHERE (location_id = 1 OR location_id = 2) AND manager_id IS NOT NULL;SELECT DISTINCT department_id FROM employees WHERE location_id IN (1, 2) OR manager_id IS NULL;

The 'AND' and 'OR' operators can be used with DISTINCT to filter unique rows based on specific conditions. The correct scripts will demonstrate how to use these operators with DISTINCT in PostgreSQL.

Q30

Multiple Choice

Determine the SQL scripts that correctly use the 'AND' and 'OR' operators with LIMIT OFFSET in PostgreSQL.

SELECT * FROM orders WHERE status = 'Shipped' OR status = 'Delivered' ORDER BY order_id LIMIT 10 OFFSET 0; SELECT * FROM orders WHERE status = 'Shipped' AND status = 'Delivered' ORDER BY order_id LIMIT 10; SELECT * FROM orders WHERE status = 'Shipped' OR status = 'Delivered' ORDER BY order_id LIMIT 10 OFFSET 5;SELECT * FROM orders WHERE status = 'Shipped' OR status = 'Delivered' ORDER BY order_id LIMIT 10 OFFSET 0;

The 'AND' and 'OR' operators can be used with LIMIT OFFSET to filter and paginate results based on multiple conditions. The correct scripts will demonstrate how to use these operators with LIMIT OFFSET in PostgreSQL.

PostgreSQL Database Quiz Questions