SQL Quiz

Boolean

Int

Char

Float

4000

Unlimited

800

8000

Atomicity, Consistency, Isolation, Durability

Accuracy, Consistency, Isolation, Durability

Atomicity, Compatibility, Isolation, Durability

Atomicity, Consistency, Integrity, Durability

Indexes are automatically created for primary key

constraints

Unique indexes do not allow NULL values

Non-clustered indexes always have smaller storage

footprint than clustered indexes

Clustered indexes physically reorder the data in the

table

NCHAR

VARCHAR

NVARCHAR

CHAR

CROSS JOIN

INNER JOIN

FULL OUTER JOIN

LEFT JOIN

No, stored procedures cannot call other stored

procedures

Yes, but only 1 level deep

Yes, with unlimited nesting levels

Yes, but limited to 3 levels of nesting

Yes, but cross-database views can only be created

by system administrators

Yes, cross-database views on the same server are

fully supported

No, SQL Server does not allow cross-database view

references even if they are on the same server

Yes, but cross-database views on the same server

require the use of linked servers

UNION ALL often faster, since no duplicate removal

required

UNION and UNION ALL same performance

Performance depends on number of tables involved

UNION often faster, since returns a smaller result

CTEs can be referenced multiple times within the

same query.

CTEs simplify complex recursive queries which is

challenging with subqueries

CTEs can only be used in SELECT statements

CTEs cannot be nested within another CTE