Quiz will ask 20 randomly selected questions with allotted time of . You can take the quiz more than once. Once you submit the quiz, you can review how you have done, the correct the answers for each questions and the explanation for the correct the answer.
12 Modules
Which of the following SQL statements will correctly select all columns from a table named 'employees' where the 'department' is 'Sales'?
SELECT * FROM employees WHERE department = 'Sales';
SELECT ALL FROM employees WHERE department = 'Sales';
SELECT employees.* FROM employees WHERE department = 'Sales';
SELECT employees FROM employees WHERE department = 'Sales';
What will be the output of the following SQL query? SELECT COUNT(*) FROM orders WHERE order_date >= '2023-01-01';
The total number of orders placed in 2023.
The total number of orders placed before 2023.
The total number of orders placed on January 1, 2023.
The total number of orders regardless of the date.
Which SQL statement will return the unique values from the 'city' column in the 'customers' table?
SELECT DISTINCT city FROM customers;
SELECT UNIQUE city FROM customers;
SELECT city FROM customers GROUP BY city;
SELECT city FROM customers WHERE city IS NOT NULL;
In SQL, which of the following statements is true regarding the use of the ORDER BY clause?
It can only sort results in ascending order.
It can sort results by multiple columns.
It must always be used with a GROUP BY clause.
It can sort results in both ascending and descending order.
What is the result of executing the following SQL statement? SELECT product_name, SUM(quantity) FROM sales GROUP BY product_name HAVING SUM(quantity) > 100;
It returns all products with their total quantities.
It returns products with total quantities greater than 100.
It will cause an error because HAVING cannot be used without a GROUP BY.
It will return products with total quantities equal to 100.
12 Modules