Interview Questions Answers in SQL Server, DB Administration

harichandra prasad

{ City } bangalore
< Country > india
* Profession * se
User No # 15667

Total Questions Posted # 20
Total Answers Posted # 19

Total Answers Posted for My Questions # 38
Total Views for My Questions # 149983

Users Marked my Answers as Correct # 294
Users Marked my Answers as Wrong # 119

Answers / { harichandra prasad }

Question { Emphasis, 10207 }

What are the different types of backup avaible in SQL SErver

Answer

Full Backup
Differential backup
Transcational log backup

Is This Answer Correct ?

18 Yes

2 No

Question { 9296 }

what is difference between primary key and Unique

Answer

Primary key : Doen't allow null values
Unique key : allow one null value
Primary key create cluster index
Unique Key create non-cluster index

Is This Answer Correct ?

3 Yes

0 No

Question { 6876 }

what is cluster and nin-cluster index?

Answer

cluster Index create leaf level of (actul data) data.
Non-cluster Index create pointer level of data.

Is This Answer Correct ?

4 Yes

0 No

Question { 247Customer, 22406 }

How many types of cursors are there in SQL Server?

Answer

Cursor : Curosr is allow row processing of the result set.
Static
Dynamic
forward-only
Key setdriven

Is This Answer Correct ?

16 Yes

3 No

Prev 1 [2]