MS SQL Server – 15 – NULL and Global Variables MCQ

15 – NULL and Global Variables MCQ

Best of luck!

1 / 25

1. What is the result of adding two NULL values in SQL Server?

2 / 25

2. Which operator is used in SQL Server to concatenate two strings?

3 / 25

3. What is the result of subtracting a NULL value from a numeric value in SQL Server?

4 / 25

4. Which SQL Server operator is used to perform division between two numeric values?

5 / 25

5. In SQL Server, what is the result of multiplying a NULL value by a numeric value?

6 / 25

6. Which operator is used to compare two values for equality in SQL Server?

7 / 25

7. What is the result of comparing a NULL value to any other value using the equality operator in SQL Server?

8 / 25

8. In SQL Server, which operator is used to check if a value is not equal to another value?

9 / 25

9. What is the result of comparing a NULL value to any other value using the not equal operator in SQL Server?

10 / 25

10. Which SQL Server operator is used to perform addition between two numeric values?

11 / 25

11. In SQL Server, what is the result of adding a NULL value to a numeric value?

12 / 25

12. Which operator is used to check if a value is less than another value in SQL Server?

13 / 25

13. What is the result of comparing a NULL value to any other value using the less than operator in SQL Server?

14 / 25

14. In SQL Server, which operator is used to check if a value is greater than another value?

15 / 25

15. What is the result of comparing a NULL value to any other value using the greater than operator in SQL Server?

16 / 25

16. Which SQL Server operator is used to perform subtraction between two numeric values?

17 / 25

17. What is the result of subtracting a NULL value from another numeric value in SQL Server?

18 / 25

18. In SQL Server, which operator is used to check if a value is less than or equal to another value?

19 / 25

19. What is the result of comparing a NULL value to any other value using the less than or equal to operator in SQL Server?

20 / 25

20. Which SQL Server operator is used to check if a value is greater than or equal to another value?

21 / 25

21. What is the result of comparing a NULL value to any other value using the greater than or equal to operator in SQL Server?

22 / 25

22. In SQL Server, which operator is used to perform multiplication between two numeric values?

23 / 25

23. What is the result of multiplying a NULL value by another numeric value in SQL Server?

24 / 25

24. Which operator is used to concatenate two strings with a space in between in SQL Server?

25 / 25

25. What is the result of concatenating a string with a NULL value using the CONCAT function in SQL Server?

Your score is

0%