Multiple choice technology delivery

Collate property set at DB level is not applicable to

  1. Stored Procedures

  2. Temporary tables

  3. Views

  4. Triggers

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In SQL Server, the COLLATE property at the database level affects permanent objects but has special behavior with temporary tables. Temporary tables are created in tempdb and inherit its collation, which can differ from the database collation. Stored procedures, views, and triggers can use collation settings within the database context.