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';

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

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

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

Which of the following is not a control statement?

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

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?

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

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

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

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