top of page

SQL Server

During the interview process I get a lot of questions of SQL Server, hopefully I can use this section to answer some of them.

  1. SQL Cluster - a collection of physical servers that has access to shared storage.

  2. SQL Constraints - Not Null, Check, Default, Unique, Primary Key and Foreign Key.

  3. Foreign Key - Maintains referential integrity across multiple tables.

  4. Functions - a)String, b)Math, c)Date and d)Advanced Functions.

  5. Differences between clustered and non-clustered index - Clustered Index is used for easy retrieval of data from the database and is faster.

  6. Index - a)Unique, b)Clustered and c)Non-clustered

  7. SQL Joins - a)Inner Join, b)Right join, c)Left join and d)Full join or full outer join.

  8. Normalization - the process of organizing data to avoid duplication and redundancy.

  9. Stored procedures - Reusable sql code than can be saved and reused over and over.

  10. Sql subsets - a)DDL (Data definition language), DML (Data manipulation language) and c) DCL (Data control language).

  11. T-SQL - a set of programming extensions from Microsoft that add several features to SQL, such as transaction control, exception and error handling, row processing and declared variables.

  12. Trigger - a special type of stored procedures that are defined to execute automatically in place or after data modifications.

bottom of page