Multiple choice

Write the correct syntax to create new login on the SQL server.

  1. CREATE LOGIN login_id USE password

  2. CREATE LOGIN login_id WITH USE password

  3. CREATE LOGIN login_id WITH PASSWORD password

  4. USE LOGIN login_id WITH PASSWORD password

  5. UPDATE LOGIN login_id WITH PASSWORD password
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This is the correct syntax to create new login on SQL server.

Keep practicing — related questions