SQL Server Interview Questions and Answers
Here you can find SQL Server Interview Questions and Answers.
Why SQL Server Interview Questions and Answers Required?
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.
Where can I get SQL Server Interview Questions and Answers?
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.
How to solve these SQL Server Interview Questions and Answers?
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.
SQL Server Interview Questions and Answers
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.
SQL Server Interview Questions and Answers
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.
SQL Server Interview Questions and Answers
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.
SQL Server Interview Questions and Answers
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.
SQL Server Interview Questions and Answers
Define Normalisation?
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.
SQL Server Interview Questions and Answers
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.
SQL Server Interview Questions and Answers
What are the System Database in Sql server 2008?
Master
Model
Msdb
Tempdb
Resource
SQL Server Interview Questions and Answers
What are the different locks in Sql Server?
Intent
Shared
Update
Exclusive
Schema
Bulk Update
SQL Server Interview Questions and Answers
What are the different types of Sub-Queries?
Single row subquery
Multiple row subquery
Correralted row subquery
SQL Server Interview Questions and Answers
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