SQL Server 2014 Interview Question

SQL Server 2014 Interview Question

• What is SQL Server TCP/IP port? How to change SQL Server port?
• Difference between Clustered and non-Clustered index
• Define OLTP or Explain OLTP or What is OLTP
• What is Collation in SQL Server? Different types of Collation
• What is difference between Primary Key and Foreign Key
• What is difference between Delete and Truncate
• How many ways to remove all data from a database table? Explain difference between all of them
• What are properties?
• What is UPDATE_STATISTICS?
• Explain difference between HAVING CLAUSE and WHERE CLAUSE
• What is Sub Queries? Types of sub-queries?
• Explain different authentication mode in SQL Server? How to Enable or disable it ?
• How to find the accurate count of a database table ?
• What is Primary Key ?
• What is Unique Key?
• What is FOREIGN KEY?
• What is CHECK Constraint ?
• Explain NOT NULL Constraint ?
• How to handle Error in SQL Server ?
• What is SQL Server agent? How to use it ?
• What is SQL Server Profiler ? How to use it ?
• What is a Scheduled Tasks? How to Scheduled a Job
• What is linked Server?
• How to connect SQL Server with other database
• What is Execution Plan? How to check Execution Plan ? When to use Execution Plan?
• Types of Execution Plan? Explain difference between them?
• Explain difference between Estimate Execution Plan and Actual Execution Plan
• What is Log Shipping?
• How to check SQL Server Version?
• TSQL Command to find operating System of SQl Server
• What is QUOTED_IDENTIFIER and How to use it?
• How to insert data in a Identity Column
• Explain temp table in SQL Server? Different types of temp table
• You created a temp table in SQL Server. Where you can find this temp table?
• What is Stored Procedure in SQL Server ?
• Advantages of using Stored Procedures?
• Difference between SQL Server Function and SQl Server Stored Procedure
• What is BCP? When does it used?
• What is Cardinality? How to implement it while design phase?
• What is one to one, one to many and many to many relationships? How to implement in SQL Server?
• What is IDENTITY INSERT? How to enable and disable Identity Insert in SQL Server
• Can a user define function call itself ? If Yes how many times ?
• Can a stored procedure call itself ? If Yes how many times ?
• How to rename objects in SQL Server ?
• Is it possible o rename SQL server database ? If yes how to rename ?
• How to manipulate text in SQL Server ?
• How to delete duplicate records from SQL Server database table?
• What is GO command ?
• What is Dynamic SQL Command ? How to create dynamic SQL Command and Execute It?
• What is Synonyms in SQL Server?