Which query will return the total salary for each department, only for departments having total salary > 50000?

SELECT department_id, SUM(salary) FROM employees GROUP BY department_id HAVING SUM(salary) > 50000;

SELECT department_id, SUM(salary) FROM employees WHERE SUM(salary) > 50000 GROUP BY department_id;

SELECT department_id, salary FROM employees HAVING SUM(salary) > 50000;

SELECT department_id, SUM(salary) FROM employees WHERE salary > 50000 GROUP BY department_id;

Which query correctly counts the number of distinct job titles in employees table?

SELECT COUNT(DISTINCT job_title) FROM employees;

SELECT COUNT(job_title) FROM employees;

SELECT DISTINCT COUNT(job_title) FROM employees;

SELECT job_title COUNT(DISTINCT) FROM employees;

Given tables employees(emp_id, dept_id) and departments(dept_id, dept_name), which query retrieves all employee id's and their department names, showing NULL if no dept_id exists?

SELECT e.emp_name, d.dept_name FROM employees e LEFT JOIN departments d ON e.dept_id = d.dept_id;

SELECT e.emp_name, d.dept_name FROM employees e INNER JOIN departments d ON e.dept_id = d.dept_id;

SELECT e.emp_name, d.dept_name FROM employees e RIGHT JOIN departments d ON e.dept_id = d.dept_id;

SELECT e.emp_name, d.dept_name FROM employees e FULL JOIN departments d ON e.dept_id = d.dept_id;

Which query finds employees whose salary is greater than the average salary?

SELECT emp_name FROM employees WHERE salary > (SELECT AVG(salary) FROM employees);

SELECT emp_name FROM employees WHERE salary > AVG(salary);

SELECT emp_name FROM employees HAVING salary > (SELECT AVG(salary) FROM employees);

SELECT emp_name FROM employees WHERE salary IN (SELECT AVG(salary) FROM employees);

Which CTE syntax is correct?

WITH cte AS ( SELECT * FROM employees ) SELECT * FROM cte;

CREATE TEMP TABLE cte AS ( SELECT * FROM employees );

WITH cte SELECT * FROM employees;

TEMP WITH cte AS ( SELECT * FROM employees ) SELECT * FROM cte;

Which of the following are valid uses of subqueries? (select all that applies)

As a constraint in CREATE TABLE

Given scenario: "Find departments that have more than 3 employees." Which query is correct?

SELECT dept_id FROM employees GROUP BY dept_id HAVING COUNT(*) > 3;

SELECT dept_id FROM employees WHERE COUNT(*) > 3 GROUP BY dept_id;

SELECT dept_id FROM employees HAVING COUNT(*) > 3;

SELECT dept_id, COUNT(*) FROM employees GROUP BY dept_id WHERE COUNT(*) > 3;

Find what is wrong in the below query: (Select all that applies) SELECT emp_name, COUNT(*) FROM employees;

COUNT( ) cannot be used without GROUP BY

Aggregates require GROUP BY if selecting other columns

Which query retrieves the number of employees in each department sorted by count descending?

SELECT dept_id, COUNT(*) FROM employees GROUP BY dept_id ORDER BY COUNT(*);

SELECT dept_id, COUNT(*) FROM employees ORDER BY COUNT(*) DESC GROUP BY dept_id;

Which query will result in a syntax error?

SELECT emp_name WHERE salary > 3000 FROM employees;

SELECT emp_name FROM employees WHERE salary BETWEEN 3000 AND 5000;

SELECT emp_name FROM employees WHERE salary NOT BETWEEN 3000 AND 5000;

SELECT * FROM employees WHERE salary IS NULL;

Which statement is true about DISTINCT?

DISTINCT removes duplicate rows based on selected columns

DISTINCT can be used only with numeric columns

DISTINCT always requires GROUP BY

Scenario: "Get employee names who work in departments located in 'New York'." Which query is correct?

SELECT e.emp_name FROM employees e JOIN departments d ON e.dept_id = d.dept_id WHERE d.location = 'New York';

SELECT e.emp_name FROM employees e, departments d WHERE e.dept_id = d.dept_id AND d.location = 'New York';

Scenario: "Find employees whose salary is greater than the highest salary in department 10." Which query is correct?

SELECT emp_name FROM employees WHERE salary > (SELECT MAX(salary) FROM employees WHERE dept_id = 10);

SELECT emp_name FROM employees WHERE salary > MAX(salary) FROM employees WHERE dept_id = 10;

Given scenario: "List the employee name and department name for employees whose department budget is greater than 1,000,000." Which query is correct?

SELECT e.emp_name, d.dept_name FROM employees e JOIN departments d ON e.dept_id = d.dept_id WHERE d.budget > 1000000;

SELECT emp_name, dept_name FROM employees e INNER JOIN departments d WHERE e.dept_id = d.dept_id AND budget > 1000000;

Which of the following statements about TRUNCATE are true?

It removes all rows from a table

It can be rolled back if used inside a transaction (in most RDBMS)

It fires DELETE triggers for each row removed

In SQL, the HAVING clause is evaluated:

After GROUP BY but before ORDER BY

After WHERE but before GROUP BY

Which query will return the second highest salary from the employees table?

SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);

SELECT TOP 2 salary FROM employees ORDER BY salary DESC;

SELECT salary FROM employees ORDER BY salary DESC OFFSET 1

SQL Quiz-3

Quiz

•

Professional Development

•

Professional Development

•

Practice Problem

•

Medium

Data_Analyst_Harish undefined

Used 2+ times

FREE Resource

30 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a DDL command?

UPDATE

CREATE

DELETE

SELECT

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which command is used to remove all rows from a table but keep its structure?

TRUNCATE TABLE

CLEAR TABLE

DROP TABLE

DELETE FROM

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

DQL commands are primarily used to:

retrieve data from a database

create new tables in a database

update data in a database

delete data from a database

4.

MULTIPLE SELECT QUESTION

30 sec • 2 pts

Identify the DML commands from the list below. (Multiple correct)

UPDATE

CREATE

DELETE

ALTER

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What will the following query do?
ALTER TABLE employees ADD COLUMN department_id INT;

Add a new row to employees table

Add a new column to students table

Add a new column to employees table

Create a new table

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which query correctly retrieves unique department names from the departments table?

SELECT department_name FROM departments;

SELECT UNIQUE department_name FROM departments;

SELECT DISTINCT department_name FROM departments;

SELECT department_name DISTINCT FROM departments;

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following functions is NOT an aggregation function?

SUM()

COUNT()

MAX()

ROUND()

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

25 questions

COMMUNICATION U6 OPA3

Quiz

•

Professional Development

25 questions

IM post-exam

Quiz

•

Professional Development

25 questions

Export Assistant Knowledge

Quiz

•

Professional Development

25 questions

FAFD2

Quiz

•

Professional Development

25 questions

CompTIA Security+ Quiz

Quiz

•

Professional Development

25 questions

Environmental L3 8202

Quiz

•

Professional Development

25 questions

Employability Skills YR1 456-480

Quiz

•

Professional Development

25 questions

POST TEST- Platihan Kumer 2024

Quiz

•

Professional Development

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Professional Development

10 questions

How to Email your Teacher

Quiz

•

Professional Development

SQL Quiz-3

30 questions

Which of the following is a DDL command?

Which command is used to remove all rows from a table but keep its structure?

DQL commands are primarily used to:

Identify the DML commands from the list below. (Multiple correct)

What will the following query do?ALTER TABLE employees ADD COLUMN department_id INT;

Which query correctly retrieves unique department names from the departments table?

Which of the following functions is NOT an aggregation function?

Which clause is used to filter aggregated results in SQL?

Which query will return the total salary for each department, only for departments having total salary > 50000?

Which query correctly counts the number of distinct job titles in employees table?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Professional Development

What will the following query do?
ALTER TABLE employees ADD COLUMN department_id INT;