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 Microsoft

or continue with

Facebook

Apple

Others

Already have an account?

Similar Resources on Wayground

35 questions

Computer Parts and Accessories

Quiz

•

7th Grade - Professio...

37 questions

AQA Computer Science GCSE - 3.3 Data representation

Quiz

•

10th - 12th Grade

40 questions

UNIT 2.3 ROBUST PROGRAMS

Quiz

•

10th Grade

44 questions

AP Computer Science Principles Units 1, 2 & 3

Quiz

•

10th - 12th Grade

40 questions

2nd Grade Roman Numerals

Quiz

•

2nd Grade - University

34 questions

OCR GCSE 1.5 Systems Software MCQs

Quiz

•

8th - 10th Grade

43 questions

Digital literacy quiz

Quiz

•

10th Grade

39 questions

Computer Science 1.2

Quiz

•

10th Grade

Popular Resources on Wayground

5 questions

A Home on the Shore

Quiz

•

3rd Grade

28 questions

US History Regents Review

Quiz

•

11th Grade

6 questions

A Horse Tale

Quiz

•

3rd Grade

20 questions

Math Review

Quiz

•

3rd Grade

10 questions

Juneteenth History and Significance

Interactive video

•

5th - 8th Grade

20 questions

Dividing Fractions

Quiz

•

5th Grade

55 questions

A Long Walk to Water Final Review

Quiz

•

6th - 8th Grade

10 questions

Equation Word Problems

Quiz

•

7th Grade

Discover more resources for Computers

20 questions

Insurance

Quiz

•

9th - 12th Grade

10 questions

Juneteenth: History and Significance

Interactive video

•

7th - 12th Grade

6 questions

Mayan Mathematics part 1

Presentation

•

9th - 12th Grade

40 questions

Flags of the World

Quiz

•

KG - Professional Dev...

10 questions

Unit 9 Quiz

Quiz

•

9th - 12th 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