Harry, a penetration tester in SqlSac Solutions Ltd., is trying to check if his company's SQL server database is vulnerable. He also wants to check if there are any unpatched versions of SQL servers existing in the network. If he found any unpatched versions, he needs to update the database. After performing various test which of the following SQL query executes an SQL input to extract all the available Windows Login Account details. Which of the following SQL query will Harry execute to obtain the information?

Question

Accepted Answer

B. SELECT name FROM sys.server_principals WHERE TYPE = 'U'

Answer

A. SELECT name FROM sys.server_principals WHERE TYPE = 'R'

Answer

C. SELECT name FROM sys.server_principals WHERE TYPE = 'S'

Answer

D. SELECT name FROM sys.server_principals WHERE TYPE = 'B'

Harry, a penetration tester in SqlSac Solutions Ltd., is trying to check if his company's SQL server database is vulnerable. He also wants to check if there are any unpatched versions of SQL servers…

Question

Options

How the community answered

Community Discussion