What is the order of precedence among the following operators?

1. IN

2. NOT

3. AND

4. OR

The simplest query must include at least________ and _________?

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?

Is the FROM clause necessary in every SELECT statement?

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

Which line of code should you use to copy the edited rows from dataset productInfo into another dataset productChanges?

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

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

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

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 commands is used to change the structure of table?