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?

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

You create an ASP.NET page named ProjectCalendar.aspx that shows scheduling information for projects in your company. The page is accessed from various other ASP and ASP.NET pages hosted throughout the company's intranet. All employees on the intranet use Internet Explorer. ProjectCalendar.aspx has a Calendar control at the top of the page. Listed below the Calendar control is detailed information about project schedules on the data selected. When a user selects a date in the calendar, the page is refreshed to show the project schedule details for the newly selected date. Users report that after viewing two or more dates on ProjectCalendar.aspx, they need to click the browser's Back button several times in order to return to the page they were viewing prior to accessing ProjectCalendar.aspx. You need to modify ProjectCalendar.aspx so that the users need to click the Back button only once. What to do?

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

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

Which query will display data from the Pers table relating to Analysts, clerks and Salesmen who joined between 1/1/2005 and 1/2/2005?