Fortinet
NSE5_FAZ-7.2 · Question #109
Which SQL query is in the correct order to query the database in the FortiAnslyzer?
The correct answer is C. SELECT devid FROM $log WHERE 'user'='USER1' GROUP BY devid. The main clauses FortiAnalyzer reports use are as follows: Accordingly, following the SELECT keyword, the statement must be followed by one or more clauses in the order in which they appear in the table shown on this slide.
Reports
Question
Which SQL query is in the correct order to query the database in the FortiAnslyzer?
Options
- ASELECT devid WHERE 'user'='USER1' FROM $log GROUP BY devid
- BFROM $log WHERE 'user'='USER1' SELECT devid GROUP BY devid
- CSELECT devid FROM $log WHERE 'user'='USER1' GROUP BY devid
- DSELECT devid FROM $log GROUP BY devid WHERE 'user'='USER1'
How the community answered
(37 responses)- A14% (5)
- B3% (1)
- C78% (29)
- D5% (2)
Explanation
The main clauses FortiAnalyzer reports use are as follows: Accordingly, following the SELECT keyword, the statement must be followed by one or more clauses in the order in which they appear in the table shown on this slide.
Topics
#SQL query syntax#database query#log query#SELECT FROM WHERE
Community Discussion
No community discussion yet for this question.