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 Quizzes

Oracle Mock Test 2(SQL +arch)

Questions: 26 | Attempts: 4001 | 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;

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

Sql MCQ Exam: Trivia Quiz!

SQL MCQ Exam: Trivia Quiz!

Questions: 25 | Attempts: 1052 | 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 Quiz Exam: MCQ!

SQL Quiz Exam: MCQ!

Questions: 25 | Attempts: 752 | Last updated: Dec 1, 2021

Sample Question
¿Qué significa SQL?

Structured Query Language

Strong Question Language

Structured Question Language

Multiple Choice Questions -SQL

Questions: 37 | Attempts: 966 | Last updated: Dec 1, 2021

Sample Question
Full form of RDBMS is

Regional district management system

Relational database management system

Regular database management system

Regular district machine system

Recent Quizzes

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...

Questions: 10 | Attempts: 90 | Last updated: Mar 5, 2021

Sample Question
Which data manipulation command is used to combines the records from one or more tables?

SELECT

PROJECT

JOIN

PRODUCT

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...

Questions: 40 | Attempts: 58 | Last updated: Mar 4, 2021

Sample Question
Nomalization reduces data redundancy.

True

False

SQL Basic! Ultimate Trivia Quiz

Questions: 10 | Attempts: 117 | Last updated: Jun 9, 2020

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

COUNT()

NUMBER()

SUM()

COUNT(*)

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: 208 | Last updated: May 24, 2019

Sample Question
PostgreSQL is also referred to as _____

Postgres

Postgrel

Postrel

Postgrels

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...

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

Sample Question
SSIS is a platform for _____

Data integration

Workflow integration

Media integration

Visual integration

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...

Questions: 10 | Attempts: 328 | Last updated: May 3, 2019

Sample Question
The SQL UNION Operator enables you draw information from two or more table with the _____

Value

Structure

Rows

Lines

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!

Questions: 10 | Attempts: 209 | Last updated: Mar 26, 2018

Sample Question
SQL stands for__

Structured query language

Software query language

Structured questionnaire language

Standard query language

Intelligent SQL Server 2014 Assessment Test

Questions: 10 | Attempts: 135 | Last updated: Dec 1, 2021

Sample Question
SQL stands for

Structured query language

Software query language

Structured questionnaire language

Standard query language

SSRS 2008 Test

SQL Server Reporting Services (SSRS) is a software developed by Microsoft to prepare and deliver a server-based report. This quiz is for people who are familiar with SSRS. If you're able to score above 70%, then you are an...

Questions: 10 | Attempts: 1851 | Last updated: Mar 14, 2018

Sample Question
Which of these provides a simpler user interface for creating ad hoc reports, directed primarily at business users rather than developers?

Report Designer

Report Builder

Report Initiator

Report Framer

Oracle Pl/SQL Quiz: Trivia Exam!

Oracle PL/SQL Quiz: Trivia Exam!

Questions: 20 | Attempts: 942 | 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';

SSRS Po Stalino Mirties

SSRS po Stalino mirties

Radus klaidÄ… - rašykite mumsTESTO ATNAUJINIMAI:2017-04-262017-04-292017-05-02

Questions: 15 | Attempts: 326 | Last updated: May 2, 2017

Sample Question
Kieno valdymo metu vyko atšilimas?

N. Chruščiovo

Brežnevo

Gorbačiovo

Rdbms Quiz Questions And Answers

Rdbms quiz questions and answers

Questions: 30 | Attempts: 93 | Last updated: Dec 1, 2021

Sample Question
In SQL WHERE clause:

Limits the column data that are returned.

Limits the row data that are returned.

Both A and B are correct.

Neither A nor B are correct.

SQL And Database Quiz

SQL and Database Quiz

Questions: 8 | Attempts: 348 | Last updated: Jun 11, 2018

Sample Question
How do you create a database? Which command is correct?

Create database ;

Create database NAME;

Basic SQL Quiz By - M Khan

Questions: 5 | Attempts: 84 | Last updated: Dec 1, 2021

Sample Question
Sorts are Alphabetical in SQL, not Logical.

True

False

SQL Select: The Basics

This is a quiz to test the knowledge of SQL basics based on a lesson given to learners.

Questions: 12 | Attempts: 127 | Last updated: Aug 13, 2013

Sample Question
Which of the following is NOT a commonly accepted rule for joining multiple tables?

It is commonly accepted to list joins between tables before other items in the WHERE clause

It is recommended that aliases be keywords to keep the statement uniform throughout

It is recommended that joins between tables are based on Primary/Foreign keys

Any table listed in a join statement MUST exist in the FROM element

Chapter 8: Managing Processing Using Proc SQL

Chapter 8: Managing Processing Using PROC SQL

Practice for the SAS advance certification exam

Questions: 10 | Attempts: 61 | Last updated: Dec 1, 2021

Sample Question
PROC SQL options are specified in

The PROC SQL statement

An OPTIONS statement.

A SELECT statement.

The OPTIONS procedure.

Chapter 7: Creating And Managing Views Using Proc SQL

Chapter 7: Creating and Managing Views Using PROC SQL

Practice for the SAS advance certification exam.

Questions: 10 | Attempts: 65 | Last updated: Jun 28, 2013

Sample Question
Which of the following statements is false regarding a PROC SQL view?

A view cannot be used in a join.

A view accesses the most current underlying data.

A view follows the same naming conventions as a table.

A view can be used in SAS programs in place of an actual SAS data file.

Chapter 6: Chapter 6: Creating And Managing Indexes Using Proc SQL

Chapter 6: Chapter 6: Creating and Managing Indexes Using PROC SQL

Practice for SAS advance certification exam.

Questions: 10 | Attempts: 62 | Last updated: Jun 28, 2013

Sample Question
Which of the following will create an index on the column EmpID for the table Sasuser.Staffmaster?

proc sql; create simple index(empid) on sasuser.staffmaster;

proc sql; create empid index on sasuser.staffmaster(empid);

proc sql; create simple index on empid from sasuser.staffmaster;

proc sql; create index empid on sasuser.staffmaster(empid);

Chapter 5: Creating And Managing Tables Using Proc SQL

Chapter 5: Creating and Managing Tables Using PROC SQL

Practice for the SAS advance certification exam

Questions: 10 | Attempts: 55 | Last updated: Jun 28, 2013

Sample Question
Which of the following PROC SQL steps creates a new table by copying only the column structure (but not the rows) of an existing table?

proc sql; create table work.newpayroll as select * from sasuser.payrollmaster;

proc sql; create table work.newpayroll like sasuser.payrollmaster;

proc sql; create table work.newpayroll copy sasuser.payrollmaster;

proc sql; create table work.newpayroll describe sasuser.payrollmaster;

Chapter 4: Combining Tables Vertically Using Proc SQL

Chapter 4: Combining Tables Vertically Using PROC SQL

Practice for the SAS advance certification exam

Questions: 10 | Attempts: 112 | Last updated: Jun 28, 2013

Sample Question
Which statement is false with respect to a set operation that uses the EXCEPT, UNION, or INTERSECT set operator without a keyword?

Column names in the result set are determined by the first table.

To be overlaid, columns must be of the same data type.

To be overlaid, columns must have the same name.

By default, only unique rows are displayed in the result set.

Chapter 3. Combining Tables Horizontally Using Proc SQL

Chapter 3. Combining Tables Horizontally Using PROC SQL

Practice for the SAS advance certification exam.

Questions: 10 | Attempts: 92 | Last updated: Jun 28, 2013

Sample Question
A Cartesian product is returned when

Join conditions are not specified in a PROC SQL join.

Join conditions are not specified in a PROC SQL set operation.

More than two tables are specified in a PROC SQL join.

The keyword ALL is used with the OUTER UNION operator.

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...

Questions: 10 | Attempts: 292 | Last updated: Sep 21, 2020

Sample Question
Which of the following clauses in the PROC SQL program below is written incorrectly? proc sql; select style sqfeet bedrooms from choice.houses where sqfeet ge 800;

SELECT

FROM

WHERE

Both a and c

« Previous12 3 Next »