SQL Quiz #2 – Identifiers

Posted on by SQL by the book

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

DifficultyLevel_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 🙂