SQL & Querying Quizzes, Questions & Answers

All Grades

Popular SQL & Querying Topics

Functions & Expressions (1)

Functions And Expressions Quizzes

Functions(Char,Concat,Substr etc) Date Functions Numeric Functions(Sum,Avg etc) Usage of group by and Having with aggregate functions Use of IFNull and Coalease functio...

Questions: 10 | Attempts: 1461 | Last updated: Mar 21, 2025

Sample Question
Which one of the following queries will select the Number of Unique Departments from the Department Table below Department Number Employee Number 11 248525 11 267712 12 112456 11 234567 13 661231

Select count(*) from Department_Table

Select count(distinct DepartmentNumber) from Department_Table having distinct DepartmentNumber

Select count(distinct DepartmentNumber) from Department_Table

Select distinct departmentNumber from Department_Table

All Functions And Expressions Quizzes

Top Trending SQL & Querying Quizzes

MS Access 101 Quiz

Getting some basic computer knowledge is something that most people are required to have in any business field. There are different computer applications used daily. How good are you when it comes to MS Access? Take up the quiz...

Questions: 50 | Attempts: 19535 | Last updated: Feb 19, 2025

Sample Question
Which object is used to create a form?

Tables and Queries

Tables only

Tables and reports

Queries and reports

Oracle PL/SQL Quiz

Ready to test your knowledge of Oracle PL/SQL? This quiz guides you through essential topics such as cursor operations, variable declarations, exception handling, control statements, and the integration of SQL within PL/SQL...

Questions: 29 | Attempts: 24240 | Last updated: Dec 8, 2025

Sample Question
Select incorrect variable declarations.

Foo_number varchar2(10);

Foo_text number(10);

Foo_char char(1) := 'Y';

Foo_time date;

Foo_text varchar2(10) := 'hello world';

Test Your DDL And DML Knowledge

Are you an avid coder? We have a special Oracle quiz for you! Test your DDL and DML Knowledge with this super informative, interesting quiz! We are here to challenge your knowledge! Let's see how well you perform in this...

Questions: 10 | Attempts: 4103 | Last updated: Mar 13, 2025

Sample Question
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table?

INSERT INTO employees VALUES (NULL, 'JOHN','Smith');

INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');

INSERT INTO employees VALUES ('1000','JOHN','NULL');

INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');

INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");

SQL Server Quiz Questions And Answers

Have you ever worked on an SQL server? What do you know about this database system? We have here this "SQL server quiz questions and answers" for you. Microsoft SQL Server is a DBMS developed by Microsoft for storing...

Questions: 25 | Attempts: 8275 | Last updated: Jun 22, 2025

Sample Question
Assuming UserProfile is a table containing a column Proession that accepts a NULL value. What is the result of the query below? SET ANSI_NULLS OFF SELECT Profession FROM UserProfile WHERE (Profession <> NULL).

Gives an error.

Returns all Professions that do not have null values.

<> is not an operator in SQL Server.

None of the above.

SQL & PL/SQL Fundamentals Quiz

This Oracle SQL and PL/SQL Practice Quiz for Developers is designed to strengthen your understanding of essential Oracle database concepts, query structures, constraints, DDL/DML operations, functions, privileges, and PL/SQL...

Questions: 33 | Attempts: 19492 | Last updated: Nov 21, 2025

Sample Question
Which SQL statement contains an error?

SELECT * FROM emp WHERE empid = 493945

SELECT empid FROM emp

SELECT empid FROM emp WHERE empid = 493945

SELECT empid WHERE empid = 56949 AND lastname='SMITH'

Popular SQL & Querying Quizzes

The Ultimate Server Query Language Quiz

A server query language is designed so that users can retrieve specific information from a database. As a software developer, you should have some knowledge of the use of such languages. Do you believe you understand SQL...

Questions: 42 | Attempts: 12996 | Last updated: Mar 22, 2025

Sample Question
Which SQL function is used to count the number of rows in a SQL query?

COUNT()

NUMBER()

SUM()

SQL Multiple Choice Questions With Answers

Are you looking for some SQL multiple-choice questions with answers to make your preparation level better for the upcoming exam? Try our quiz below and see if you know the basics of SQL programming language or not. SQL is the...

Questions: 20 | Attempts: 12517 | Last updated: Jun 17, 2025

Sample Question
Full form of RDBMS is

Regional district management system

Relational database management system

Regular database management system

Regular district machine system

Oracle Pl/SQL Practice Quiz: Test Yourself!

Oracle PL/SQL Practice Quiz: Test Yourself!

This advanced Oracle PL/SQL practice test is designed for developers, analysts, and database professionals who want to sharpen their SQL and PL/SQL skills. The quiz covers explicit and implicit cursors, variable declarations,...

Questions: 39 | Attempts: 10615 | Last updated: Dec 5, 2025

Sample Question
Select incorrect variable declaration

Foo_number varchar2(10)

Foo_text number(10)

Foo_char char(1) := 'Y'

Foo_time date

Recent SQL & Querying Quizzes