SQL Quizzes, Questions & Answers

Recent Quizzes

This quiz covers key operations in web data management using PDO in SQL, focusing on creating objects, executing statements, and handling exceptions. It tests practical skills essential for database connectivity and operations.

Questions: 40 | Attempts: 725 | Last updated: Mar 21, 2023

Sample Question
When you create a PDO object, you have to pass all but one of these arguments to it: Which one is it?

Data source name

Server name

User name

Password

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

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 6: Chapter 6: Creating And Managing Indexes Using Proc SQL

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

This quiz focuses on creating and managing indexes in SQL, particularly using PROC SQL. It assesses skills related to index creation, ensuring uniqueness, composite index creation, index utilization checking, and index deletion....

Questions: 10 | Attempts: 105 | Last updated: Feb 13, 2024

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

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

Ms SQL Server Proficiency Exam

MS SQL Server Proficiency Exam

Welcome to our MS SQL Server Quiz! This quiz is designed to challenge your expertise and enhance your understanding of Microsoft SQL Server, one of the most popular relational database management systems. Whether you are a...

Questions: 15 | Attempts: 641 | Last updated: May 8, 2024

Sample Question
Select the correctly formed SQL Statement from the below choices.

INSERT ('1','Sam' INTO (ID,Name) USING People

INSERT INTO People ('1','Sam') VALUES (ID, Name)

INSERT INTO People (ID, Name) VALUES (@@IDENTITY,'Sam')

INSERT INTO People SET ID=1, Name='Sam'

SQL Training Jan13 - Quiz1

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

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

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

True

False

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

Ilp Oracle Prelims 2

ILP Oracle Prelims 2

ILP Oracle Prelims 2 is a quiz designed to assess knowledge in SQL and Oracle database management. It covers SQL queries, PL\/SQL blocks, and format functions, testing practical skills essential for database professionals.

Questions: 8 | Attempts: 78 | Last updated: Jun 25, 2024

Sample Question
What is the output of the below query: select instr('120000 12 0 .125',1,'.') from dual;

13

Compilation error

Syntax error

None of the above

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

« Previous 1 234 5 6 Next »