SQL Quizzes, Questions & Answers

Recent Quizzes

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

Questions: 21 | Attempts: 269 | Last updated: Sep 16, 2024

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

True

False

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: 12960 | Last updated: Mar 22, 2023

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

COUNT()

NUMBER()

SUM()

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: 590 | Last updated: Mar 21, 2023

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

True

False

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: 1443 | Last updated: Mar 21, 2023

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: Hardest Trivia Quiz On Relational Database!

SQL: Hardest Trivia Quiz on Relational Database!

Questions: 60 | Attempts: 338 | Last updated: Mar 22, 2023

Sample Question
In backtracking search, the most-constrained-variable and most-constraining variable strategies are used to

Perform forward checking

Decide what order should the values be tried for a variable

Detect inevitable failure early

Decide which variable should be assigned next

What You Know About SQL ?

what you know about sql ???

Questions: 10 | Attempts: 134 | Last updated: Apr 16, 2024

Sample Question
What does SQL stand for?

Strong Question Language

Structured Query Language

Structured Question Language

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: 1826 | Last updated: Mar 22, 2023

Sample Question
The primary - foreign key relations are used to

Cross-reference database tables

To index the database.

Clean-up the database

SQL Complete Test 2008

sql complete test 2008

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

Questions: 73 | Attempts: 287 | Last updated: Mar 17, 2023

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

SQL Interview Questions And Answers

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: 399 | Last updated: Sep 6, 2023

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 Data Base 2

Questions: 25 | Attempts: 204 | Last updated: Mar 19, 2023

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

True

False

« Previous 1 2 345 6 Next »