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 # 131779

Users Marked my Answers as Correct # 294
Users Marked my Answers as Wrong # 119
Answers / { harichandra prasad }

Question { IBM, 8330 }

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 { 7057 }

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 { 5497 }

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, 20424 }

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]