ExamGecko
Question list
Search
Search

Question 129 - NSE5_FAZ-7.2 discussion

Report
Export

Which SQL query is in the correct order to query the database in the FortiAnslyzer?

A.
SELECT devid FROM Slog GROOP BY devid WHERE * user' =* USERl'
Answers
A.
SELECT devid FROM Slog GROOP BY devid WHERE * user' =* USERl'
B.
SELECT devid WHERE 'u3er'='USERl' FROM $ log GROUP BY devid
Answers
B.
SELECT devid WHERE 'u3er'='USERl' FROM $ log GROUP BY devid
C.
SELECT devid FROM Slog- WHERE *user' =' USERl' GROUP BY devid
Answers
C.
SELECT devid FROM Slog- WHERE *user' =' USERl' GROUP BY devid
D.
FROM Slog WHERE 'user* =' USERl' SELECT devid GROUP BY devid
Answers
D.
FROM Slog WHERE 'user* =' USERl' SELECT devid GROUP BY devid
Suggested answer: C

Explanation:

FortiAnalyzer_7.0_Study_Guide-Online.pdf page 259: The main clauses FortiAnalyzer reports use are as follows:

•FROM

•WHERE

•GROUP BY

•ORDER BY

• LIMIT

• OFFSET

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.

asked 18/09/2024
Youssef El Akhal
39 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first