What to check if a User database is locked?

1117

---

Explain what is meant by replication of database?

1108

---

How to add additional conditions in SQL?

1071

---

What is the optimization being performed in oracle and SQL Server?

1100

---

write an SQL query to list the employees who joined in the month of January?

1744

---

Is BCNF better than 2NF & 3NF? Why?

1106

---

Write an SQL query to obtain the 2nd highest salary.

1128

---

Explain various On-Delete options in a DB table. Which is the default option?

1536

---

Benefits of Stored Procedures?

1048

---

What are the advantages to use stored procedures?

1184

---

What is SQL Server?

1277

---

How can we improve performance by using SQL Server profiler?

1109

---

How do you send email on SQL Server?

1121

---

How to concatenate two strings in SQL Server.

1214

---

In which format does an image save in SQL Server database ?

1061

---