Hey Guys, Today I’m going to share the Top 10 SQL SERVER questions that will be helpful in your interviews.
The list are given below with answers.
1.Describe SQL Server.
Data is stored and managed using SQL Server, a relational database management system created by Microsoft.
2.What categories do SQL Server’s indexes fall under?
There are clustered indexes and nonclustered indexes. A clustered index determines the physical order of data in a table, while a nonclustered index is a separate structure that contains a copy of the indexed data.
3.What does database design normalisation entail?
By separating data into different tables and creating relationships between them, normalisation is a method used to reduce data redundancy in databases.
4.What is a stored procedure?
A precompiled SQL statement that is kept in the database and may be performed by a user or application is known as a stored procedure.
5.What is a trigger?
An insert, update, or delete action, for example, might prompt the execution of a trigger, a special kind of stored procedure.
6.What is a transaction?
A series of database activities that are combined into a single unit of work are known as transactions. Data consistency and integrity are guaranteed via transactions.
7.What is a view?
A view is a fictitious table built from the output of a SELECT operation. Views are used to decompose difficult queries and provide a barrier between the user and the underlying data.
8.What is ACID compliance?
Atomicity, Consistency, Isolation, and Durability are together known as ACID. These are a group of characteristics that provide trustworthy database transaction processing.
9.How do primary keys and unique keys differ from one another?
By requiring uniqueness of values in a column or series of columns, primary keys and unique keys are both employed to protect the integrity of the data. Nevertheless, several unique keys can be established, but a table can only have one main key.
10.What is the difference between a join and a subquery?
A join is used to combine data from two or more tables based on a common column, while a subquery is a query that is embedded within another query to retrieve data based on a specific condition.