Here you can find SQL Server Interview Questions and Answers.
In this SQL Server Interview Questions and Answers section you can learn and practice SQL Server Interview Questions and Answers to improve your skills in order to face technical inerview by IT companies. By Practicing these interview questions, you can easily crack any SQL Server interview.
AllIndiaExams provides you lots SQL Server Interview Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students, freshers can download SQL Server Interview Questions and Answers as PDF files and eBooks.
You no need to worry, we have given lots of SQL Server Interview Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the SQL Server technical interview.
What is Sql server?
SQL - Structured query language is the standard command set used to communicate with the relational database management system. Sql server - is commonly used as the backend system for websites and corporate CRMs and can support thousands of concurrent users.SQL Server is much more robust and scalable than a desktop database management system such as Microsoft Access.
What are the System Database in Sql server 2005?
Master - Stores system level information such as user accounts, configuration settings, and info on all other databases. Model - database is used as a template for all other databases that are created Msdb - Used by the SQL Server Agent for configuring alerts and scheduled jobs etc Tempdb - Holds all temporary tables, temporary stored procedures, and any other temporary storage requirements generated by SQL Server.
What is the difference between TRUNCATE and DELETE commands?
TRUNCATE is a DDL command whereas DELETE is a DML command. Hence DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back. WHERE clause can be used with DELETE and not with TRUNCATE.
What is OLTP?
Online Transaction Processing (OLTP) relational databases are optimal for managing changing data. When several users are performing transactions at the same time, OLTP databases are designed to let transactional applications write only the data needed to handle a single transaction as quickly as possible.
Normalisation is an essential part of database design. A good understanding of the semantic of data helps the designer to built efficient design using the concept of normalization.
What are the difference between clustered and a non-clustered index?
A Clustered index is a special type of index that reorders the way in which each records in the table are physically stored. A Non clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk.
What are the System Database in Sql server 2008?
Master Model Msdb Tempdb Resource
What are the different locks in Sql Server?
Intent Shared Update Exclusive Schema Bulk Update
What are the different types of Sub-Queries?
Single row subquery Multiple row subquery Correralted row subquery
What are constraints? Explain different types of constraints?
Constraints is a rule or restriction concerning a piece of data that is enforced at the data level. A Constraint clause can constrain a single column or group of columns in a table. There are five types of Constraint namely Null / Not Null Primary Key Unique Check or Validation Foreign Key or References Key