There is no such type - rwoversion. The right name is rowversion

It should be:

select CONVERT(varchar(10), @d, 104)

There is only  a SCH-M lock taken on a main table.  IX lock is being taken on syscolpars system table.

You can get the C drive size from sys.dm_os_volume_stats view only when you have a database on C drive.

"Returns information about the operating system volume (directory) on which the specified...

sys.configurations is not a DMV. It's a system view. DMV should start with "dm_" prefix.

sys.syslanguages table contains first day of the week values related to language, not default date first values for instance. The question is incorrect.