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?

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