SQL Server Interview Questions and Answers
- What is RDBMS?
- What are the Properties of the Relational Tables?
- What is Normalization?
- What is De-normalization?
- How is ACID property related to Database?
- What are the Different Normalization Forms?
- What is a Stored Procedure?
- What is a Trigger?
- What are the Different Types of Triggers?
- What is a View?
- What is an Index?
- What is a Linked Server?
- What is a Cursor?
- What is Collation?
- What is the Difference between a Function and a Stored Procedure?
- What is subquery? Explain the Properties of a Subquery?
- What are Different Types of Join?
- What are Primary Keys and Foreign Keys?
- What is User-defined Functions? What are the types of User-defined Functions that can be created?
- What is an Identity?
- What is DataWarehousing?
- What languages BI uses to achieve the goal?
- What is Standby Servers? Explain Types of Standby Servers.
- What is Dirty Read?
- Why can’t I use Outer Join in an Indexed View?
- What is the Correct Order of the Logical Query Processing Phases?
- Which Command using Query Analyzer will give you the Version of SQL Server and Operating System?
- What is an SQL Server Agent?
- Can a Stored Procedure call itself or a Recursive Stored Procedure? How many levels of SP nesting is possible?
- What is Log Shipping?
- Name 3 ways to get an Accurate Count of the Number of Records in a Table?
- What does it mean to have QUOTED_IDENTIFIER ON? What are the Implications of having it OFF?
- What is the Difference between a Local and a Global Temporary Table?
- What is the STUFF Function and How Does it Differ from the REPLACE Function?
- What is PRIMARY KEY?
- What is UNIQUE KEY Constraint?
- What is FOREIGN KEY?
- What are the basic functions for master, msdb, model, tempdb and resource databases?
- What is the Maximum Number of Index per Table?
- Explain Few of the New Features of SQL Server 2008 Management Studio
- Explain IntelliSense for Query Editing
- Explain MultiServer Query
- Explain Query Editor Regions
- Explain Object Explorer Enhancements
- Explain Activity Monitors
No comments:
Post a Comment