Answer Posted / valarmathi

'like' operator

How do you test your database? : sql server database administration

527

---

Explain rdbms?

607

---

What is indexed view?

604

---

What is the correct order of the logical query processing phases?

527

---

Which Model uses the SET concept

586

---

---

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

705

---

How are the exceptions handled in sql server programming?

611

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

554

---

Give me any three differences between Truncate and Delete.

575

---

Why I have to use stored procedures?

600

---

What are the difference between “where” and “having” clause in sql server?

589

---

What is lookup override?

590

---

What is the downside of using udf?

566

---

What is the return type of executeupdate ()?

527

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

527

---