A Java API for connecting and executing SQL statements on a database

What is the purpose of the HAVING clause in a SQL query?

It filters the results of a GROUP BY clause based on a specified condition

It filters the data based on a specified condition

It sorts the data in ascending order

It sorts the data in descending order

Given the following query, what will be the result? SELECT empno, ename, sal FROM emp WHERE sal > 3000 ORDER BY sal DESC;

Returns the employee number, name, and salary of all employees with a salary greater than 3000, sorted by salary in descending order.

Returns the employee number, name, and salary of all employees in the emp table.

Returns the employee number, name, and salary of all employees with a salary less than or equal to 3000.

Returns the employee number, name, and salary of all employees with a salary greater than or equal to 3000.

Given the following query, what will be the result? SELECT COUNT(DISTINCT deptno) FROM emp;

Returns the number of distinct department numbers in the emp table.

Returns the number of departments in the emp table.

Returns the number of employees in each department.

Returns the number of distinct employee names in the emp table.

Given the following query, what will be the result? SELECT ename, sal FROM emp WHERE deptno = 10 AND sal > 2000;

Returns the employee name and salary for all employees in department 10 with a salary greater than 2000.

Returns the employee name and salary for all employees in department 10 with a salary greater than or equal to 2000

Returns the employee name and salary for all employees in department 20 with a salary greater than 2000.

Returns the employee name and salary for all employees in department 10 with a salary less than or equal to 2000.

Given the following query, what will be the result? SELECT AVG(sal) FROM emp WHERE deptno = 20;

Returns the average salary for all employees in department 20.

Returns the average salary for all employees in department 10.

Returns the sum of salaries for all employees in department 20.

Returns the average salary for all employees in department 20, rounded to the nearest whole number.

Given the following query, what will be the result? SELECT ename, sal, job FROM emp WHERE job LIKE '%MAN%';

Returns the employee name, salary, and job title for all employees whose job title contains the string "MAN".

Returns the employee name, salary, and job title for all employees whose job title contains the word "MAN".

Returns the employee name, salary, and job title for all employees whose job title starts with the letters "MAN".

Returns the employee name, salary, and job title for all employees whose job title ends with the

Given the following query, what is the result? SELECT COUNT(*) FROM employees WHERE salary > 50000;

Total number of employees with salary > 50000

Total salary of employees with salary > 50000

Given the following query, what is the result? SELECT MAX(salary) FROM employees WHERE department_id = 10;

Maximum salary of employees in department 10 only

Maximum salary of employees in department 10

Given the following query, what is the result? SELECT AVG(salary) FROM employees WHERE department_id IN (20, 30);

Average salary of employees in departments 20 and 30

Average salary of employees not in departments 20 and 30

Given the following query, what is the result? SELECT department_id, COUNT(*) FROM employees GROUP BY department_id;

Total number of employees in each department_id

Total number of employees in each department

Total number of departments with employees

Given the following query, what is the result? SELECT salary, COUNT() FROM employees GROUP BY salary HAVING COUNT() > 1;

List of salaries with more than one employee and the count of employees with that salary

List of salaries with more than one employee

List of employees with more than one salary

Given the following query, what is the result? SELECT first_name, last_name FROM employees WHERE last_name LIKE '%son';

List of employees with last name containing 'son'

List of employees with last name ending in 'son'

List of employees with last name starting with 'son'

Given the following query, what is the result? SELECT department_id, AVG(salary) FROM employees WHERE job_id LIKE 'SA%' GROUP BY department_id;

Average salary of employees with job_id starting with 'SA' in each department

Average salary of employees with job_id starting with 'SA'

Average salary of employees in departments with job_id starting with 'SA'

Given the following query, what is the result? SELECT first_name, last_name FROM employees ORDER BY last_name DESC, first_name ASC;

List of employees sorted by last name descending and first name ascending

List of employees sorted by first name ascending and last name descending

List of employees sorted by first name descending and last name ascending

Given the following query, what is the result? SELECT department_name, MAX(salary) FROM employees JOIN departments ON employees.department_id = departments.department_id GROUP BY department_name;

Maximum salary of employees in each department with department name

Maximum salary of employees in each department

List of employees with maximum salary in each department

SQL & JDBC Test

Quiz

•

Computers

•

10th Grade

•

Practice Problem

•

Hard

Vikas Bandaru

Used 8+ times

FREE Resource

39 questions

Show all answers

1.

OPEN ENDED QUESTION

INSERT

UPDATE

DELETE

SELECT

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

40 questions

Linux2 - Lesson 6 (exam training)

Quiz

•

1st - 10th Grade

35 questions

Eduqas ICT - Mr Schofield

Quiz

•

9th - 12th Grade

35 questions

PLTW CSE Unit 1.3 Review

Quiz

•

9th - 12th Grade

38 questions

2.1 Basic Concept of Network, 2.2 Network Architecture

Quiz

•

10th Grade

40 questions

Computer Hardware, Software & Peripherals

Quiz

•

9th - 12th Grade

36 questions

CompTIA Fundamentals Topic 1

Quiz

•

10th - 12th Grade

42 questions

Photoshop Tool Bar Scavenger Hunt

Quiz

•

9th - 12th Grade

40 questions

GCSE (9–1) CS 1.3 Networks, connections & protocols

Quiz

•

9th - 11th Grade

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 Computers

18 questions

[AP CSP] JavaScript Programming Lesson 2025-2026

Lesson

•

9th - 12th Grade

10 questions

Exploring Digital Citizenship Essentials

Interactive video

•

6th - 10th Grade

SQL & JDBC Test

39 questions

Full Name

What does SQL stand for?

Which of the following is used to retrieve data from a SQL database?

Which of the following is a join that returns only the rows that have matching values in both tables?

Which of the following is a join that returns all the rows from the left table and matching rows from the right table?

Which of the following is used to calculate the average value of a numeric column in SQL?

Which of the following is used to add new rows to a SQL table?

What is JDBC?

Which of the following is used to establish a connection to a database using JDBC?

Which SQL keyword is used to retrieve only distinct records from a table?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers