What does COALESCE do?

You can create index on views.

Consider the following queries: A: select * from [tbl1] union select * from [tbl2]; B: select * from [tbl1] union all select * from [tbl2]; What is the difference between these two queries?

Which of the following statements will remove a UDF?

What is the default isolation level in SQL Server?

What is the basic difference between varchar and nvarchar?

A table of employees has the following values for its salary field: 10000, 11000, 12000, 10000, 14000, 12000, 13000, 10000, 14000, 10000 What will the following query return? Select distinct (salary) from employees

Which of the following statements regarding Trigger and Stored Procedures is correct?

What exactly is a Foreign key?

State whether True or False. The 'Having' clause can not be used when there is a 'Where' clause in the statement already.

State whether True or False. You can send emails through the Database engine.