In this blog post, I will share frequently most asked top interview questions on sql server for experienced and freshers to get the right job. Find the list below:-

• Keep reading on Interview Questions on .NET Framework, C# Interview Questions for Experienced Professionals

MS SQL Server Interview Questions

Introducing SQL Server

• What is SQL Server?
• What are the different versions of SQL Server?
• What is the default running port for a default SQL Server instance?
• What are the various system-defined databases in SQL Server?
• What is a master database in SQL Server?
• What is the TempDB database in SQL Server?
• What is the Model database in SQL Server?
• What is the MSDB database?
• What is the Resource database?
• Can you run SQL Server on Linux?
• What new features are coming to SQL Server 2019?
• Can you access or query remote SQL Server database from a Mac, Linux or Ubuntu machine?
• What is Azure Data Studio?

Database Basics

• What is the difference between DBMS and RDMS?
• What is normalization?
• What are the different normal forms?
• Do you explain each normal form?
• What are the differences between char and nchar?
• What are the differences between varchar and nvarchar?
• What are the differences between varchar(MAX) and text?
• What is the SQL key?
• What are the different types of SQL Keys?
• Can you define all the keys in a database table?
• What are the differences between Primary Key and Unique Key?
• How to define Primary Key and Unique Key?
• What is the difference between Primary Key and Foreign Key?
• How to define Primary Key and Foreign Key?
• What are SQL Commands and what are different types of SQL Commands?
• What are DDL Commands?
• What are DML Commands?
• What are DQL Commands?
• What are TCL Commands?
• What are DCL Commands?
• What is Grant and Revoke Commands?
• What are SQL Constraints or SQL Integrity Constraints?
• What are the different types of SQL Constraints or SQL Integrity Constraints?
• What is Database Table?
• What is View?
• What is the need for a SQL view?
• What are the different types of SQL Server Views?
• What is Simple View and Complex View?
• What is a transaction?
• Why use transactions in SQL Server?
• What are the different types of transactions in SQL Server?
• What are implicit and explicit transactions in SQL Server?
• How to use an explicit transaction in SQL Server?

SQL Statements

• What are SQL Joins?
• What are the different types of SQL Joins?
• Describe each type of SQL Join?
• What is Self-Join?
• What is the difference between inner join and equi-join?
• What is Natural Join?
• How Group by and Having Clause are related to each other?
• What is Rollup operator in SQL Server?
• What are SQL injection attacks?
• What are the recommended solutions to stop SQL Injection Attacks?

Functions, Procedures, and Exceptions

• What is the SQL function?
• What are the different types of SQL Server functions?
• What are the System Defined functions?
• What is a User-Defined function?
• What are the limitations of SQL function?
• What are the stored procedures?
• What are the different types of SQL Server stored procedures?
• What are the limitations of SQL Server stored procedure?
• What is the difference between Stored Procedure and Function in SQL Server?
• What is stored procedure plan recompilation and performance tuning?
• What are various ways to recompile the Stored Procedure?
• What is Exception?
• What are the different types of exceptions in SQL Server?
• What is a statement-level exception in SQL Server?
• What is a batch-Level exception in SQL Server?
• What is Parsing and Scope-Resolution exception in SQL Server?
• How to try…catch works in SQL Server?
• What are the limitations of try…catch in SQL Server?
• What are the different error functions used in SQL Server for error handling?
• What is the case expression in SQL Server?
• What are the different ways to write case expressions in SQL Server?
• When to use case expression in SQL Server?

Triggers and Tables

• What are the triggers?
• Write syntax to create a trigger in SQL Server?
• What are the different types of triggers in SQL Server?
• What are DDL triggers in SQL Server?
• What are DML triggers in SQL Server?
• What are the different types of DML triggers in SQL Server?
• What are CLR triggers in SQL Server?
• What are Logon triggers in SQL Server?
• What are the limitations of triggers in SQL Server?
• What are different ways for setting triggers firing order in SQL Server?
• What are the logical tables in SQL Server?
• What are inserted and deleted logical tables in SQL Server?
• When Inserted and Deleted Logical table are used in SQL Server?
• What is CTE (Common Table Expressions) in SQL Server?
• What are temporary tables?
• What are the different types of temporary tables?
• What is the table variable?
• What is a local and global variable in SQL Server?

Cursors and Indexes

• What is the cursor?
• Explain the life cycle of the cursor in SQL Server?
• What are the different types of Cursor in SQL Server?
• What is a Static Cursor in SQL Server?
• How to write a Static Cursor in SQL Server?
• What are the limitations of a Static Cursor in SQL Server?
• What is Dynamic Cursor in SQL Server?
• How to write a Dynamic Cursor in SQL Server?
• What is Forward Only Cursor in SQL Server?
• How to write a Forward only Cursor in SQL Server?
• What is Keyset-Driven Cursor in SQL Server?
• How to write a Keyset-driven Cursor in SQL Server?
• What are SQL Server cursor alternatives?
• How XML data type works in SQL Server?
• What are the limitations of the XML data type in SQL Server?
• What are the various ways for querying XML data?
• What is an index?
• What are the advantages of the index?
• What are the different types of indexes?
• What is a Clustered index?
• What is a Non-Clustered index?
• What is a full-text search in SQL Server?

References: Microsoft Docs – Sql Server, Stack Overflow – SQL Server

The post Interview Questions on SQL Server appeared first on DotNetTec.