Explanation: Microsoft’s SQL Server is a relational database management system (RDBMS). It was created largely to compete with the MySQL and Oracle databases. The standard SQL (Structured Query Language) language, ANSI SQL is supported by SQL Server. SQL Server is a highly secure server and does not allow any database file manipulation during the execution process.

Explanation: Microsoft released its first version of SQL Server in the year of 1988. This version was developed jointly by Microsoft and Sybase for the OS/2 platform.

Explanation: SQL Server Express Edition is a scaled down, free edition of SQL Server, which includes the core database engine.

Explanation: First version of SQL Server was designed for the OS/2 platform and was developed jointly by Microsoft and Sybase along with Ashton-Tate.

Explanation: Codenames for SQL Server 2005, 2008, 2008 R2, 2012, 2014 are Yukon, Katmai, Kilimanjaro, Denali and Hekaton respectively.

Explanation: SQL Server 2014 provides a new in-memory capability for tables that can fit entirely in memory (also known as Hekaton).

Explanation: SQL Server doesn’t have a Boolean data type, at least not by that name. To store True/False, Yes/No, and On/Off values, use the bit data type. It accepts only three values: 0, 1, and NULL.

Explanation: MSDB Database stores information related to database backups, DTS packages, Replication, SQL Agent information, SQL Server jobs.

Explanation: In SQL Server we have two types of views-System Defined Views and User Defined Views.

Explanation: The INFORMATION_SCHEMA views allow you to retrieve metadata about the objects within a database. These views can be found in the master database under Views / System Views and be called from any database in your SQL Server instance.

Explanation: SQL inner joins are the default joins in SQL Server. Inner query joins only the rows that are matching.

Explanation: In SQL Server, NOT NULL specifies that the column does not accept NULL values.

Explanation: In SQL Server, the XML data model is a good choice if you want a platform-independent model in order to ensure the portability of the data by using structural and semantic markup.

Explanation: Hybrid model may yield better performance in that you have more control over the indexes created on the relational columns and locking characteristics.

Explanation: You need to create a stored procedure to process incoming XML from a partner before SQL Server 2005.

Explanation: Transact-SQL provides special words called control-of-flow language that control the flow of execution of Transact-SQL statements in SQL Server.

Explanation: Exception handling is possible in SQL Server using THROW. It generates an error message and initiates error processing for the session.

Explanation: System defined Procedure is already defined in SQL Server. System defined Procedure procedure starts with the sp_ prefix.

Explanation: In SQL Server we can create triggers on DML statements (like INSERT, UPDATE, and DELETE) and stored procedures that perform DML-like operations.

Explanation: SQL Server user-defined functions are routines that accept parameters, perform an action, such as a complex calculation, and return the result of that action as a value.