Differentiate between truncate vs delete in mssql?
How are the exceptions handled in sql server programming?
Mention the uses of stored procedures.
What is the difference between left and right outer join?
Explain the commands in sql server?
Write an sql query for deleting duplicate rows?
What is difference between clustered index and non clustered index?
Write query to return all rows sql?
What is difference between foreign key and unique key?
State the difference between union and union all?
What do you understand by recursive stored procedures?
What are the different types of nosql databases? Give some examples.
What do you mean by a replica set in mongodb?
Write the syntax for creating a collection and dropping a collection in mongodb.
List some alternatives to mongodb?