SQL Quiz #2 – Identifiers

Are you able to resolve today’s SQL quiz?
This week’s test has a difficulty level of: MODERATE



Before you start the quiz, let’s review the definition of an identifier, as presented on MSDN:

The database object name is referred to as its identifier. Everything in Microsoft SQL Server can have an identifier. Servers, databases, and database objects, such as tables, views, columns, indexes, triggers, procedures, constraints, and rules, can have identifiers. Identifiers are required for most objects, but are optional for some objects such as constraints.
An object identifier is created when the object is defined. The identifier is then used to reference the object.

Good luck 🙂