This is a collection of previously published articles on this site about SQL Server interview questions and answers. This is for quick reference.
SQL Interview Questions – Part-1
What does the business rule in the context of a database? A business rule is a declaration that places restrictions on a certain feature of the database, such as the details of a field’s field specification or the properties of a given relationship. What is normalization? By reducing the redundant data, normalization is a rigorous…
SQL Interview Questions – Part-2
What is Savepoint in SQL? By designating a point inside a transaction that may be “rolled back to” without impacting any work done in the transaction prior to the savepoint being formed, a savepoint is a method of implementing subtransactions within a relational database management system. A single transaction may contain many savepoints. In other…
SQL Interview Questions – Part-3
What is a primary key? A primary key is a unique column (or set of columns) in a relational database table that is used to identify each record in the table. Entity integrity makes sure that there aren’t any duplicate records in the database and that each record’s identifying field is distinct and never null.…
SQL Interview Questions – Part-4
What is a JOIN in SQL? A JOIN clause is used to combine rows from two or more tables, based on a related column between these tables. The purpose of JOINS in SQL is to access data from various tables based on logical relationships. We can use joins to fetch matched or mismatched records from…
SQL Interview Questions – Part-5
What is an alias in SQL? In SQL Server, aliases can be used to create a temporary name for columns or tables. Column aliases are used to make column headings easier to read in your result set. Table aliases are used to shorten your SQL for easier reading or when performing joins. An alias exists…
SQL Interview Questions – Part-6
What is an alias in SQL Server Agent? Jobs can be scheduled and carried out using SQL Server Agent. Here, each job has one or more steps, and each of those steps has a task within it. So that a job may be scheduled to run, the Server Agent stores job information in the SQL…
SQL Interview Questions – Part-7
What is the difference between HAVING and GROUP BY? The HAVING clause is only used with the SELECT statement and is often used with the GROUP BY clause, despite the fact that both specify a search criterion. When the GROUP BY clause is absent, the HAVING clause just functions as a WHERE clause. What is…
SQL Interview Questions – Part-8
What are the properties of a transaction? The properties of a transaction are referred to as ACID properties. They are – Atomicity Consistency Isolation Durability Describe ACID properties in databases. Atomicity: This characteristic of a transaction means that a transaction is performed completely not performed at all. I.e. all the tasks in a transaction are…
Big Data and SQL 