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

Basic SQL Quiz for School Learners!

Take Quiz
who developed SQL

IBM

DELL

SQL

Microsoft

Apple

SQL question from

Basic SQL Quiz for School Learners!

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

Basic SQL Quiz for School Learners!

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

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

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 Exam

SQL Exam quiz

Questions: 26 | Attempts: 286

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

True

False

Oracle Mock Test 2(SQL +arch)

Questions: 26 | Attempts: 280

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;

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

Sample Question
1. What does SQL stand for?

Structured Question Language

Structured Query Language

Strong Question Language

Dbms And SQL

Questions: 20 | Attempts: 181

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

Sample Question
Can Index be created on temp tables?

Yes

No

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

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

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

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

Questions: 9 | Attempts: 118

Sample Question
Primary key is mandatory for a table?

True

False

Basic SQL Test

SQL test for beginners

Questions: 3 | Attempts: 118

Sample Question
Which SQL keyword is used to retrieve a minimum value?

LOW

DOWN

LOWER

MIN

SQL Complete Test 2008

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

Questions: 73 | Attempts: 114

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

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

Intelligent SQL Server 2014 Assessment Test

Questions: 10 | Attempts: 100

Sample Question
SQL stands for

Structured query language

Software query language

Structured questionnaire language

Standard query language

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

Sample Question
SQL stands for__

Structured query language

Software query language

Structured questionnaire language

Standard query language

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

Sample Question
"Consider the following statement: Select title_id, price, type from titles where price > dbo.AverageBookPrice('comp_science') What kind of a User Defined Function is used in the above statement?"

A) Scalar function

B) In-line table valued function

C) Multi-statement table valued function

D) None of the listed options

SQL Quiz By "the Cloud 9"

Questions: 18 | Attempts: 88

Sample Question
With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

1. DELETE ROW FirstName='Peter' FROM Persons

2. DELETE FirstName='Peter' FROM Persons

3. DELETE FROM Persons WHERE FirstName = 'Peter'

4. None

SQL Training Jan13 - Quiz1

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

Questions: 21 | Attempts: 78

Sample Question
A Multidimensional Cube is a type of a relational database

True

False

Integrator SQL Test

A quiz to test basic SQL skillz

Questions: 12 | Attempts: 78

Sample Question
Which function is a character manipulation function?

TRIM

REPLACE

TRUNC

Samplebhavya

Questions: 30 | Attempts: 63

Sample Question
Which of the following are contained in the memory region Program Global Area(PGA)? (Choose 2)

Data and Control information for a server process

Private SQL areas to process cursors

Data dictionary cache for the user schema

Processes which are sharable

09 - Web Intelligence Basic Concepts

Questions: 5 | Attempts: 60

Sample Question
Web Intelligence includes a formula language. This language extends SQL with a set of functions

True

False

SQL Quiz-2 By "the Cloud9"

Questions: 16 | Attempts: 59

Sample Question
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHARD2(25) LAST_NAME VARCHARD2(25) HIRE_DATE DATE NEW EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2(60) Which UPDATE statement is valid?

UPDATE new_employees SET name = (Select last_name|| first_name FROM employees Where employee_id =180) WHERE employee_id =180;

UPDATE new_employees SET name = (SELECT last_name||first_name FROM employees) WHERE employee_id =180;

UPDATE new_employees SET name = (SELECT last_name|| first_name FROM employees WHERE employee_id =180) WHERE employee_id =(SELECT employee_id FROM new employees);

UPDATE new_employees SET name = (SELECT last name|| first_name FROM employees WHERE employee_id= (SELECT employee_id FROM new_employees)) WHERE employee_id =180;

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

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

SQL Test 1

Questions: 20 | Attempts: 52

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

SQL - Cup Bra

Teste basico SQL _ 2008

Questions: 12 | Attempts: 51

Sample Question
Qual comando para crear Tabela ?

Drop

Create

Update

Anser

Chapter 4: Combining Tables Vertically Using Proc SQL

Practice for the SAS advance certification exam

Questions: 10 | Attempts: 50

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.

Access Clasa A X A

Questions: 10 | Attempts: 49

Sample Question
A database is ?

A collection of file.

A collection of records .

A collection of data.

A collection of tables.

Chapter 3. Combining Tables Horizontally Using Proc SQL

Practice for the SAS advance certification exam.

Questions: 10 | Attempts: 39

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.

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

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

ADD

CREATE

INSERT

MAKE

« Previous12 Next »

Top SQL Quizzes & Trivia

Related Topics

SQL Questions and Answers