Which of the following scripting options are available while creating a script using the shortcut menu from the Object Explorer in SQL Server 2008 Management Studio?

What is the data type of the parameter 'Audit_file_offset' of function 'fn_get_audit_file()' in SQL Server 2008?

Which of the following compression features have been introduced in SQL Server 2008 that were NOT supported by SQL Server 2005?

Analyze the following code which uses the TOP clause of SQL Server 2008: USE Person GO DECLARE @p AS int SELECT @p=10 SELECT TOP(@p) FROM Employee GO What Will be the output of the above code?

All MDX, DMX and XML/A errors are displayed in the Error List window of the SQL Server 2008. Management Studio.

Which of the following arguments of the fn_get_audit_file() function of SQL Server 2008 specifies the directory indicating the location and audit file set to be read?

Which of the following are not date parts?

Which of the following are false for batches (batch commands)?

Examine the two SQL statements given below: SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC What is true about them?

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

Evaluate the following SQL statement: SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE FROM employees e, sales s WHERE e.employee_id = s.emp_id; What will happen if all the parentheses are removed from the calculation?