Which of the following statements is true if you create a global temporary table in SQL Server 2008 and specify a FOREIGN KEY with the CREATE TABLE command?

Which query is used to rename a database in SQL Server 2008?

Which features of SQL Server 2008 evaluates servers for compliance with a set of predefined conditions and prevents making undesirable changes to servers?

Which permissions are required to create a view in SQL Server 2008?

What happens to the audit records if a failure to write the Audit event does NOT trigger the SQL Server instance to shut down?

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?

Which one is true about Radar Altimeter (RA)?

Spot the error in the following sentence. I do not think she is very fond in Italian food.

What does a customer with a problem expect from a customer service representative?

Which one is the standard specification fuel used by most of the countries in commercial airplane engines?

Which area in the Microsoft Excel 2010 PivotTable Field List, calculates the aggregates of columns?