TutorialsHub
Ctrl+K
Home Tutorials Quizzes Quiz Tools 21+
Support TutorialsHub
Support TutorialsHub
Need Assistance?

support@tutorialshub.in

INTERMEDIATE PRACTICE TEST

SQL Queries & Relational DB Test

Practice query logic covering SELECT clauses, multi-table JOINs, GROUP BY aggregation, subqueries, and keys.

4 Questions 12 Minutes Instant Scoring All Quizzes
Question 1 of 4
00:00

1. Which SQL clause is used to filter records resulting from a GROUP BY aggregation? 

SELECT dept, COUNT(*) FROM emp GROUP BY dept ________ COUNT(*) > 5;

2. Which type of JOIN returns all records from the left table and matching records from the right table?

3. Which aggregate function calculates the total sum of a numeric column in SQL? 

SELECT _______(salary) FROM employees;

4. Which constraint uniquely identifies each record in a database table and cannot contain NULL values?

0% 0 / 0

Quiz Completed!

Here is your detailed performance breakdown.

Retake Quiz Learn SQL

Detailed Question Review