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

Authored by Vikas Bandaru

Computers

10th Grade

Used 8+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

39 questions

Show all answers

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

Computer Science Pre-Assessment Quiz

Quiz

•

9th - 12th Grade

40 questions

CodeHS Web Design - HTML - Mid-Unit Test

Quiz

•

9th - 12th Grade

42 questions

App inventor

Quiz

•

7th Grade - University

38 questions

Computer Hardware Basics+

Quiz

•

7th - 12th Grade

40 questions

Introduction to Microsoft Word

Quiz

•

8th - 12th Grade

39 questions

adobe photoshop 2015 certification quiz 1

Quiz

•

9th - 12th Grade

36 questions

Engineering Careers

Quiz

•

9th - 12th Grade

39 questions

WJEC 1.1.2 Input/Output Devices

Quiz

•

9th - 10th Grade

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 Computers

15 questions

Pi Day Trivia

Quiz

•

9th - 12th Grade

10 questions

Understanding Pi and Its Applications

Interactive video

•

7th - 12th Grade

10 questions

Cell Organelles and Their Functions

Interactive video

•

6th - 10th Grade

5 questions

Did You Know? Ireland

Interactive video

•

9th - 10th Grade

10 questions

Exploring Basic Probability Concepts

Interactive video

•

6th - 10th Grade

20 questions

Figurative Language Review

Quiz

•

10th Grade

15 questions

Pi Day Trivia

Quiz

•

10th Grade

10 questions

Exploring the Layers of the Earth

Interactive video

•

6th - 10th Grade

SQL & JDBC Test

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