Answer Posted / siddharthapenchala

select scn_to_timestamp(max(ora_rowscn)) from <TN>

Tell me what is difference between clustered and non clustered index?

944

---

What methods do you follow to protect from sql injection attack?

1023

---

How can you set the threshold at which sql server will generate keysets asynchronously?

985

---

What options are available to audit login activity? : sql server security

1149

---

What is the command to change the recovery model?

1045

---

What is ms sql server triggers?

1010

---

Explain table valued parameters in sql server? Why tvp used?

1019

---

Does server sql treat char as a variable-length or fixed-length column?

1023

---

Explain Normalization and DE normalization

1108

---

What does the update command do?

1111

---

What are the export options of ssrs?

173

---

What stored by the master?

948

---

What is the difference between a local and a global temporary table?

1114

---

What is importing utility?

982

---

what data regions are and what are the different data regions?

141

---