Which of the following storage options can be used to store LOBs and save storage?

A ________ is an alphanumerical, hexadecimal, or numberic constant.

True or false? Adding TOP to a select always improves performance.

Which Transact-SQL statement should you include at the beginning of a stored procedure to ensure that if the stored procedure raises a run-time error, the entire transaction is terminated and rolled back?

GETDATE() is a ....... function?

Given a table with the following schema: create table table1 (field1 int) The table contains 1000 records. What would the following sql statement result in: update top (100) table1 set field1 = 1

What exactly is the Full-Text Catalog?

Consider the following table 'Students': Students - - - - - - Name Hobbies John Driving Miller Fishing David Writing Robert Singing What will be the output of the following query? Select Substring(Hobbies,3) From students Where name= 'john"

Why are Joins generally better than the Correlated sub-query?

Starting from the slowest, arrange the following operators in the order in which they produce results in 'SQL WHERE' query. 1. >, >=, <, <= 2. <> 3. = 4. LIKE

Which one of the following statements is correct?