.Net Questions Part--10

Posted Date: 13 Sep 2009	Resource Type: Articles	Category: Visual Studio
Author: datta gunturu	Member Level: Gold
Rating:	Points: 10

Hi Friends,
This part is relaetd to
SQL SERVER

What is normalization? What are different type of normalization?
What is denormalization ?
What is a candidate key ?
What are different types of joins and whats the difference between them ?
What are indexes and What is the difference between clustered and nonclustered indexes?
How can you increase SQL performance ?
What is the use of OLAP ?
What's a measure in OLAP ?
What are dimensions in OLAP ?
What are levels in dimensions ?
What are fact tables and dimension tables in OLAP ?
Twist :- can you explain the star schema for OLAP ?
What is DTS?
What is fillfactor ?
Twist :- When does plage split occurs ?
What is RAID and how does it work ?
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
What are the problems that can occur if you do not implement locking properly in SQL SERVER ?
What are different transaction levels in SQL SERVER ?
Twist :- what are different types of locks in SQL SERVER ?
What are different locks in SQL SERVER ?
Can we suggest locking hints to SQL SERVER ?
What is LOCK escalation?
What are the different ways of moving data/databases between servers and databases in SQL Server?
What are advantages of SQL 2000 over SQl 7.0 ?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
What is difference between UNION and UNION ALL SQL syntax ?
How can you raise custom errors from stored procedure ?
What is ACID fundamental and what are transactions in SQL SERVER ?
What is DBCC?
What is purpose of Replication ?
What are different type of replication supported by SQL SERVER ?
What is BCP utility in SQL SERVER ?
What are different types of triggers in SQl SERVER 2000 ?
If we have multiple AFTER Triggers on table how can we define the sequence of the triggers ?
What is SQl injection ?
What’s the difference between Stored Procedure (SP) and User Defined Function (UDF)?

Thanks & Regards,
Datta.G
Jr. Software Engg.

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

.Net Questions Part--10 .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: .Net Questions Part--9
	Previous Resource: Difference between Web Site And Web Application
	Return to Discussion Resource Index
	Post New Resource
	Category: Visual Studio

Post resources and earn money!

More Resources