Top 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?

Topics

SSRS

SQL Questions and Answers

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

COUNT()

NUMBER()

SUM()

SQL question from

The ultimate Server Query Language Quiz

Take Quiz
The FROM SQL clause is used to…

specify range for search condition

specify search condition

specify what table we are selecting or deleting data from.

SQL question from

The ultimate Server Query Language Quiz

Take Quiz
Which of the following is NOT a SQL keyword or SQL clause?

INSERT

SELECT

UPDATE

INVERT

SQL question from

The ultimate Server Query Language Quiz

Take Quiz
when did SQL appear

1974

1922

1977

1987

SQL question from

My SQL Quiz

Take Quiz
who developed SQL

IBM

DELL

SQL

Microsoft

Apple

SQL question from

My SQL Quiz

Take Quiz
who designed the SQL system

Donald D. Chamberlin

Raymond F. Boyce

Jerron Q. Refter

Both A & B

Both A & C

SQL question from

My SQL Quiz

Take Quiz
) 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';

SQL question from

Grand Test SQL

Take Quiz
You are trying to manipulate data on the Oracle database. Which of the following choices identifies a capacity of select statements in Oracle and does not require the use of a subquery?

You can change data in Oracle using select statements.

You can remove data from Oracle using select statements.

You can create a table with the contents of another using select statements.

You can truncate tables using select statements

SQL question from

Grand Test SQL

Take Quiz
You issue a query in the Oracle database. Which of the following choices does not identify a component of your query if you want the query to execute a mathematical operation on user-defined static expressions?

Column clause

Table clause

The DUAL table

The where clause

SQL question from

Grand Test SQL

Take Quiz
The primary - foreign key relations are used to

cross-reference database tables

to index the database.

clean-up the database

SQL question from

Modern database systems sql quiz

Take Quiz
The UNION SQL clause can be used with

the DELETE and UPDATE clauses

the SELECT clause only

the UPDATE clause only

SQL question from

Modern database systems sql quiz

Take Quiz
Can you join a table to itself?

YES

NO

SQL question from

Modern database systems sql quiz

Take Quiz

‹ ›

All Time Popular

Recent

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

Quiz Me SQL

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

Questions: 44 | Attempts: 335

Oracle Mock Test 2(SQL +arch)

Questions: 26 | Attempts: 280

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

Dbms And SQL

Questions: 20 | Attempts: 181

Sybase Quiz :: 1

Quiz for SQL, T-SQL

Questions: 5 | Attempts: 165

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

SQL Data Base 2

Questions: 25 | Attempts: 138

SQL Course 1 70-431

End of course assessment

Questions: 19 | Attempts: 128

SQL Statements

Questions: 9 | Attempts: 118

Basic SQL Test

SQL test for beginners

Questions: 3 | Attempts: 118

SQL Complete Test 2008

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

Questions: 73 | Attempts: 114

Access & SQL - Quiz 1

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

Questions: 15 | Attempts: 101

Intelligent SQL Server 2014 Assessment Test

Questions: 10 | Attempts: 100

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: 100

SQL Interview Questions And Answers

SQL is modern database system, which is used in programming and designed for managing data. Take this quiz and learn more about it!

Questions: 27 | Attempts: 100

SQL Quiz By "the Cloud 9"

Questions: 18 | Attempts: 88

SQL Training Jan13 - Quiz1

Test your basic database skills, RDBMS, DDL, DML, Normalization etc.

Questions: 21 | Attempts: 78

Integrator SQL Test

A quiz to test basic SQL skillz

Questions: 12 | Attempts: 78

Samplebhavya

Questions: 30 | Attempts: 63

09 - Web Intelligence Basic Concepts

Questions: 5 | Attempts: 60

SQL Quiz-2 By "the Cloud9"

Questions: 16 | Attempts: 59

Chapter 1: Performing Queries Using Proc SQL

Practice for the Advance SAS certification exam.

Questions: 10 | Attempts: 57

SQL Test 1

Questions: 20 | Attempts: 52

SQL - Cup Bra

Teste basico SQL _ 2008

Questions: 12 | Attempts: 51

Chapter 4: Combining Tables Vertically Using Proc SQL

Practice for the SAS advance certification exam

Questions: 10 | Attempts: 50

Access Clasa A X A

Questions: 10 | Attempts: 49

Chapter 3. Combining Tables Horizontally Using Proc SQL

Practice for the SAS advance certification exam.

Questions: 10 | Attempts: 39

SQL Technology Quiz: Can You Solve?

SQL is the standard and acceptable language for storing, manipulating and retrieving data in databases. This technology helps the specialists in undertaking their work. How good are you with different SQL concepts? Find out...

Questions: 20 | Attempts: 36

What You Know About SQL ?

Questions: 10 | Attempts: 35

« Previous12 Next »

Top SQL Quizzes & Trivia

Related Topics

SQL Questions and Answers