MS SQL Server - 33 - Set Commands MCQ

33 – Set Commands MCQ

Best of luck!

1 / 25

1. In SQL Server, what is the primary purpose of the SET NOCOUNT ON statement?

To stop a query from executing

To disable the counting of rows affected by a SQL statement

To enable the counting of rows affected by a SQL statement

To set the default isolation level for transactions

2 / 25

2. Which SQL statement is used to enable the counting of rows affected by SQL statements?

SET COUNT ON

SET ROWCOUNT ON

SET @@ROWCOUNT ON

SET NOCOUNT OFF

3 / 25

3. What is the primary purpose of the SET ROWCOUNT statement in SQL Server?

To specify the maximum number of rows to return in a query result

To enable or disable the counting of rows affected by SQL statements

To stop the execution of a query

To set the default isolation level for transactions

4 / 25

4. In SQL Server, what is the purpose of the SET TRANSACTION ISOLATION LEVEL statement?

To set the default isolation level for all transactions in the database

To create a new transaction

To commit a transaction

To disable transactions in a database

5 / 25

5. Which isolation level in SQL Server allows for the highest degree of data consistency but can lead to the most locking and blocking?

SERIALIZABLE

REPEATABLE READ

READ COMMITTED

READ UNCOMMITTED

6 / 25

6. What is the primary purpose of the SET IDENTITY_INSERT statement in SQL Server?

To enable the insertion of explicit values into an identity column

To disable identity columns in a table

To set the identity seed value for a table

To reset the identity column value to 1

7 / 25

7. In SQL Server, which statement is used to specify the identity seed and increment values for an identity column?

SET IDENTITY_SEED

SET IDENTITY

ALTER IDENTITY

ALTER TABLE

8 / 25

8. In SQL Server, what is the purpose of the SET ANSI_NULLS statement?

To enable or disable the use of NULL values in comparisons

To set the default collation for a database

To set the default isolation level for transactions

To create a new table

9 / 25

9. What is the default behavior for ANSI_NULLS in SQL Server?

ANSI_NULLS is determined by the collation settings.

ANSI_NULLS is neither ON nor OFF by default.

ANSI_NULLS is OFF by default.

ANSI_NULLS is ON by default.

10 / 25

10. In SQL Server, what is the purpose of the SET DATEFIRST statement?

To set the default date format for a database

To disable date calculations in queries

To set the default isolation level for transactions

To specify the first day of the week for date calculations

11 / 25

11. Which SQL statement is used to change the default language for a session in SQL Server?

SET CULTURE

SET LANGUAGE

SET LOCALE

SET COLLATION

12 / 25

12. In SQL Server, what is the primary purpose of the SET CONTEXT_INFO statement?

To set the default isolation level for transactions

To store binary information in a session-specific context area

To retrieve data from tables

To set the context of a transaction

13 / 25

13. What is the primary purpose of the SET CONCAT_NULL_YIELDS_NULL statement in SQL Server?

To set the default isolation level for transactions

To enable or disable the concatenation of NULL values with non-NULL values

To set the default collation for a database

To create a new table

14 / 25

14. In SQL Server, what is the purpose of the SET LANGUAGE statement?

To specify the first day of the week for date calculations

To set the default language for a database

To set the default isolation level for transactions

To enable or disable the use of NULL values in comparisons

15 / 25

15. What is the primary use of the SET QUOTED_IDENTIFIER statement in SQL Server?

To create a new table

To set the default collation for a database

To set the default isolation level for transactions

To enable or disable the use of single quotes for string literals

16 / 25

16. In SQL Server, what is the primary purpose of the SET TEXTSIZE statement?

To specify the default length for text data types

To set the maximum length of text columns in a table

To set the default isolation level for transactions

To control the size of text output in query results

17 / 25

17. What is the primary purpose of the SET ROWLOCK statement in SQL Server?

To specify the maximum number of rows to return in a query result

To set the default locking mode for a database

To enable row-level locking for a specific table

To stop the execution of a query

18 / 25

18. In SQL Server, what is the primary purpose of the SET DEADLOCK_PRIORITY statement?

To set the default priority for deadlock resolution

To enable or disable the use of NULL values in comparisons

To create a new table

To set the default isolation level for transactions

19 / 25

19. Which SQL statement is used to set the deadlock priority for a session in SQL Server?

SET PRIORITY

SET DEADLOCK_PRIORITY

SET LOCK_PRIORITY

SET SESSION_PRIORITY

20 / 25

20. In SQL Server, what is the primary purpose of the SET REMOTE_PROC_TRANSACTIONS statement?

To stop the execution of a remote query

To control the behavior of remote transactions

To specify the maximum number of remote transactions

To enable or disable remote procedure calls

21 / 25

21. What is the primary purpose of the SET ROWS statement in SQL Server?

To set the default number of rows for query results

To enable or disable the use of NULL values in comparisons

To specify the maximum number of rows to return in a query result

To set the default isolation level for transactions

22 / 25

22. In SQL Server, what is the primary use of the SET TEXTSIZE statement?

To set the maximum length of text columns in a table

To control the size of text output in query results

To set the default isolation level for transactions

To specify the default length for text data types

23 / 25

23. What is the primary purpose of the SET SHOWPLAN_ALL statement in SQL Server?

To display the execution plan for a query without executing it

To create a new table

To enable or disable the display of query results

To set the default isolation level for transactions

24 / 25

24. In SQL Server, what is the purpose of the SET DATEFORMAT statement?

To set the default date format for a database

To specify the first day of the week for date calculations

To enable or disable date calculations in queries

To set the default isolation level for transactions

25 / 25

25. What is the primary purpose of the SET ANSI_WARNINGS statement in SQL Server?

To set the default collation for a database

To set the default isolation level for transactions

To create a new table

To enable or disable the display of warning messages

Your score is

MS SQL Server – 33 – Set Commands MCQ