Answer Posted / sri

Experience

what stored procedure can you use to display the current processes? : Sql server administration

528

---

What command is used to rename the database?

523

---

Tell me the difference between clustered and non-clustered index?

503

---

How can we rewrite sub-queries into simple select statements or with joins?

519

---

List the advantages of using stored procedures?

556

---

---

How would you add a section to a table?

562

---

Do you know what are the properties of the relational tables?

570

---

How to find the service pack installed? : sql server database administration

544

---

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

555

---

Mention the differences between local and global temporary tables.

558

---

Explain trigger classes i.e. Instead of and after trigger?

481

---

What do you understand by integration services in sql server?

541

---

what is database replication? : Sql server database administration

526

---

Define left outer join?

573

---

Do you know what is sql injection?

537

---