SQL Quizzes & Trivia

Are you our "IT" guy? That's read "I-T" by the way, short for Information Technology. If programming is your thing, then you've got to try these quizzes that we bring. Are you familiar with the special-purpose programming language, SQL? You've probably been using it, but do you know what it means? Right! It's "Structured Query Language".

So, do you think you can give "DISTINCT" answers to our quizzes? How much do you know about making queries and manipulating data? Can you enumerate some data types used in SQL? What about SQL functions? Do you know them by heart? Find out when you take on our quizzes. What are you waiting for? It's your time show off your processing power. Try our SQL quizzes now! Make sure your answers aren't NULL, OK?

Top Trending

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: 7857 | Last updated: Mar 19, 2021

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

COUNT()

NUMBER()

SUM()

Oracle Mock Test 2(SQL +arch)

Questions: 26 | Attempts: 1019 | Last updated: Jan 24, 2013

Sample Question
Which SELECT statement should you use if you want to display unique combinations of the POSITION and MANAGER values from the EMPLOYEE table?

SELECT DISTINCT position, manager FROM employee;

SELECT position, manager DISTINCT FROM employee;

SELECT position, manager FROM employee;

SELECT position, DISTINCT manager FROM employee;

Oracle Pl/SQL Quiz: Trivia Exam!

Oracle PL/SQL Quiz: Trivia Exam!

Questions: 20 | Attempts: 579 | Last updated: Nov 20, 2020

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';

Sql MCQ Exam: Trivia Quiz!

SQL MCQ Exam: Trivia Quiz!

Questions: 25 | Attempts: 141 | Last updated: Feb 2, 2021

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 Data Manipulation Language Trivia Quiz!

Welcome to the SQL data manipulation quiz. It is designed to test out just how much you understand when it comes to data manipulation, which is essentially editing, deleting, or changing the data as well as you can. It is perfect...

Questions: 20 | Attempts: 1322 | Last updated: Sep 2, 2019

Sample Question
A DML command that inserts, updates, or deletes database data

Alias

Inner join

Action query

Topics

ssrs SSRS Quizzes

mysql MySQL Quizzes

oracle Oracle Quizzes

SQL Server SQL Server Quizzes

SQL Questions & Answers

Can you state some facts about SQL?

Null values are displayed last in ascending sequences. SQL means Structured Query Language. SQL allows you to access and manipulate databases; it became the standard of the American National Standards Institute (ANSI) IN 1986 and the International O

What is the purpose of SQL AS clause?

SQL is a programming language used for data management held in a relational database management system. The SQL AS is a keyword that is employed in the ascription of a nickname or an alias to a certain table of one’s choice, which is currently

How do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a" with SQL?

The SQL LIKE clause is made use to relate value to comparable values using wildcard operators. Each time you want to look for records in a table based on certain string patterns such as the operator is the appropriate way to deal with this kind of qu

What is the difference between Left Join and Left Outer Join?

Before delving into whether there is any difference between left join and left outer join, it is important that you know what the word 'join' means as far as the SQL server is concerned. Join is a feature that helps to combine certain records of two

Recently Updated

Basic SQL Quiz For School Learners!

Basic SQL Quiz for School Learners!

This is a quiz on the SQL system. needed for learning at school

Questions: 10 | Attempts: 2793 | Last updated: Mar 2, 2019

Sample Question
When did SQL appear

1974

1922

1977

1987

Basic SQL Trivia Quiz!

This quiz is on SQL basics. SQL is not a query language that most computer geeks aspire to understand. The primary objective for SQL creation was to give the possibility to common people get interesting data from the database. If...

Questions: 20 | Attempts: 922 | Last updated: Sep 2, 2019

Sample Question
A statement that assigns a value to a variable

Comment statements

Declaration section

Assignment statement

The SQL Procedure: Trivia Quiz

There are different types of Stored Procedure in SQL server and we got to cover all of them in our previous classes. SQL is used to communicate with a database in a computer to accomplish a task. Take up the quiz below and get to...

Questions: 6 | Attempts: 713 | Last updated: Sep 2, 2019

Sample Question
A query that joins a table to itself

Outer join

Self-join

Inner join

Take This Simple SQL Trivia Quiz

SQL is an exceptional reason programming language that is used to communicate with a database, and it is perfect for someone who wants to analyze databases that have data fields. If you are studying to be a programmer, then you...

Questions: 11 | Attempts: 712 | Last updated: Sep 2, 2019

Sample Question
Allows the user to specify values for system and user parameters

Report record group

Parameter form

Parent frame

Database And SQL Trivia Quiz!

Below are a database and SQL trivia quiz. It is designed to see your capability to store data conveniently in a computer with the help of the structured query language. We know for a fact that SQL is the language used for...

Questions: 12 | Attempts: 611 | Last updated: Aug 7, 2019

Sample Question
The data model used in ABAP courses from SAP is the _______ Data Model.

ERP

NetWeaver

ABAP

Flight

SQL Table: Trivia Questions!

The trivia questions below are on the SQL table. Basically we know the definitaion and basic interpretation of SQL. However, are you sure you have what it takes to take up more than just the basics? In a bit, we are going to...

Questions: 7 | Attempts: 555 | Last updated: Jan 8, 2021

Sample Question
To make a PARAMETER mandatory, we use the OBLIGATORY option

True

False

SQL Exam: Trivia Questions! Quiz

SQL Exam: trivia questions quiz! The structured query language is designed to help a programmer manipulate databases. It helps in retrieval and editing of data from the database with ease. This computer language is one of the...

Questions: 25 | Attempts: 554 | Last updated: Sep 9, 2020

Sample Question
SQL < select name ,sal from Emp where name like m%;

True

False

SQL Test: Trivia Quiz Questions!

Questions: 20 | Attempts: 493 | Last updated: Feb 23, 2021

Sample Question
A pointer is

A keyword used to create variables

A variable that stores address of an instruction

A variable that stores address of other variable

All of the above

Grand Test SQL

This is a grand SQL test

Questions: 40 | Attempts: 439 | Last updated: Jan 9, 2013

Sample Question
) You issue the following select statement in Oracle: SQL> select e.empno, e.ename, d.loc from emp e, dept d where e.deptno = d.deptno and substr(e.ename,1,1) = 'S';Which of the following statements identifies an ANSI-compliant equivalent statement usable on the Oracle database?

Select empno, ename, loc from emp join dept on emp.deptno = dept.deptno where substr(emp.ename,1,1) = 'S';

Select empno, ename, loc from emp, dept on emp.deptno = dept.deptno where substr(emp.ename,1,1) = 'S';

Select empno, ename, loc from emp join dept where emp.deptno = dept.deptno and substr(emp.ename,1,1) = 'S';

Select empno, ename, loc from emp join dept on emp.deptno = dept.deptno and substr(emp.ename,1,1) = 'S';

Modern Database Systems SQL Quiz

modern database systems sql quiz

This Quiz is all about testing the basics skills in SQL.It covers SQL Server architecture, tools, security and datatypes, Implementing data integrity, subqueries, joins and T-SQL Enhancements.

Questions: 30 | Attempts: 379 | Last updated: Jun 13, 2017

Sample Question
The primary - foreign key relations are used to

Cross-reference database tables

To index the database.

Clean-up the database

Quiz Me SQL

Questions regarding sql server 2005. mainly from stored procedures, triggers and indexes.

Questions: 44 | Attempts: 335 | Last updated: Jul 30, 2011

Sample Question
Which of the following statemens are true?

Procedures and functions must return values

Procedures and functions may return value

Procedures may return values

Functions must return values

SQL Test For Mappers

SQL Test for Mappers

Dear All,This quiz contains 10 quesions on SQL. Thought these quizzes will help us keep involved in some constructive work.If its ok to all the next one would be Unix followed by systems like MICA,BPI,FLEXCAB and CR'S

Questions: 10 | Attempts: 182 | Last updated: Dec 21, 2012

Sample Question
1. What does SQL stand for?

Structured Question Language

Structured Query Language

Strong Question Language

Dbms And SQL

DBMS AND SQL

Questions: 20 | Attempts: 181 | Last updated: Jan 30, 2013

Sample Question
The maximum length of NVARCHAR2 in sql data is

2000

4000

3000

1000

Sybase Quiz :: 1

Quiz for SQL, T-SQL

Questions: 5 | Attempts: 165 | Last updated: Jan 25, 2013

Sample Question
Can Index be created on temp tables?

Yes

No

SQL Quiz 2: Functions

SQL QUIZ 2: Functions

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 functions Case expression

Questions: 10 | Attempts: 154 | Last updated: Feb 21, 2013

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

SQL Data Base 2

Questions: 25 | Attempts: 138 | Last updated: Nov 27, 2012

Sample Question
SQL < select name ,sal from Emp where name like m%;

True

False

SQL Course 1 70-431

End of course assessment

Questions: 19 | Attempts: 128 | Last updated: Jan 10, 2013

Sample Question
Your application must access data that is located on two SQL Server 2005 computers. One ofthese servers is named SQL1 and the other is SQL2. You have permissions to create a storedprocedure on SQL1 to support your application. However, on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 byusing the OPENQUERY Transact-SQL statement. However, the query fails when executed. You need to troubleshoot the cause of the error. What should you do?

Join the two servers by using the four-part syntax of server.database.schema.table.

Reference SQL2 by using an alias.

Add SQL2 as a remote server to SQL1.

Add SQL2 as a linked server to SQL1.

SQL Statements

SQL STATEMENTS

Questions: 9 | Attempts: 118 | Last updated: Jul 3, 2015

Sample Question
Primary key is mandatory for a table?

True

False

SQL Complete Test 2008

sql complete test 2008

Final test for sql server 2008 .... all the best ....

Questions: 73 | Attempts: 114 | Last updated: Feb 12, 2013

Sample Question
How do XML instances work with respect to a computed column?

A computed columns can have XML instances as a source as well as a type

Computed columns can have XML instances only as a source

Computed columns can have a XML instancesonly as a type.

Computed columns cannot have XML instances

Access & SQL - Quiz 1

This quiz consists of 10 questions. You have 10 minutes to take the quiz.

Questions: 15 | Attempts: 101 | Last updated: Jul 30, 2011

Sample Question
Which of the following is NOT one of the three phases for Database Design phase?

A) Global Database Design

B) Conceptual Database Design

C) Logical Database Design

D) Physical Database Design

A Trivia Quiz About Postgresql!

A Trivia Quiz About PostgreSQL!

Used by big companies such as Twitter, PostgreSQL is a relational database management system. It can handle small to large workloads and is available for macOS, Linux, Windows, and other operating systems. The PostgreSQL Global...

Questions: 10 | Attempts: 100 | Last updated: May 24, 2019

Sample Question
PostgreSQL is also referred to as _____

Postgres

Postgrel

Postrel

Postgrels

« Previous12 3 Next »

Rdbms And SQL Knowledge Test

RDBMS and SQL Knowledge Test

Welcome to the RDBMS and SQL Knowledge Test. As you might already know, RDMS is the basis for various modern database systems such as SQL, MySQL, MS SQL Server, IBM DB2. etc. In this quiz, you will be asked questions about the...

Question: | Attempts: 5 | Last updated: Mar 5, 2021

The Ultimate SQL Syntax And Functionality Knowledge Test

The Ultimate SQL Syntax and Functionality Knowledge Test

Since its creation in 1974, SQL has become the most popular programming language for relational database management. With its fine set of functions and easy to learn syntax, it provides the ability to store, manipulate, and...

Question: | Attempts: 5 | Last updated: Mar 4, 2021

SQL Test: Trivia Quiz Questions!

Question: | Attempts: 493 | Last updated: Feb 23, 2021

SQL Table: Trivia Questions!

Question: | Attempts: 555 | Last updated: Jan 8, 2021

Sql Quiz Exam: MCQ!

SQL Quiz Exam: MCQ!

Question: | Attempts: 59 | Last updated: Jan 7, 2021

Chapter 1: Performing Queries Using Proc SQL

Structured Query Language is a domain-specific language used in programming and designed for managing data held in a relational database management system or for stream processing in a relational data stream management...

Question: | Attempts: 57 | Last updated: Sep 21, 2020

SQL Exam: Trivia Questions! Quiz

Question: | Attempts: 554 | Last updated: Sep 9, 2020

SQL Basic! Ultimate Trivia Quiz

Question: | Attempts: 17 | Last updated: Jun 9, 2020

SQL: Hardest Trivia Quiz On Relational Database!

SQL: Hardest Trivia Quiz on Relational Database!

Question: | Attempts: 35 | Last updated: Dec 17, 2019

Take This Simple SQL Trivia Quiz

Question: | Attempts: 712 | Last updated: Sep 2, 2019

Basic SQL Trivia Quiz!

Question: | Attempts: 922 | Last updated: Sep 2, 2019

The SQL Procedure: Trivia Quiz

Question: | Attempts: 713 | Last updated: Sep 2, 2019

Database And SQL Trivia Quiz!

Question: | Attempts: 611 | Last updated: Aug 7, 2019

A Trivia Quiz About Postgresql!

A Trivia Quiz About PostgreSQL!

Question: | Attempts: 100 | Last updated: May 24, 2019

SSIS Software Trivia Quiz

SSIS is a component of SQL, a data to import/export wizard, an ETL tool, and lots more. How much do you know about SSIS, its history, and the tool it contains? What developer created SSIS and in what year was it developed? Take...

Question: | Attempts: 100 | Last updated: May 24, 2019

SQL Union Operator Trivia Quiz

SQL UNION Operator Trivia Quiz

The SQL UNION is used in set operations. Test your knowledge in the use of the SQL UNION operator, and it's various functions in a data set by taking this quiz. You can also brush up on your knowledge of the difference...

Question: | Attempts: 100 | Last updated: May 3, 2019

Basic SQL Quiz For School Learners!

Basic SQL Quiz for School Learners!

This is a quiz on the SQL system. needed for learning at school

Question: | Attempts: 2793 | Last updated: Mar 2, 2019

Oca - SQL

OCA - SQL

Question: | Attempts: 5 | Last updated: Oct 4, 2018

SQL And Database Quiz

SQL and Database Quiz

Question: | Attempts: 5 | Last updated: Jun 11, 2018

Intelligent SQL Subjective Assessment Test

Here you are with an intelligent SQL subjective assessment test to help evaluate your knowledge and skills of SQL using a descriptive approach. Let's see what you got!

Question: | Attempts: 100 | Last updated: Mar 26, 2018

Intelligent SQL Server 2014 Assessment Test

Question: | Attempts: 100 | Last updated: Mar 22, 2018