Explain boyce and codd normal form(bcnf)?

971

---

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

981

---

In what version of sql server were synonyms released?

953

---

What are the aggregate and scalar functions?

1083

---

What is the need for group functions in sql?

1098

---

What is the difference between varchar and varchar types?

1082

---

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

1012

---

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

1148

---

What is the difference between local and global temporary tables?

1151

---

What is bcp? When does it use?

954

---

What is the osql utility?

989

---

Explain the steps needed to create a scheduled job?

951

---

What are the types of joins in sql?

1141

---

What are orphan records?

942

---

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

1048

---