What are the different authentication modes in sql server?
Can sql servers link to other servers?
Describe how to use the linked server?
What are transactions in sql?
Explain the third normal form(3nf)?
What are the different types of collation sensitivity?
List out the differences between global and local temp tables in sql server?
Explain “@@rowcount” and “@@error” in sql server?
What are the different types of join?
Why are sql functions used?
Explain mixed authentication mode of sql server?
How can you insert null values in a column while inserting the data?
Is it possible to update the views? If yes, how, if not, why?
What are the difference between “where” and “having” clause in sql server?
What the different components in replication and what is their use?