1. What are the different types of Joins?
Joins can be categorized as:
Inner joins - (the typical join operation, which
Equi Join - It returns all the columns in both
( SELECT * FROM authors AS a INNER JOIN
Self Join - A table can be joined to itself
Outer joins - Outer joins can be a left,
LEFT JOIN or LEFT OUTER JOIN -
RIGHT JOIN or RIGHT OUTER JOIN -
FULL JOIN or FULL OUTER JOIN -
Cross joins - Cross joins return all rows from
2. What is diff. between left and Right
3. Why we use Unicode In Sql server?
Unicode data is stored using the nchar, nvarchar,
4.What is Fill Factor and its value when the
A fill factor value of 0 does not mean that
5.What are the different types of Filebackup
Rules of Files and Filegroups
Types of BackUP
6.What is Differential File group backup?
7.What is Collate?
8. What is Code Page?
9.When we should go for with Recompile option in
10.What is difference between Having and Group
Where – Groupby – Having – Order By
11.What are Isolation levels?
Read Committed -
Read Uncommitted -
Repeatable Read or Serializable -
12.When should we go for NOLOCK hint?
14.Diff. between BCP and DTS, which one is
DTS allows the user to program transformations
BCP is extremely fast and has a minimal overhead,
15.What are DBCC COMMANDS?
DBCC dllname (FREE)
16.What are System Stored Procedures?
17.Can we prefix user defined SP's with sp_, if so
Therefore, although the user-created stored procedure
18. What are Indexes?
The two types of SQL Server indexes are:
The only time the data rows in a table are stored in
19.When will we go for clustered and
•Searches for rows with search key values in a
•Searches for rows in a table T1 that match, based
•Produces sorted query output without an explicit
•Scans rows in a sorted order to permit an
•Scans all rows in a table with better performance than
•Searches for matching rows between two tables
•Columns that contain a high number of distinct values,
•Queries that do not return large result sets.
•Columns frequently involved in search conditions
•Decision Support System applications for which
•Columns that contain a limited number of distinct
•Queries that return a range of values using operators
•Columns that are accessed sequentially.
•Queries that return large result sets.
•Columns that are frequently accessed by queries
•OLTP-type applications where very fast single
Clustered indexes are not a good choice for:
•Covered queries. The more columns within the
20. What is Referential Integrity?
When you enforce referential integrity, SQL Server
Adding records to a related table if there
Changing values in a primary table that result
Deleting records from a primary table if there
21.What are the Features of Normalized and
23.Union and Union ALL, which will give better
24.What is the Diff. between drop and detach database?
A database that has been dropped can be re-created
25.What are Instead of Triggers?