Which of the following commands is used to change the structure of table?

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

What is the maximum value that can be stored for a datetime field?

How can you view the structure of a table named 'myTable' in SQL Server?

What does referential integrity (also called relational integrity) prevent?

Which of the following is not a global variable?

Is it possible to insert several rows into a table with a single INSERT statement?

Is the FROM clause necessary in every SELECT statement?

You want to display the titles of books that meet the following criteria: 1. Purchased before November 11, 2002 2. Price is less than $500 or greater than $900 You want to sort the result by the date of purchase, starting with the most recently bought book. Which of the following statements should you use?

The simplest query must include at least________ and _________?

What is the order of precedence among the following operators? 1. IN 2. NOT 3. AND 4. OR