Explain boyce and codd normal form(bcnf)?

1019

---

How important do you consider cursors or while loops for a transactional database?

1017

---

In what version of sql server were synonyms released?

1003

---

What are the aggregate and scalar functions?

1138

---

What is the need for group functions in sql?

1162

---

What is the difference between varchar and varchar types?

1127

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

1047

---

What is the difference between coalesce() & isnull()?

1198

---

What is the difference between local and global temporary tables?

1202

---

What is bcp? When does it use?

994

---

What is the osql utility?

1040

---

Explain the steps needed to create a scheduled job?

985

---

What are the types of joins in sql?

1175

---

What are orphan records?

988

---

What have included columns when we talk about sql server indexing?

1083

---