What to check if a User database is locked?

1030

---

Explain what is meant by replication of database?

973

---

How to add additional conditions in SQL?

985

---

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

1010

---

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

1639

---

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

1015

---

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

1032

---

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

1419

---

Benefits of Stored Procedures?

937

---

What are the advantages to use stored procedures?

1052

---

What is SQL Server?

1162

---

How can we improve performance by using SQL Server profiler?

1005

---

How do you send email on SQL Server?

1017

---

How to concatenate two strings in SQL Server.

1100

---

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

958

---