SQL Quizzes, Questions & Answers

Recent Quizzes

Basic SQL Quiz By - M Khan assesses understanding of SQL syntax and operations. It covers topics like sorting, aliasing, query syntax, precedence rules, and wildcard usage, essential for database management skills.

Questions: 5 | Attempts: 192 | Last updated: Mar 21, 2023

Sample Question
Sorts are Alphabetical in SQL, not Logical.

True

False

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: 319 | 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 8: Managing Processing Using Proc SQL

Chapter 8: Managing Processing Using PROC SQL

This quiz in Chapter 8 focuses on managing processing using PROC SQL in SAS. It tests knowledge on syntax, options like INOBS, and specific SQL commands for data handling and querying, enhancing skills in database management and...

Questions: 10 | Attempts: 135 | Last updated: Mar 21, 2023

Sample Question
PROC SQL options are specified in

The PROC SQL statement

An OPTIONS statement.

A SELECT statement.

The OPTIONS procedure.

Chapter 7: Creating And Managing Views Using Proc SQL

Chapter 7: Creating and Managing Views Using PROC SQL

This quiz in Chapter 7 focuses on creating and managing views using PROC SQL. It tests understanding of view operations, such as creation, joining, and querying, enhancing skills in database management and SQL programming.

Questions: 10 | Attempts: 125 | Last updated: Jul 23, 2024

Sample Question
Which of the following statements is false regarding a PROC SQL view?

A view cannot be used in a join.

A view accesses the most current underlying data.

A view follows the same naming conventions as a table.

A view can be used in SAS programs in place of an actual SAS data file.

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 5: Creating And Managing Tables Using Proc SQL

Chapter 5: Creating and Managing Tables Using PROC SQL

Explore the essentials of managing tables in PROC SQL with this quiz from Chapter 5. It covers table creation, row and data manipulation, and understanding integrity constraints. This quiz is ideal for learners aiming to enhance...

Questions: 10 | Attempts: 104 | Last updated: Dec 5, 2023

Sample Question
Which of the following PROC SQL steps creates a new table by copying only the column structure (but not the rows) of an existing table?

proc sql; create table work.newpayroll as select * from sasuser.payrollmaster;

proc sql; create table work.newpayroll like sasuser.payrollmaster;

proc sql; create table work.newpayroll copy sasuser.payrollmaster;

proc sql; create table work.newpayroll describe sasuser.payrollmaster;

Chapter 4: Combining Tables Vertically Using Proc SQL

Chapter 4: Combining Tables Vertically Using PROC SQL

Explore the intricacies of combining tables vertically in PROC SQL with this focused quiz. Topics include UNION, EXCEPT, INTERSECT operations, and understanding column overlay in SQL queries. Essential for learners aiming to...

Questions: 10 | Attempts: 183 | Last updated: Mar 22, 2023

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.

Chapter 3. Combining Tables Horizontally Using Proc SQL

Chapter 3. Combining Tables Horizontally Using PROC SQL

This quiz focuses on combining tables horizontally using PROC SQL, specifically through join operations. It tests understanding of Cartesian products, inner joins, and join conditions, enhancing skills in SQL query formulation...

Questions: 10 | Attempts: 158 | Last updated: Aug 23, 2024

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.

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: 603 | 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'

« Previous 1 234 5 6 Next »