Top 100 SQL Server Interview Questions for experience professionals

Question 1: What are the two authentication modes in SQL Server?

Question 2: What is a recursive stored procedure?

Question 3: Can SQL Servers linked to other servers?

Question 4: What Is SQL Profiler?

Question 5: What are the differences between local and global temporary tables?

Question 6: What is the CHECK constraint?

Question 7: What is COALESCE in SQL Server?

Question 8: What are scheduled tasks in SQL Server?

Question 9:What is SQL server agent?

Question 10: What are subquery and their properties?

Question 11: What are the types of subquery?

Question 12: How exceptions can be handled in SQL Server Programming?

Question 13: What is an IDENTITY column in insert statements?

Question 14: What is the difference between UNION and UNION ALL?

Question 15: What are the differences between Stored Procedure and dynamic SQL?

Question 16: What is Collation?

Question 17:How can we get a count of the number of records in a table?

Question 18: How Global temporary tables are represented and their scope?

Question 19: What will be the maximum number of indexes per table?

Question 20: What is the command used to get the version of SQL Server?

Question 21: What is the use of SET NOCOUNT ON/OFF statement?

Question 22: Which SQL server table is used to hold the stored procedure scripts?

Question 23: What is UPDATE_STATISTICS command?

Question 24: Where are SQL Server user names and passwords stored in SQL Server?

Question 25: How to delete duplicate rows in SQL Server?

Question 26: What is the difference between GETDATE and SYSDATETIME?

Question 27: How data can be copied from one table to another table?

Question 28: Which command is used for user defined error messages?

Question 29: What is TABLESAMPLE?

Question 30: What do mean by XML Datatype?

Question 31: What is the purpose of FLOOR function?

Question 32: Can we check locks in database? If so, how can we do this lock check?

Question 33:What is the command used to Recompile the stored procedure at run time?

Question 34: What are the methods used to protect against SQL injection attack?

Question 35: What is CDC?

Question 36: What is SQL injection?

Question 37: What is Filtered Index?

Question 38: How to create a database in SQL Server?

Question 39: What is the use of SIGN function?

Question 40: What is a Trigger?

Question 41:What are the types of Triggers?

Question 41: What is Bulkcopy in SQL?

Question 42: What will be query used to get the list of triggers in a database?

Question 43: What are Magic Tables in SQL Server?

Question 44: What is the difference between SUBSTR and CHARINDEX in the SQL Server?

Question 45: How can you create a login?

Question 46: What is ISNULL() operator?

Question 47: What is the use of FOR Clause?

Question 48:What is the difference between COMMIT and ROLLBACK?

Question 49: What is the difference between varchar and nvarchar types?

Question 50: What is the use of @@SPID?

Question 51: What is the difference between SQL and PL/SQL?

Question 52: What is RDBMS?

Question 53: What is a database table?

Question 54: How to delete a table in SQL Server?

Question 55: How do you create a table in SQL?

Question 56: How to update a SQL Server database table using SQL?

Question 57: What are relationships in SQL Server database?

Question 58: What is the primary key of a database?

Question 59: What is a foreign key of a database?

Question 60: What is database normalization?

Question 61: What are database normalization forms?

Question 62: What is a stored procedure?

Question 63: What is a function in SQL Server?

Question 64: What are the different types of functions in SQL Server?

Question 65: What is a trigger in SQL Server?

Question 66: Why and when to use triggers?

Question 67: What are the different types of triggers?

Question 68: What is a view in the database?

Question 69: What is an index?

Question 70: What are DDL, DCL, DML, and TCL commands in SQL Server?

Question 71: What is the difference between Clustered and Non-Clustered Indexes?

Question 72: Why do we need indexes in a database?

Question 72: What is inner, outer, full and self joins?

Question 74: What is the database engine in SQL Server?

Question 75: What are the main differences between function and stored procedure in SQL Server ?

Question 76: What is collation sensitivity in SQL Server and what are difference types ?

Question 77: What is the standby server?

Question 78: What is the difference between HAVING and WHERE CLAUSE in SQL Server?

Question 79: How can you hide the SQL Server instances?

Question 80: In which TCP/IP port does SQL Server run? How it Can be changed?

Question 81: What is the DBCC command and why is it used?

Question 82: Write a query to rename a database?

Question 83: Can SQL Server be linked with other Servers like Oracle?

Question 84: What is the difference between abstract and interface?

Question 85: What is the difference between the application object and session object?

Question 86: What is the Boxing and Unboxing concept in .net?

Question 87: What is parameter sniffing in SQL Server?

Question 88: What is the difference between GET and POST methods?

Question 89: How to clear log files in SQL Server?

Question 90: What are the common performance improvement techniques in SQL Server?

Question 91: What is the use of the FLOOR function in SQL Server?

Question 92: What are the transactions in SQL Server?

Question 93: How to create a proxy account in SQL Server?

Question 94: How to schedule a SQL Agent job and associate with the SSIS package?

Question 95: How to implement Slowly Changing Dimensions in SQL Server?

Question 96: What are the differences between SUBSTR and CHARINDEX in SQL Server?

Question 97: What is Cover Index in SQL Server?

Question 98: What is the Execution plan and how to evaluate the performance using the same?

Question 99: What is an indexed view in SQL Server?

Question 100: What are the Ranking functions and why do we use them?

                                                                                                                                            Next page >>