⚠️ Retired / Legacy Exam: This exam has been retired or replaced. These practice questions are kept for reference only. Please check the official vendor website for current exam versions before studying.
In order to leverage the power of data correlation within Nessus, a cybersecurity analyst needs to write an SQL statement that will provide how long a vulnerability has been present on the network. Given the following output table:
Which of the following SQL statements would provide the resulted output needed for this correlation?
A. SELECT Port, ScanDate, IP, PlugIn FROM MyResults WHERE PluginID=’1000′
B. SELECT ScanDate, IP, Port, PlugIn FROM MyResults WHERE PluginID=’1000′
C. SELECT IP, PORT, PlugIn, ScanDate FROM MyResults SET PluginID=’1000′
D. SELECT ScanDate, IP, Port, PlugIn SET MyResults WHERE PluginID=’1000′