Explain boyce and codd normal form(bcnf)?
How important do you consider cursors or while loops for a transactional database?
In what version of sql server were synonyms released?
What are the aggregate and scalar functions?
What is the need for group functions in sql?
What is the difference between varchar and varchar types?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What is the difference between coalesce() & isnull()?
What is the difference between local and global temporary tables?
What is bcp? When does it use?
What is the osql utility?
Explain the steps needed to create a scheduled job?
What are the types of joins in sql?
What are orphan records?
What have included columns when we talk about sql server indexing?