PostgreSQL Logical Operators Quiz: Test Your SQL Knowledge

Progress

True / False

The logical operator AND in PostgreSQL returns true if both operands are true.

True False

In PostgreSQL, the AND operator returns true only if both operands are true. If either operand is false, the result is false.

True / False

The logical operator OR in PostgreSQL returns true if either of the operands is true.

True False

In PostgreSQL, the OR operator returns true if at least one of the operands is true. If both operands are false, the result is false

True / False

The logical operator NOT in PostgreSQL is used to invert the truth value of a condition.

True False

The NOT operator in PostgreSQL negates the truth value of its operand. If the operand is true, NOT makes it false, and vice versa.

True / False

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

True False

In PostgreSQL, logical operators follow standard precedence rules. The AND operator has a higher precedence than the OR operator, meaning it is evaluated before OR in expressions.

True / False

PostgreSQL supports short-circuit evaluation for logical operators.

True False

PostgreSQL uses short-circuit evaluation for logical operators. This means that in an expression with multiple logical operators, evaluation stops as soon as the result is determined.

True / False

In PostgreSQL, TRUE AND NULL evaluates to NULL.

True False

In PostgreSQL, any logical operation involving NULL results in NULL, unless it can be determined that the result is FALSE regardless of the NULL value.

True / False

The XOR logical operator is natively supported in PostgreSQL.

True False

PostgreSQL does not have a native XOR logical operator. However, similar functionality can be achieved using expressions like (a OR b) AND NOT (a AND b).

True / False

In PostgreSQL, NULL OR FALSE evaluates to FALSE.

True False

In PostgreSQL, NULL OR FALSE evaluates to NULL. Since NULL represents an unknown value, the result of the logical OR operation cannot be determined if one of the operands is NULL.

True / False

In PostgreSQL, using NOT with NULL results in TRUE.

True False

In PostgreSQL, NOT NULL evaluates to NULL. Since NULL represents an unknown value, negating it does not result in a known true or false value.

Q10

True / False

In PostgreSQL certification exams, understanding the precedence of logical operators is crucial for writing correct queries.

True False

Understanding the precedence of logical operators like AND, OR, and NOT is essential for writing correct and efficient queries in PostgreSQL. This knowledge helps in structuring queries properly to avoid logical errors.

Q11

Single Choice

Which logical operator is used in PostgreSQL to combine conditions so that both must be true?

OR AND NOTXOR

The AND logical operator in PostgreSQL is used to combine multiple conditions, and the result is true only if all conditions are true.

Q12

Single Choice

What will be the result of the following SQL query in PostgreSQL?

SQL Code

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

All employees Employees in the Sales department Employees in the Sales department with a salary greater than 50,000Employees with a salary greater than 50,000

The AND operator ensures that only employees who meet both conditions (department is 'Sales' and salary is greater than 50,000) are selected.

Q13

Single Choice

Which PostgreSQL logical operator will return true if either of the conditions is true?

AND OR NOTXOR

The OR operator in PostgreSQL returns true if at least one of the conditions separated by it is true.

Q14

Single Choice

Consider the following SQL query in PostgreSQL. What will it return?

SQL Code

SELECT * FROM orders WHERE order_date > '2024-01-01' OR customer_id = 102;

Orders placed after January 1, 2024, by customer 102 Orders placed after January 1, 2024, or by customer 102 Orders placed by customer 102Orders placed after January 1, 2024, by any customer

The OR operator returns true if either condition (order date after '2024-01-01' or customer ID equals 102) is true, so the query returns orders that match either condition.

Q15

Single Choice

What does the following PostgreSQL query return?

SQL Code

SELECT * FROM products WHERE NOT (price < 20);

Products with a price less than 20 Products with a price of 20 Products with a price greater than or equal to 20Products with a price of 0

The NOT operator negates the condition, so this query returns products where the price is not less than 20, meaning price is greater than or equal to 20.

Q16

Single Choice

In PostgreSQL, which operator can be used to negate a condition in a SQL query?

AND OR NOTXOR

The NOT operator is used to negate a condition, reversing its logical value (true becomes false, and vice versa).

Q17

Single Choice

Analyze the following PostgreSQL query. What will it return?

SQL Code

SELECT * FROM transactions WHERE NOT (transaction_date < '2024-06-01' AND amount > 1000);

Transactions before June 1, 2024, and with an amount less than or equal to 1000 Transactions on or after June 1, 2024, or with an amount less than or equal to 1000 Transactions on or after June 1, 2024, or with an amount greater than 1000Transactions before June 1, 2024, and with an amount greater than 1000

The NOT operator negates the entire condition inside the parentheses. The query returns transactions that are either on or after June 1, 2024, or have an amount less than or equal to 1000.

Q18

Single Choice

What does the following PostgreSQL query achieve?

SQL Code

SELECT * FROM users WHERE (role = 'admin' AND active = true) OR (role = 'user' AND active = false);

All users Only active admins Active admins or inactive usersActive users or inactive admins

The query selects users who are either active and have the role 'admin' or inactive and have the role 'user'.

Q19

Single Choice

Which of the following best describes the outcome of this PostgreSQL query?

SQL Code

SELECT * FROM events WHERE (event_date < '2024-12-31' AND location = 'NYC') OR NOT (attendees > 100);

Events before December 31, 2024, in NYC or with 100 or fewer attendees Events in NYC with more than 100 attendees Events with a location other than NYC or more than 100 attendeesEvents before December 31, 2024, with any location

The OR NOT condition allows events that either happen before December 31, 2024, in NYC or events that have 100 or fewer attendees, regardless of location.

Q20

Single Choice

Consider the following PostgreSQL query. What is its purpose?

SQL Code

SELECT * FROM customers WHERE (age > 30 AND location = 'CA') OR (age <= 30 AND location != 'CA');

Customers over 30 in California or customers 30 or younger outside California Customers in California or customers outside California Customers over 30 years old or customers in CaliforniaCustomers 30 or younger in California or customers over 30 outside California

The query selects customers who are either over 30 years old and live in California or 30 years old or younger and live outside California.

Q21

Multiple Choice

Which SQL queries correctly use the AND logical operator in PostgreSQL?

SELECT * FROM employees WHERE salary > 50000 AND department = 'Sales'; SELECT * FROM employees WHERE salary > 50000 OR department = 'Sales'; SELECT * FROM employees WHERE salary > 50000 AND department == 'Sales';SELECT * FROM employees WHERE salary > 50000 AND department <> 'Sales';

The AND logical operator is used to combine multiple conditions where all conditions must be true for a row to be selected.

Q22

Multiple Choice

Which SQL queries correctly use the OR logical operator in PostgreSQL?

SELECT * FROM products WHERE category = 'Electronics' OR price < 100; SELECT * FROM products WHERE category = 'Electronics' AND price < 100; SELECT * FROM products WHERE category = 'Electronics' OR price > 100;SELECT * FROM products WHERE category <> 'Electronics' OR price > 100;

The OR logical operator is used to combine multiple conditions where at least one condition must be true for a row to be selected.

Q23

Multiple Choice

Which SQL queries correctly use the NOT logical operator in PostgreSQL?

SELECT * FROM orders WHERE NOT status = 'Completed'; SELECT * FROM orders WHERE status != 'Completed'; SELECT * FROM orders WHERE status NOT 'Completed';SELECT * FROM orders WHERE status = 'Completed';

The NOT logical operator is used to negate a condition, selecting rows where the condition is false.

Q24

Multiple Choice

Which SQL queries correctly combine AND and OR logical operators in PostgreSQL?

SELECT * FROM students WHERE grade > 75 AND attendance > 90 OR grade > 90; SELECT * FROM students WHERE (grade > 75 AND attendance > 90) OR grade > 90; SELECT * FROM students WHERE grade > 75 AND (attendance > 90 OR grade > 90);SELECT * FROM students WHERE grade > 75 OR attendance > 90 AND grade > 90;

Logical operators can be combined to form complex conditions. Use parentheses to ensure the correct order of evaluation.

Q25

Multiple Choice

Which SQL queries correctly use the AND logical operator with a subquery in PostgreSQL?

SELECT * FROM transactions WHERE amount > (SELECT AVG(amount) FROM transactions) AND account_id > 1000; SELECT * FROM transactions WHERE account_id > 1000 AND amount > (SELECT AVG(amount) FROM transactions); SELECT * FROM transactions WHERE account_id > 1000 OR amount > (SELECT AVG(amount) FROM transactions);SELECT * FROM transactions WHERE amount > (SELECT AVG(amount) FROM transactions) AND account_id > '1000';

Logical operators can be combined with subqueries to compare values with the result of an aggregated query.

Q26

Multiple Choice

Which SQL queries correctly use the OR logical operator with NULL values in PostgreSQL?

SELECT * FROM invoices WHERE total IS NULL OR total > 500; SELECT * FROM invoices WHERE total IS NULL AND total > 500; SELECT * FROM invoices WHERE total = NULL OR total > 500;SELECT * FROM invoices WHERE total IS NULL OR total > '500';

Logical operators can be used to handle NULL values by explicitly checking for NULL in combination with other conditions.

Q27

Multiple Choice

Which SQL queries correctly use logical operators to filter based on multiple conditions in PostgreSQL?

SELECT * FROM employees WHERE department = 'HR' AND salary > 60000 AND (role = 'Manager' OR salary > 80000); SELECT * FROM employees WHERE department = 'HR' AND (salary > 60000 AND role = 'Manager' OR salary > 80000); SELECT * FROM employees WHERE department = 'HR' AND salary > 60000 OR role = 'Manager' OR salary > 80000;SELECT * FROM employees WHERE department = 'HR' AND salary > 60000 AND role = 'Manager' OR salary > 80000;

Combining AND and OR operators requires careful use of parentheses to ensure the correct logic is applied.

Q28

Multiple Choice

Which SQL queries correctly combine NOT and AND logical operators in PostgreSQL?

SELECT * FROM payments WHERE NOT payment_method = 'Credit Card' AND customer_id > 100; SELECT * FROM payments WHERE payment_method != 'Credit Card' AND customer_id > 100; SELECT * FROM payments WHERE NOT (payment_method = 'Credit Card') AND customer_id > 100;SELECT * FROM payments WHERE NOT payment_method = 'Credit Card' OR customer_id > 100;

The NOT operator can be combined with other logical operators to exclude specific conditions.

Q29

Multiple Choice

Which SQL queries correctly use logical operators to filter based on conditions involving dates in PostgreSQL?

SELECT * FROM events WHERE event_date < '2023-01-01' AND (location = 'New York' OR location = 'Los Angeles'); SELECT * FROM events WHERE event_date < '2023-01-01' OR (location = 'New York' AND location = 'Los Angeles'); SELECT * FROM events WHERE event_date < '2023-01-01' AND location = 'New York' OR location = 'Los Angeles';SELECT * FROM events WHERE (event_date < '2023-01-01' AND location = 'New York') OR location = 'Los Angeles';

Logical operators can be used to combine conditions that involve date comparisons and other criteria.

Q30

Multiple Choice

Which SQL queries correctly combine logical operators to filter based on multiple subqueries in PostgreSQL?

SELECT * FROM reviews WHERE rating > (SELECT AVG(rating) FROM reviews) AND product_id IN (SELECT product_id FROM top_selling_products); SELECT * FROM reviews WHERE product_id IN (SELECT product_id FROM top_selling_products) AND rating > (SELECT AVG(rating) FROM reviews); SELECT * FROM reviews WHERE rating > (SELECT AVG(rating) FROM reviews) OR product_id IN (SELECT product_id FROM top_selling_products);SELECT * FROM reviews WHERE rating > (SELECT AVG(rating) FROM reviews) AND product_id = (SELECT product_id FROM top_selling_products);

Logical operators can be used to combine the results of multiple subqueries with other conditions.

PostgreSQL Database Quiz Questions