Which query is correct to get the first 10 records from a table employees sorted by salary in descending order?

SELECT * FROM employees ORDER BY salary DESC LIMIT 10;

SELECT * FROM employees LIMIT 10 ORDER BY salary DESC;

SELECT TOP 10 * FROM employees ORDER BY salary DESC;

SELECT * FROM employees WHERE salary > 1000 LIMIT 10;

How would you modify a column salary in the employees table to allow NULL values?

ALTER TABLE employees MODIFY salary INT NULL;

ALTER TABLE employees CHANGE salary salary INT NULL;

ALTER TABLE employees MODIFY salary SET NULL;

ALTER TABLE employees ALTER salary SET NULL;

Which of the following queries will return the total salary per department, excluding departments with no employees?

SELECT department_id, SUM(salary) FROM employees GROUP BY department_id HAVING COUNT(employee_id) > 0;

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

SELECT department_id, SUM(salary) FROM employees GROUP BY department_id HAVING COUNT(*) > 0;

SELECT department_id, SUM(salary) FROM employees WHERE department_id IS NOT NULL GROUP BY department_id;

Which query retrieves all employees whose names start with the letter "J" and ends with "n"?

SELECT * FROM employees WHERE name LIKE 'J%n';

SELECT * FROM employees WHERE name LIKE 'J?n';

SELECT * FROM employees WHERE name LIKE '%Jn%';

SELECT * FROM employees WHERE name LIKE 'J_n';

Which query will return the employees who do not have a manager?

SELECT * FROM employees WHERE manager_id IS NULL;

SELECT * FROM employees WHERE manager_id = NULL;

SELECT * FROM employees WHERE manager_id IS NOT NULL;

SELECT * FROM employees WHERE manager_id = 0;

How would you retrieve all unique employee_id values from the employees table that are not null?

SELECT DISTINCT employee_id FROM employees WHERE employee_id IS NOT NULL;

SELECT employee_id FROM employees WHERE employee_id != NULL;

SELECT UNIQUE employee_id FROM employees;

SELECT employee_id FROM employees GROUP BY employee_id;

What does the following query return? SELECT ROUND(AVG(salary), 2) FROM employees;

It rounds the salary values to 2 decimal places and returns the average.

It returns the average salary rounded to the nearest integer.

It calculates the total salary and rounds the result to 2 decimal places.

It returns the sum of all salaries rounded to 2 decimal places.

Which query returns the first 5 employees in alphabetical order by name?

SELECT * FROM employees ORDER BY name ASC LIMIT 5;

SELECT * FROM employees ORDER BY name LIMIT 5;

SELECT * FROM employees ORDER BY name DESC LIMIT 5;

SELECT * FROM employees LIMIT 5 ORDER BY name ASC;

Which query will return all employees who earn more than the average salary of their respective department?

SELECT * FROM employees e WHERE salary > (SELECT AVG(salary) FROM employees WHERE department_id = e.department_id);

SELECT * FROM employees WHERE salary > AVG(salary) GROUP BY department_id;

SELECT * FROM employees WHERE salary > MAX(salary) GROUP BY department_id;

What does the HAVING clause do in a GROUP BY query?

Filters the result after grouping the rows.

Filters the result before grouping the rows.

Defines the column used for grouping.

Which query will return the employees who have never been assigned to a department?

SELECT * FROM employees WHERE department_id IS NULL;

SELECT * FROM employees WHERE department_id = NULL;

SELECT * FROM employees WHERE department_id NOT IN (SELECT department_id FROM departments);

SELECT * FROM employees WHERE department_id = 0;

Which of the following will correctly delete all rows from the employees table?

DELETE FROM employees WHERE 1=1;

Which query will return the employees who earn more than 10% of the highest salary in the company?

SELECT FROM employees WHERE salary > 0.1 (SELECT MAX(salary) FROM employees);

SELECT FROM employees WHERE salary > MAX(salary) 10;

SELECT FROM employees WHERE salary > 10 (SELECT MAX(salary) FROM employees);

What does the following query do? SELECT DISTINCT employee_id FROM employees WHERE department_id = 1;

It retrieves unique employee IDs for department 1

It retrieves all employee IDs for department 1, including duplicates.

It retrieves all department IDs for department 1

It retrieves all employees with department 1 assigned.

Which query will count the number of rows in the employees table where department_id is not NULL?

SELECT COUNT(*) FROM employees WHERE department_id IS NOT NULL;

SELECT COUNT(department_id) FROM employees;

SELECT COUNT(*) FROM employees WHERE department_id != NULL;

SELECT COUNT(department_id) FROM employees WHERE department_id IS NOT NULL;

Which of the following queries will return the total salary for each department, including departments with zero employees?

SELECT department_id, SUM(salary) FROM employees LEFT JOIN departments ON employees.department_id = departments.department_id GROUP BY department_id;

SELECT department_id, SUM(salary) FROM employees GROUP BY department_id WITH ROLLUP;

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

SELECT department_id, SUM(salary) FROM employees LEFT JOIN departments USING (department_id) GROUP BY department_id;

What is the result of the following query? SELECT * FROM employees LIMIT 10 OFFSET 5;

It returns rows 6 to 15 from the employees table.

It returns the first 5 rows from the employees table.

It returns rows 1 to 10 from the employees table.

It returns rows 5 to 15 from the employees table.

Which of the following queries can be used to update the salary of employees who belong to department 2 and are under 30 years old?

UPDATE employees SET salary = salary * 1.1 WHERE department_id = 2 AND age < 30;

UPDATE employees SET salary = salary * 1.1 WHERE department_id = 2;

UPDATE employees SET salary = salary + 500 WHERE department_id = 2 AND age < 30;

UPDATE employees SET salary = salary + 500 WHERE department_id = 2 AND age <= 30;

What is the purpose of using DISTINCT in a SELECT statement?

To retrieve unique values from a column or combination of columns.

To sort the results in ascending or descending order.

To filter out NULL values from the result set.

To group rows together based on column values.

What does the following SQL query do? SELECT * FROM employees WHERE name LIKE 'J%n';

Finds employees whose name starts with "J" and ends with "n".

Finds employees whose name starts with "J" or contains "n".

Finds employees whose name contains the letter "J" and ends with "n".

Finds employees whose name starts with "J" and contains "n".

Which query will return the department with the highest total salary expenditure?

SELECT department_id, SUM(salary) AS total_salary FROM employees GROUP BY department_id ORDER BY total_salary DESC LIMIT 1;

SELECT department_id, MAX(SUM(salary)) FROM employees GROUP BY department_id;

SELECT department_id, SUM(salary) FROM employees ORDER BY salary DESC LIMIT 1;

SELECT department_id, COUNT(salary) FROM employees GROUP BY department_id ORDER BY salary DESC LIMIT 1;

What does the following query do? SELECT COUNT(DISTINCT department_id) FROM employees;

It counts the total number of distinct department IDs.

It counts all rows in the employees table.

It counts the number of departments in the employees table.

It counts employees who belong to more than one department.

Which of the following SQL statements is used to add a new column to an existing table?

ALTER TABLE employees ADD COLUMN birthdate DATE;

INSERT COLUMN INTO employees (birthdate DATE);

CREATE COLUMN TABLE employees (birthdate DATE);

What does the following query do? SELECT employee_id, salary FROM employees WHERE salary > (SELECT AVG(salary) FROM employees WHERE department_id = 2);

It returns employees with a salary greater than the average salary of all employees in department 2.

It returns employees with a salary less than the average salary in department 2.

It returns employees with the highest salary in department 2.

It returns employees who earn the average salary in department 2.

What does the IS NULL condition do in SQL?

Checks if a column contains a NULL value.

Checks if a column contains the string "NULL".

Checks if a column contains an empty string.

Checks if a column contains the value 0.

Which of the following SQL queries can be used to update the salary of employees in department 1, adding a 10% increase for employees who have worked for more than 5 years?

UPDATE employees SET salary = salary * 1.1 WHERE department_id = 1 AND years_of_service > 5;

UPDATE employees SET salary = salary * 1.1 WHERE department_id = 1;

UPDATE employees SET salary = salary + salary * 0.1 WHERE department_id = 1 AND years_of_service > 5;

UPDATE employees SET salary = salary + 0.1 WHERE department_id = 1 AND years_of_service > 5;

What is the correct query to retrieve the first name and last name of employees who earn above the average salary in their respective departments?

SELECT first_name, last_name FROM employees e WHERE salary > (SELECT AVG(salary) FROM employees WHERE department_id = e.department_id);

SELECT first_name, last_name FROM employees WHERE salary > (SELECT AVG(salary) FROM employees);

SELECT first_name, last_name FROM employees WHERE salary > AVG(salary) GROUP BY department_id;

SELECT first_name, last_name FROM employees WHERE salary > MAX(salary) GROUP BY department_id;

Which of the following statements is true about foreign keys in MySQL?

Foreign keys can reference columns with a UNIQUE or PRIMARY key.

Foreign keys can reference columns with a non-unique index

Foreign keys cannot be defined on columns with NULL values

Foreign keys automatically create an index on the referenced column

Which of the following queries will return employees who belong to the same department as "John Doe"?

SELECT * FROM employees WHERE department_id = (SELECT department_id FROM employees WHERE first_name = 'John' AND last_name = 'Doe');

SELECT * FROM employees WHERE department_id = 'John Doe';

SELECT * FROM employees WHERE department_id = (SELECT department_id FROM employees WHERE first_name = 'John' AND last_name = 'Doe') LIMIT 5;

Which query will return the employees who have the same salary as the highest salary in the company?

SELECT * FROM employees WHERE salary = MAX(salary);

Which of the following queries will find all employees who were hired in the year 2022?

SELECT * FROM employees WHERE YEAR(hire_date) = 2022;

SELECT * FROM employees WHERE hire_date BETWEEN '2022-01-01' AND '2022-12-31';

SELECT * FROM employees WHERE hire_date LIKE '2022%';

SELECT * FROM employees WHERE hire_date = '2022';

Which query will return the department with the lowest average salary?

SELECT department_id, AVG(salary) FROM employees GROUP BY department_id ORDER BY AVG(salary) ASC LIMIT 1;

SELECT department_id, MIN(salary) FROM employees GROUP BY department_id ORDER BY MIN(salary) ASC LIMIT 1;

SELECT department_id, AVG(salary) FROM employees ORDER BY AVG(salary) DESC LIMIT 1;

SELECT department_id, MAX(salary) FROM employees GROUP BY department_id ORDER BY MAX(salary) ASC LIMIT 1;

What does the following query do? SELECT employee_id, salary FROM employees WHERE department_id = 3 ORDER BY salary LIMIT 5;

It returns all employees from department 3 with their salaries, ordered by salary, limited to 5 rows.

It returns the top 5 highest paid employees from department 3.

It returns the lowest 5 paid employees from department 3.

It returns the employees with salaries greater than 5 from department 3.

Which query will return the number of employees who earn above the average salary?

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

SELECT COUNT(*) FROM employees WHERE salary > AVG(salary);

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

Which query will return employees who have been working for more than 10 years and belong to department 2?

SELECT * FROM employees WHERE years_of_service > 10 AND department_id = 2;

SELECT * FROM employees WHERE years_of_service > 10 OR department_id = 2;

SELECT * FROM employees WHERE years_of_service > 10 AND department_id = '2';

SELECT * FROM employees WHERE years_of_service > 10 OR department_id = '2';

Which of the following SQL queries will return the first three records from the employees table ordered by salary in descending order?

SELECT * FROM employees ORDER BY salary DESC LIMIT 3;

SELECT * FROM employees LIMIT 3 ORDER BY salary;

SELECT * FROM employees LIMIT 3 ORDER BY salary DESC;

SELECT * FROM employees ORDER BY salary LIMIT 3;

Which query will return employees who do not have a manager (i.e., employees who have NULL in the manager_id column)?

SELECT * FROM employees WHERE manager_id IS NULL;

SELECT * FROM employees WHERE manager_id = NULL;

SELECT * FROM employees WHERE manager_id != NULL;

SELECT * FROM employees WHERE manager_id = 'NULL';

What is the result of the following query? SELECT AVG(salary) FROM employees WHERE salary > 50000;

It returns the average salary of employees earning more than 50,000.

It returns the average salary of all employees.

It returns the total salary of employees earning more than 50,000

It returns the highest salary among employees earning more than 50,000

Which query will return a list of departments that have more than 5 employees?

SELECT department_id FROM employees GROUP BY department_id HAVING COUNT(employee_id) > 5;

SELECT department_id FROM employees HAVING COUNT(employee_id) > 5 GROUP BY department_id;

SELECT department_id FROM employees GROUP BY department_id HAVING COUNT(*) > 5;

SELECT department_id FROM employees WHERE COUNT(employee_id) > 5 GROUP BY department_id;

Which query will return the number of distinct departments in which employees work?

SELECT COUNT(DISTINCT department_id) FROM employees;

SELECT COUNT(department_id) FROM employees;

SELECT DISTINCT COUNT(department_id) FROM employees;

SELECT DISTINCT department_id FROM employees;

Which query will remove duplicate rows from the result of a query?

SELECT DISTINCT column1, column2 FROM table;

DELETE FROM table WHERE column1 = column2;

SELECT column1, column2 FROM table WHERE DISTINCT;

SELECT UNIQUE column1, column2 FROM table;

Special DB Exam

Authored by ELLAINE CERVANTES

Computers

University

Used 1+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

75 questions

Show all answers

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which of the following is the correct MySQL command to create a database?

CREATE TABLE database_name;

CREATE DATABASE database_name;

NEW DATABASE database_name;

CREATE SCHEMA database_name;

MULTIPLE CHOICE QUESTION

20 sec • 2 pts

Which of the following queries will return employees who have a salary greater than the average salary of all employees?

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

SELECT * FROM employees WHERE salary = AVG(salary);

SELECT * FROM employees WHERE salary > (SELECT MAX(salary) FROM employees);

SELECT * FROM employees WHERE salary > 5000;

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which of the following SQL commands is used to prevent new records from being inserted into a table?

DISABLE INSERT INTO table_name;

ALTER TABLE table_name ADD DISABLE_INSERT;

LOCKS TABLES table_name WRITE;

ALTER TABLE table_name SET INSERT RESTRICT;

NO ANSWER

MULTIPLE CHOICE QUESTION

20 sec • 2 pts

What is the result of the following query?
SELECT employee_id, salary FROM employees ORDER BY salary DESC LIMIT 3 OFFSET 2;

The query will return the 3rd, 4th, and 5th highest salaries.

The query will return the top 3 highest salaries.

The query will return the 2nd, 3rd, and 4th highest salaries.

The query will return the top 2 highest salaries starting from the 3rd highest.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What does the following SQL statement do?
SELECT COUNT(*) FROM employees WHERE department_id IS NULL;

Counts the number of employees in the employees table.

Counts the number of employees with no department.

Counts the number of NULL values in the department_id column

Counts the total number of rows in the employees table.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which of the following queries will return the second highest salary from the employees table?

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

SELECT MIN(salary) FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1;

SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1;

SELECT salary FROM employees ORDER BY salary LIMIT 1 OFFSET 2;

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which statement will return the count of employees per department, including departments with zero employees?

SELECT department_id, COUNT(employee_id) FROM employees GROUP BY department_id;

SELECT d.department_id, COUNT(e.employee_id) FROM departments d LEFT JOIN employees e ON d.department_id = e.department_id GROUP BY d.department_id;

SELECT department_id, COUNT(*) FROM employees WHERE department_id IS NOT NULL GROUP BY department_id;

SELECT department_id, COUNT(*) FROM employees GROUP BY department_id WITH NULLS;

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

78 questions

ESP-re: Newcastle Office upgrade 29 September 2023 exam ESP

Quiz

•

University

76 questions

Tin 3 (2)

Quiz

•

University

77 questions

Introduction to Cloud Computing

Quiz

•

University

70 questions

i-Tech Quiz

Quiz

•

University

80 questions

TO Practice Exam 220-1001 Ver A

Quiz

•

University

75 questions

Đề 31 E3 HT 23.24

Quiz

•

University

75 questions

иновационный технология

Quiz

•

University

77 questions

Quiz on Artificial Intelligence Concepts

Quiz

•

University

Popular Resources on Wayground

8 questions

Spartan Way - Classroom Responsible

Quiz

•

9th - 12th Grade

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

14 questions

Boundaries & Healthy Relationships

Lesson

•

6th - 8th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

3 questions

Integrity and Your Health

Lesson

•

6th - 8th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

9 questions

FOREST Perception

Lesson

•

20 questions

Main Idea and Details

Quiz

•

5th Grade

Discover more resources for Computers

20 questions

Disney Trivia

Quiz

•

University

7 questions

Fragments, Run-ons, and Complete Sentences

Interactive video

•

4th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

10 questions

DNA Structure and Replication: Crash Course Biology

Interactive video

•

11th Grade - University

7 questions

Force and Motion

Interactive video

•

4th Grade - University

20 questions

Implicit vs. Explicit

Quiz

•

6th Grade - University

14 questions

Ch.3_TEACHER-led

Quiz

•

University

7 questions

Comparing Fractions

Interactive video

•

1st Grade - University

Special DB Exam

Which of the following is the correct MySQL command to create a database?

Which of the following queries will return employees who have a salary greater than the average salary of all employees?

Which of the following SQL commands is used to prevent new records from being inserted into a table?

What is the result of the following query?SELECT employee_id, salary FROM employees ORDER BY salary DESC LIMIT 3 OFFSET 2;

What does the following SQL statement do?SELECT COUNT(*) FROM employees WHERE department_id IS NULL;

Which of the following queries will return the second highest salary from the employees table?

Which statement will return the count of employees per department, including departments with zero employees?

Which query is correct to get the first 10 records from a table employees sorted by salary in descending order?

How would you modify a column salary in the employees table to allow NULL values?

Which of the following queries will return the total salary per department, excluding departments with no employees?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

What is the result of the following query?
SELECT employee_id, salary FROM employees ORDER BY salary DESC LIMIT 3 OFFSET 2;

What does the following SQL statement do?
SELECT COUNT(*) FROM employees WHERE department_id IS NULL;