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

10th Grade

•

39 Qs

Similar activities

DD - U1 - Intro to Web and Digital Design

10th - 12th Grade

•

40 Qs

T4 ANIMASI 2D XI DKV

9th - 12th Grade

•

40 Qs

Programming Concepts Quiz

9th - 12th Grade

•

35 Qs

AP Computer Science Principles Units 1, 2 & 3

10th - 12th Grade

•

44 Qs

OCR GCSE 1.5 Systems Software MCQs

8th - 10th Grade

•

34 Qs

Year 9 final test revision 2024

9th - 12th Grade

•

35 Qs

Web Dev MasterClass Day1

6th Grade - Professional Development

•

34 Qs

AutoCAD Final Exam

9th - 12th Grade

•

40 Qs

SQL & JDBC Test

Quiz

•

Computers

•

10th Grade

•

Practice Problem

•

Hard

Vikas Bandaru

Used 8+ times

FREE Resource

39 questions

Show all answers

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?

Similar Resources on Wayground

41 questions

Test próbny EE.09 (Bazy danych)

Quiz

•

9th - 12th Grade

42 questions

GENERAL INTERNET TERMS

Quiz

•

9th - 11th Grade

35 questions

DATABASE QUIZ

Quiz

•

9th - 12th Grade

39 questions

Domain 1.0 (DD1)

Quiz

•

9th - 12th Grade

34 questions

Class X Open Office Writer

Quiz

•

10th Grade

34 questions

CB30: Unit 2 Test Review

Quiz

•

9th - 12th Grade

38 questions

1.1 Architecture of CPU

Quiz

•

9th - 12th Grade

35 questions

Paper 2 - Document Production, Data Manipulation & Presentations

Quiz

•

10th - 11th Grade

Popular Resources on Wayground

10 questions

Honoring the Significance of Veterans Day

Interactive video

•

6th - 10th Grade

9 questions

FOREST Community of Caring

Lesson

•

1st - 5th Grade

10 questions

Exploring Veterans Day: Facts and Celebrations for Kids

Interactive video

•

6th - 10th Grade

19 questions

Veterans Day

Quiz

•

5th Grade

14 questions

General Technology Use Quiz

Quiz

•

8th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

15 questions

Circuits, Light Energy, and Forces

Quiz

•

5th Grade

19 questions

Thanksgiving Trivia

Quiz

•

6th Grade

Discover more resources for Computers

10 questions

Exploring Computer Science Careers and Subfields

Interactive video

•

6th - 10th Grade

15 questions

AP CSP Unit 4

Quiz

•

10th - 12th Grade

23 questions

Prog 1 Python Q1 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