Interview Questions Answers in SQL Server

ramesh l.v.

{ City } chennai
< Country > india
* Profession * dba
User No # 6212

Total Questions Posted # 0
Total Answers Posted # 3

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 44
Users Marked my Answers as Wrong # 2

Questions / { ramesh l.v. }

Questions Answers Category Views Company eMail

Answers / { ramesh l.v. }

Question { HCL, 10651 }

How to determine the service pack currently installed on
SQL Server?

Answer

SELECT SERVERPROPERTY('PRODUCTLEVEL')

Is This Answer Correct ?

15 Yes

0 No

Question { 13925 }

what is curser.

Answer

Cursor is a database object used by applications to
manipulate data in a set on a row-by-row basis.

Is This Answer Correct ?

12 Yes

1 No

Question { TCS, 18579 }

wht is normalization?can u explain me in detail?

Answer

Normalization is the process of efficiently organizing data
in a database. There are two goals of the normalization
process: eliminating redundant data and ensuring data
dependencies make sense

Is This Answer Correct ?

17 Yes

1 No