Consider the following queries:

1. select * from employee where department LIKE "[^F-M]%";
2. select * from employee where department = '[^F-M]%';

Select the correct option:

What is the correct SQL syntax for returning all the columns from a table named 'Persons' sorted REVERSE alphabetically by 'FirstName'?

Which of the following is not a valid character datatype in SQL Server?

The sales database contains a customer table and an order table. For each order there is one and only one customer, and for each customer there can be zero or more orders. How should primary and foreign key fields be placed into the design of this database?

What is the correct SQL syntax for selecting all the columns where the 'LastName' is alphabetically between (and including) 'Hansen' and 'Pettersen'?

Which of the following constraints can be used to enforce the uniqueness of rows in a table? 

Which of the following datatypes is not supported by SQL-Server?

Is the following statement true or false? A column that allows NULLs requires more space to store a value.

The IF UPDATE (column_name) parameter in a trigger definition will return TRUE in case of an INSERT statement being executed on the triggered table:

What will happen if you query the emp table as shown below: select empno, DISTINCT ename, Salary from emp;

Sample Code CREATE TABLE table1( column1 varchar(50), column2 varchar(50), column3 varchar(50), column4 varchar(50)); Which one of the following is the correct syntax for adding the column named 'column2a' to the table shown above?