Advertisement

Advertisement

Advertisement

SQL & Querying Quizzes, Questions & Answers

Recent SQL & Querying Quizzes

SQL Server TSQLquiz - 8

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

SQL Select: The Basics

Questions: 12 | Attempts: 324 | Last updated: Mar 22, 2025

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

Tsql Database - Quiz -5

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

Questions: 10 | Attempts: 2765 | 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 7: Creating And Managing Views Using Proc SQL

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

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

Questions: 10 | Attempts: 106 | 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

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 4: Combining Tables Vertically Using Proc SQL

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

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

Questions: 10 | Attempts: 160 | 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

Questions: 10 | Attempts: 627 | 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 2 345 6 7 8 9 Next »

Advertisement