Answer Posted / yash

The default value of a variable of value type is the value
assigned in the default constructor. For simple types this
value corresponds to a bit pattern of all zeros:
• For integer types, the default value is 0
• For char, the default value is `\u0000' //Unicode
• For float, the default value is 0.0f
• For double, the default value is 0.0d
• For decimal, the default value is 0.0m
• For bool, the default value is false

What is nonclustered index with included columns ?

969

---

Do you know what is sql injection?

1004

---

What is reference section?

1009

---

Can group functions be used in the order by clause in ms sql server?

1017

---

Does full backup break log chain?

970

---

What is meant by dirty read?

997

---

What are the approximate numeric data types?

942

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

984

---

How does normalization work?

926

---

What is a virtual table in sql?

1000

---

What is indexing explain it with an example?

1014

---

What are the triggers in sql?

1107

---

What is optimistic concurrency?

1040

---

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1080

---

Tell me what is normalization? Explain different forms of normalization?

1031

---