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

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

35 questions

CodeHS - Web Design Test on HTML & CSS

Quiz

•

9th - 12th Grade

40 questions

EE.09 Próbny - bazy danych

Quiz

•

10th Grade

35 questions

Cerca amb Google

Quiz

•

7th - 12th Grade

42 questions

How the Internet Works

Quiz

•

9th - 12th Grade

40 questions

Types and Components of computer systems.

Quiz

•

9th - 12th Grade

35 questions

IGCSE ICT Chapter 4

Quiz

•

9th - 12th Grade

35 questions

Microsoft Word

Quiz

•

6th - 12th Grade

40 questions

Introduction to Computers

Quiz

•

9th - 12th Grade

Popular Resources on Wayground

5 questions

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

Quiz

•

1st - 5th Grade

15 questions

4:3 Model Multiplication of Decimals by Whole Numbers

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

10 questions

The Best Christmas Pageant Ever Chapters 1 & 2

Quiz

•

4th Grade

12 questions

Unit 4 Review Day

Quiz

•

3rd 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

Discover more resources for Computers

47 questions

CSF Final Exam Practice

Quiz

•

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

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers