Which of the following isql login database commands is correct?

Question

Options

• Aisql -Usa_password -Ssa -PN2000DBServer
• Bisql -Usa -Ssa_password -SN2000DBServer
• Cisql -Usa -PN2000DBServer -Ssa_password
• Disql -Usa -Psa_password -SN2000DBServer

• A
  9% (4)
• B
  15% (7)
• C
  4% (2)
• D
  72% (33)

Explanation

Option D correctly maps each flag to its intended value: -U specifies the username (sa), -P specifies the password (sa_password), and -S specifies the server (N2000DBServer).

Why the distractors fail:

• A swaps all three values - the password is given as the username, the username as the server, and the server as the password.
• B puts sa_password after -S (the server flag) instead of -P (the password flag), so the password and server are transposed.
• C puts N2000DBServer after -P (the password flag) and sa_password after -S (the server flag) - another password/server swap.

Memory tip: Think User, Password, Server - alphabetical order matches the flags -U, -P, -S. Just remember the sentence "User Picks a Server" to keep the flag-to-value mapping straight.

No community discussion yet for this question.