Have you used CHECKSUM function in SQL Server? Thirty third question verifies this knowledge.
Which queries will fail when you try to execute it against a SQL Server 2017 database? Choose all correct options:
-
select checksum(2)
-
select checksum(getDate(), 'OVdovudwkda4', 'ddsdg')
-
select checksum(*)
from sys.views -
select checksum(cast('abc' as text))
-
declare @text nvarchar(max) = 'abcdefghijklmnoprstuvwxyzabcdefghijklmnoprstuvwxyzabcdefghijklmnoprstuvwxyzabcdefghijklmnoprstuvwxyzabcdefghijklmnoprstuvwxyzabcdefghijklmnoprstuvwxyzabcdefghijklmnoprstuvwxyzabcdefghijklmnoprstuvwxyzabcdefghijklmnoprstuvwxyzabcdefghijklmnoprstuvwxyzabcdefghijklmnoprstuvwxyzabcdefghijklmnoprstuvwxyz'
select checksum(@text)
For the correct answer scroll down
.
.
.
.
.
.
The correct answer is: d. For more information read Forget about BINARY_CHECKSUM in SQL Server!