How to automatically create a log when an exception is being received into SQL Server?

1289

---

How to use clusters?

945

---

What to check if a User database is locked?

1071

---

Explain what is meant by replication of database?

1032

---

How to add additional conditions in SQL?

1022

---

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

1049

---

What advantages does DBMS have over traditional file systems?

1035

---

Explain inner and outer joins with examples.

1176

---

Explain various types of locks in a transaction? Which is better and why?

1035

---

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

1677

---

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

1047

---

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

1078

---

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

1466

---

For each user who needs access, the DBA creates an account in which database?

1203

---

In oracle there is column command, how will you explain that?

1055

---