12th Grade SQL & Querying Quizzes , Questions & Answers

Recent SQL & Querying Quizzes

This quiz tests knowledge on SQL functions like SUBSTR, UPPER, INITCAP, INSTR, TRIM, and TRANSLATE, focusing on syntax and usage.

Questions: 51 | Attempts: 82 | Last updated: Mar 21, 2025

Sample Question
SELECT SUBSTR(“Azure Skies”,-5, 5)FROM DUAL;What would be returned?

An error message.

Azure

Skies

Nothing

MySQL Online Aptitude Test 1

The test contains 15 questions and there is no time limit.The test is not official, it's just a nice way to see how much you know, or don't know, about SQL.Count Your ScoreYou will get 1 point for each correct answer. At...

Questions: 15 | Attempts: 2505 | Last updated: Mar 21, 2025

Sample Question
What does SQL stands for?

Structure query language

Strong question language

Structured question language

Separate query language

Sql MCQ Exam: Trivia Quiz!

Dive into the SQL MCQ Exam: Trivia Quiz! Designed to test and enhance your SQL skills, this quiz covers essential operations like SELECT, UPDATE, and INSERT. Ideal for learners aiming to master database management through...

Questions: 25 | Attempts: 1974 | Last updated: Mar 22, 2025

Sample Question
Which of the following statements contains an error?

SELECT * FROM emp WHERE empid = 493945;

SELECT empid FROM emp WHERE empid= 493945;

SELECT empid FROM emp;

SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’;

SQL Quiz No. 1

Engage with SQL Quiz No. 1 to test and enhance your knowledge on SQL basics, including data types, keys, and essential SQL statements.

Questions: 15 | Attempts: 125 | Last updated: Jun 22, 2025

Sample Question
It is the horizontal row of a cell

Record

Data

Database

Field

Bluekey Technical Test Level 2

The BLUEKEY TECHNICAL TEST LEVEL 2 assesses knowledge in SQL database operations. It covers adding and removing rows, using WHERE clauses, understanding views, and utilizing wildcards in queries. This quiz is essential for...

Questions: 30 | Attempts: 152 | Last updated: Mar 14, 2025

Sample Question
You can add a row using SQL in a database with which of the following?

ADD

INSERT

CREATE

MAKE

Basic SQL Quiz By - M Khan

Basic SQL Quiz By - M Khan assesses understanding of SQL syntax and operations. It covers topics like sorting, aliasing, query syntax, precedence rules, and wildcard usage, essential for database management skills.

Questions: 5 | Attempts: 202 | Last updated: Mar 21, 2025

Sample Question
Sorts are Alphabetical in SQL, not Logical.

True

False

Tsql Database - Quiz -5

TSQL Database - Quiz -5 assesses knowledge on SQL operations, trigger creation, and table manipulations. It challenges users to understand execution orders, result sets, and the behavior of SQL commands in a TSQL environment,...

Questions: 10 | Attempts: 81 | Last updated: Oct 6, 2025

Sample Question
Out of 4 statements namely 1,2,3,4,5, which of the statement/statements will execute successfully? if object_id('test2') is not null drop table test2 if object_id('test1') is not null drop table test1 create table test1 (a int not null primary key); create table test2 (b int,a int ) GO --statement 1 insert into test1 output inserted.a select 1 GO --statement 2 create trigger trig_test1 on test1 after insert as select 2 GO --statement 3 insert into test1 select 3 GO --statement 4 insert into test1 output inserted.a select 4 GO --statement 5 declare @temp as table (b int) insert into test1 output inserted.a into @temp select 5 select * from @temp GO

1

2

3

4

5

SQL Server T-SQL Quiz-i

If you are a computer nerd that is really into programming then this quiz is specifically for you. It aims to find out how much knowledge you have on the SQL server T-SQL. All the best.

Questions: 10 | Attempts: 2779 | Last updated: Apr 22, 2025

Sample Question
What does the select statement return? Create Table #T ( N1 Real , N2 Float); Insert Into #T Values (99.99999999991 , 99.99999999997); Select * From #T; Drop Table #T;

The select statement returns < 100 for N1 and 100 for N2

The select statement returns 100 for N1 and < 100 for N2

The select statement returns < 100 for both columns

The select statement returns 100 for both columns

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: 19900 | 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'

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: 13033 | 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()

« Previous 123 4 5 Next »