What exactly is a Foreign key?

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

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 one of the following statements regarding 'views' is incorrect?

What will the following query do? Delete Orders

The - (Negative) and ~(Bitwise NOT) are examples of the _________ type of operators.

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?

You can create index on views.

What does COALESCE do?

Which transaction isolation level allows dirty reads?

Which of the following SQL Server 2012 date functions return a value of date and/or time data type from the given parts?