SQL Joins Test - 2

What will be the result of the following SQL query: SELECT COUNT(*) FROM customers;

• The number of columns in the customers table will be returned.
• The sum of all values in the customers table will be returned.
• The total number of rows in the customers table will be returned.
• The total number of columns and rows in the customers table will be returned.

Which keyword is used to sort the result set in descending order in SQL?

• SORT
• ASC
• DESC
• ORDER BY DESC

What is the result of the following SQL query: SELECT AVG(price) FROM products;

• The average of the price column from the products table will be returned.
• The total price of all products in the products table will be returned.
• The maximum price of all products in the products table will be returned.
• The minimum price of all products in the products table will be returned.

What is the difference between the UNION and UNION ALL operators in SQL?

• The UNION operator removes duplicate rows, while UNION ALL does not.
• The UNION operator combines only rows that have matching columns, while UNION ALL combines all rows.
• The UNION operator is used to combine columns from different tables, while UNION ALL is used to combine rows from different tables.
• There is no difference between the UNION and UNION ALL operators.

What will be the result of the following SQL query: SELECT * FROM customers WHERE age BETWEEN 18 AND 25;

• All rows from the customers table where age is less than 18 or greater than 25 will be returned.
• All rows from the customers table where age is between 18 and 25 (inclusive) will be returned.
• All rows from the customers table where age is greater than 18 and less than 25 will be returned.
• All rows from the customers table where age is not between 18 and 25 will be returned.

Which keyword is used to specify a condition in a SQL query?

• SELECT
• FROM
• WHERE
• WHERE is used to specify a condition in a SQL query.

What will be the result of the following SQL query: SELECT DISTINCT city FROM customers;

• All unique cities from the customers table will be returned.
• All rows from the customers table where city is not null will be returned.
• All rows from the customers table where city is null will be returned.
• All rows from the customers table where city is not unique will be returned.

What is the result of the following SQL query: SELECT MAX(price) FROM products;

• The average price of all products in the products table will be returned.
• The total price of all products in the products table will be returned.
• The minimum price of all products in the products table will be returned.
• The maximum price of all products in the products table will be returned.

What will be the result of the following SQL query: SELECT * FROM customers WHERE city = 'New York' AND age > 30;

• All rows from the customers table where city is not 'New York' and age is less than or equal to 30 will be returned.
• All rows from the customers table where city is 'New York' and age is less than or equal to 30 will be returned.
• All rows from the customers table where city is not 'New York' and age is greater than 30 will be returned.
• All rows from the customers table where city is 'New York' and age is greater than 30 will be returned.

Which SQL function is used to return the highest value from a specified column?

• MIN()
• AVG()
• SUM()
• MAX()