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

Authored by Data_Analyst_Harish undefined

Professional Development

Used 2+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

30 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a DDL command?

UPDATE

CREATE

DELETE

SELECT

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

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

MULTIPLE SELECT QUESTION

30 sec • 2 pts

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

UPDATE

CREATE

DELETE

ALTER

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

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;

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

Excel and Power BI Skills

Quiz

•

Professional Development

25 questions

HNI Quiz 1

Quiz

•

3rd Grade - Professio...

25 questions

AUT108 Week 3 Quiz Gasoline Fuel Systems

Quiz

•

Professional Development

25 questions

S | M03 Pre-exam

Quiz

•

Professional Development

25 questions

Pre-Test Training Dec.2021

Quiz

•

KG - Professional Dev...

25 questions

Job Qualifications

Quiz

•

8th Grade - Professio...

25 questions

Final Week Day 1

Quiz

•

Professional Development

25 questions

SMARTSHEET QUIZ

Quiz

•

Professional Development

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

14 questions

Boundaries & Healthy Relationships

Lesson

•

6th - 8th Grade

13 questions

SMS Cafeteria Expectations Quiz

Quiz

•

6th - 8th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

12 questions

SMS Restroom Expectations Quiz

Quiz

•

6th - 8th Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

10 questions

Pi Day Trivia!

Quiz

•

6th - 9th Grade

Discover more resources for Professional Development

20 questions

90s Cartoons

Quiz

•

Professional Development

5 questions

Workplace Documents Practice Test: Document 1

Quiz

•

Professional Development

5 questions

Workplace Documents Practice Test: Document 2

Quiz

•

Professional Development

10 questions

March Quiz

Quiz

•

Professional Development

5 questions

Copy of G5_U6_L8_22-23

Lesson

•

KG - Professional Dev...

SQL Quiz-3

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;