Answer Posted / p.chella vijaya

select top 5 (salary) from emp order by desc

Explain phantom deadlock?

1241

---

What is a database connection string?

1126

---

What is a trace file?

1080

---

How many types of locks are present in a database?

1134

---

What do you mean by cluster and non cluster index?

1079

---

Explain the record term used in database.

1084

---

On startup, the transaction log of a database has filled and recovery has suspended, what can I do?

1000

---

What is the difference between specialization and generalization?

1032

---

What will happen non-clustered index will be created on clustered index?

1047

---

What is a sequence? Explain it with one example?

1196

---

Is storing images in a database a good idea?

1000

---

How does database replication work?

1005

---

How many indexes can be created on a table?

1154

---

How to do Stored procedure testing? Who does this testing (Developer or tester)?

1823

---

What is the role of tester in discovery(in Checklist)?

1972

---