EC-Council
412-79V10 · Question #122
412-79V10 Question #122: Real Exam Question with Answer & Explanation
Sign in or unlock 412-79V10 to reveal the answer and full explanation for question #122. The question stem and answer options stay visible for context.
Question
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?
Options
- ASELECT name FROM sys.server_principals WHERE TYPE = 'R'
- BSELECT name FROM sys.server_principals WHERE TYPE = 'U'
- CSELECT name FROM sys.server_principals WHERE TYPE = 'S'
- DSELECT name FROM sys.server_principals WHERE TYPE = 'B'
Unlock 412-79V10 to see the answer
You've previewed enough free 412-79V10 questions. Unlock 412-79V10 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.