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?

The Server Audit object and the Server Audit Specification object of SQL Server 2008 share a __________ relationship.

What is the maximum value for the sum of the values of MIN_CPU_PERCENT and MIN_MEMORY_PERCENT for all the resource pools of SQL Server?

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

A company has the following departments: marketing, Designing, production, Packing What will be the result of the following query? select * from table where department < 'marketing';

Study the situation described below and identify the nature of relationship? Each student can enroll into more than one class. Each class can accommodate more than one student.