Which of the following spatial data types are used in SQL Server 2008?

Which of the following statements are true about FILESTREAM storage in SQL Server 2008?

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

For which of the following data types can a COLLATE clause be applied?

Columns marked with which of the following constraints/properties allow null values to be inserted in them?

Analyze the following code used to update a Common Table Expression: USE demodb GO DECLARE @a TABLE (ID int, Value int); DECLARE @b TABLE (ID int, Value int); INSERT @a VALUES (1, 10), (2, 20); INSERT @b VALUES (1, 100),(2, 200); WITH cte AS (SELECT * FROM @a) UPDATE cte SET Value = b.Value FROM cte AS a INNER JOIN @b AS b ON b.ID = a.ID SELECT * FROM @a GO What Will be the output of the above code?

Which of the following statements about SQL Server comments is false?

Which of the following is not a control statement?

Which of the following is/are true with reference to Triggers?

When designing a database table, how do you avoid missing column values for non-primary key columns? 

What is the correct order of clauses in the select statement? 1 select 2 order by 3 where 4 having 5 group by