12th Grade SQL & Querying Quizzes, Questions & Answers

Recent SQL & Querying Quizzes

The BLUEKEY TECHNICAL TEST LEVEL 2 assesses knowledge in SQL database operations. It covers adding and removing rows, using WHERE clauses, understanding views, and utilizing wildcards in queries. This quiz is essential for...

Questions: 30 | Attempts: 150 | Last updated: Mar 14, 2025

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

ADD

INSERT

CREATE

MAKE

Do You Know Views In SQL Server?

DO YOU KNOW VIEWS IN SQL SERVER?

Explore the functionalities of SQL Server Views with this quiz. It tests knowledge on view updatability, indexing, and order handling. Ideal for learners aiming to enhance their SQL Server skills.

Questions: 5 | Attempts: 286 | Last updated: Mar 20, 2025

Sample Question
Can we use Order by in SQL Server Views?

NO

YES

Some Cases Yes

Basic SQL Quiz By - M Khan

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: 195 | Last updated: Mar 21, 2025

Sample Question
Sorts are Alphabetical in SQL, not Logical.

True

False

SQL Server TSQLquiz - 8

SQL Server TSQLQuiz - 8

The SQL Server TSQLQuiz - 8 assesses knowledge on T-SQL queries, data types, transaction durability, and command configurations within SQL Server environments, focusing on practical applications and system understanding.

Questions: 10 | Attempts: 336 | Last updated: Mar 22, 2025

Sample Question
I have a table, Sales, with the Notes field having the Filestream attribute. I run this query: select salesmen, notes into #salestemp from Sales What is the data type of the Notes field in the temporary table?

Varchar(max)

Varchar(max) with the filestream attribute

Varbinary(max)

Varbinary(max) with filestream attribute

Tsql Database - Quiz -5

TSQL Database - Quiz -5

TSQL Database - Quiz -5 assesses knowledge on SQL operations, trigger creation, and table manipulations. It challenges users to understand execution orders, result sets, and the behavior of SQL commands in a TSQL environment,...

Questions: 10 | Attempts: 80 | Last updated: Oct 6, 2025

Sample Question
Out of 4 statements namely 1,2,3,4,5, which of the statement/statements will execute successfully? if object_id('test2') is not null drop table test2 if object_id('test1') is not null drop table test1 create table test1 (a int not null primary key); create table test2 (b int,a int ) GO --statement 1 insert into test1 output inserted.a select 1 GO --statement 2 create trigger trig_test1 on test1 after insert as select 2 GO --statement 3 insert into test1 select 3 GO --statement 4 insert into test1 output inserted.a select 4 GO --statement 5 declare @temp as table (b int) insert into test1 output inserted.a into @temp select 5 select * from @temp GO

1

2

3

4

5

SQL Server T-SQL Quiz-i

SQL Server T-SQL Quiz-I

If you are a computer nerd that is really into programming then this quiz is specifically for you. It aims to find out how much knowledge you have on the SQL server T-SQL. All the best.

Questions: 10 | Attempts: 2755 | Last updated: Apr 22, 2025

Sample Question
What does the select statement return? Create Table #T ( N1 Real , N2 Float); Insert Into #T Values (99.99999999991 , 99.99999999997); Select * From #T; Drop Table #T;

The select statement returns < 100 for N1 and 100 for N2

The select statement returns 100 for N1 and < 100 for N2

The select statement returns < 100 for both columns

The select statement returns 100 for both columns

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, 2025

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: Oct 5, 2025

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 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: 159 | Last updated: Aug 23, 2025

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: 622 | Last updated: Mar 21, 2025

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

« Previous 1 234 5 6 7 Next »