#database developer interview questions

This is a collection of previously published articles on this site about SQL Server interview questions and answers. This is for quick reference.

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…

The entity-relationship diagram (ER diagram) provides a visual representation of the logical links between tables in databases. The ER Diagram shows the relationships between the tables as well as the table structures' column names and associated data typ

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 completed or none are…

A collection of one or more SQL statements that communicate with a database is known as a SQL transaction. A whole transaction can be committed to a database as one logical unit or can be rolled back (undone) as one logical unit. Transactions in SQL are c

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 a transaction in TSQL? A collection of one or more SQL statements that communicate with a…

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 Server.

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 Server. Jobs, Schedules, Operators, and Alerts are the SQL Server Agent’s primary components. What are the authentication…

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 only for the duration of the query. The AS keyword is used to create an alias, but it is not required…

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 mismatche

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 more than one table. How many different forms of JOINs are there? SQL Server supports different kinds of…

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. The primary tenet of entity integrity is the existence of the Primary Key. It cannot be a relational t

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. The primary tenet of entity integrity is the existence of the Primary Key. It cannot be…

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 managemen

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 words, in a relational database management…