Explain boyce and codd normal form(bcnf)?

1019

---

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

1021

---

In what version of sql server were synonyms released?

1003

---

What are the aggregate and scalar functions?

1143

---

What is the need for group functions in sql?

1162

---

What is the difference between varchar and varchar types?

1135

---

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

1053

---

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

1202

---

What is the difference between local and global temporary tables?

1217

---

What is bcp? When does it use?

994

---

What is the osql utility?

1044

---

Explain the steps needed to create a scheduled job?

985

---

What are the types of joins in sql?

1181

---

What are orphan records?

990

---

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

1085

---