Home
|
Articles
|
Tutorials
|
Namespace
|
Interview Questions
|
Tools
|
Jobs
|
Projects
|
Community
»Dotnet Ads
»Message Boards
Message Boards
Dotnet Books
»Member Details
Register
Login
LogOut
Submit Code
Submit Jobs
Submit Projects
»Competition
Community
Winners
Prizes
Write For Us
Members
»Other Resources
Links
Dotnet Resources
SQl server interview questions
Post Question
If you know the answers to the below questions please answer
1
What is the difference between Delete and Truncate statements?
(
Answered
)
2
Difference between Clustered and non-clustered index
(
Answered
)
3
What is the difference between unique and primary key constraint?
(
Answered
)
4
What is the difference between isnull and coalesce?
(
Answered
)
5
What is normalization and denormalization in sql?
(
Answered
)
6
What is difference between after and instead of trigger in sql?
(
Answered
)
7
How can i check the table is having an index or not?
(
Answered
)
8
What is the difference between function and stored procedure?
(
Answered
)
9
What is the difference between trigger and stored procedure?
(
Answered
)
10
Does the original table get affected if we update a view?
(
Answered
)
11
What is function and types of function?
(
Not Answered
)
12
What is the use @@identity in sql?
(
Answered
)
13
What is the use of stored procedure in sql?
(
Answered
)
14
What is stored procedure?
(
Answered
)
15
What is leftouter and right outer join?
(
Answered
)
16
What is inner join?
(
Answered
)
17
what is eqi-join and non-eqijoin in sql?
(
Answered
)
18
What are the types of join in sql?
(
Answered
)
19
How many indexes does a table can have?
(
Answered
)
20
How can i take the database backup using sql 2000?
(
Not Answered
)
21
What are the types of database backup in sql?
(
Not Answered
)
22
What is the difference between sql 2000 and sql 2005
(
Not Answered
)
23
What is the condition for creating indexed views in sql?
(
Not Answered
)
24
What are the constraints are used in sql?
(
Answered
)
25
What is rule in sql?
(
Not Answered
)
26
What is Default in sql?
(
Answered
)
27
What is indexed view in sql?
(
Not Answered
)
28
What is the difference between delete and truncate?
(
Answered
)
29
what is Indexing?
(
Answered
)
30
What is a cluster ?
(
Answered
)
© 2005 dotnetwatch.com --
Privacy policy