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.

You have a table 'engineers' with the following table structure: enggid int(4) deptname varchar(50) salary int(4) You want to display the minimum and maximum salaries of the individual departments. Which of the following queries will fetch the desired results?

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?

The ________ data type can be used to store values of different data types at the same time, including numeric values, strings, and date values.