Question

Question 8
You are using a database table that includes the column user_password, and you want to make sure all passwords are aligned to company protocols. Which SQL clause will help you confirm that the passwords are 15 characters long?

IDENTIFY(user_password) = 15



COUNT(user_password) > 15



LENGTH(user_password) = 15



WHERE(user_password) < 15


1 point

Answer 1

LENGTH(user_password) = 15

(Use e.g. WHERE LENGTH(user_password) = 15 to select rows with 15-character passwords.)