Which code segment should you use?

You have a SQL Server 2012 database that contains a table named Users. The Users
tablecontains usernames and passwords.
You need to ensure that all new records have a password.
Which code segment should you use?
More than one answer choice may achieve the goal. Select the BEST answer.

You have a SQL Server 2012 database that contains a table named Users. The Users
tablecontains usernames and passwords.
You need to ensure that all new records have a password.
Which code segment should you use?
More than one answer choice may achieve the goal. Select the BEST answer.

A.
Option A

B.
Option B

C.
Option C

D.
Option D



Leave a Reply 4

Your email address will not be published. Required fields are marked *


Vladimir

Vladimir

D:
“You need to ensure that all new records have a password”, so “IS NOT NULL”

krishtweety

krishtweety

D is correct