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

Professional Development

•

30 Qs

Similar activities

QUALITY INSPECTOR - PROCESS

Professional Development

•

25 Qs

Analyzing Data with Power BI

Professional Development

•

25 Qs

Baroda Gyani 24

Professional Development

•

25 Qs

TEST UOKE Nov 2023

Professional Development

•

25 Qs

Training Quiz AU480 A

Professional Development

•

31 Qs

Staffing V Questions only

Professional Development

•

25 Qs

NNTA, Jhapa Quiz program.Designed by Drona Stha

Professional Development

•

25 Qs

Cone of Experience & TPACK Model

University - Professional Development

•

25 Qs

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

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()

Create a free account and access millions of resources

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

World Teachers' Day Quiz

Quiz

•

Professional Development

25 questions

STP Quiz 2024

Quiz

•

Professional Development

25 questions

Le reti di computer 1

Quiz

•

Professional Development

25 questions

AUT203 Drivetrains Week 7 Quiz

Quiz

•

Professional Development

25 questions

AUT203 Drivetrains Week 5 Quiz Differentials

Quiz

•

Professional Development

25 questions

CN-First Test

Quiz

•

Professional Development

25 questions

PSMS Rejuvenate Challenge - Batch 1

Quiz

•

Professional Development

25 questions

Quiz 1 - ITEDEV - Final

Quiz

•

Professional Development

Popular Resources on Wayground

5 questions

This is not a...winter edition (Drawing game)

Quiz

•

1st - 5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

10 questions

Identify Iconic Christmas Movie Scenes

Interactive video

•

6th - 10th Grade

20 questions

Christmas Trivia

Quiz

•

6th - 8th Grade

18 questions

Kids Christmas Trivia

Quiz

•

KG - 5th Grade

11 questions

How well do you know your Christmas Characters?

Lesson

•

3rd Grade

14 questions

Christmas Trivia

Quiz

•

5th Grade

20 questions

How the Grinch Stole Christmas

Quiz

•

5th Grade

Discover more resources for Professional Development

15 questions

Fun Holiday Trivia

Quiz

•

Professional Development

20 questions

Christmas Trivia

Quiz

•

Professional Development

21 questions

Name that Holiday Movie

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?

Create a free account and access millions of resources

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;