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?

An identifier denoting a global temporary object in SQL Server 2008 starts with a ______ sign.

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.

Which of the following is the syntax for creating an Index?