Examice

Exam nse5_faz-72 All QuestionsBrowse all questions from this exam

Go to Exam

Question 38

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

FROM $log WHERE 'user'='USER1' SELECT devid GROUP BY devid

SELECT devid FROM $log GROUP BY devid WHERE 'user'='USER1'

SELECT devid FROM $log WHERE 'user'='USER1' GROUP BY devid

SELECT devid WHERE 'user'='USER1' FROM $log GROUP BY devid

Correct Answer: C

The correct order for an SQL query to query a database is SELECT, FROM, WHERE, GROUP BY, ORDER BY, LIMIT, OFFSET. Option C follows this sequence properly: it starts with SELECT devid, specifies the table with FROM $log, filters the results with WHERE 'user'='USER1', and then groups the results with GROUP BY devid.

Discussion

GriffXXOption: C

C is correct. There is a mandatory sequence of SQL commands (if they are used, after SELECT and FROM, the rest are optional) Page 141 of 7.2 Study Guide. The order is : SELECT, FROM, WHERE, GROUP BY, ORDER BY, LIMIT, OFFSET.

AminshonOption: C

The order is : SELECT, FROM, WHERE, GROUP BY, ORDER BY, LIMIT, OFFSET. FortiAnalyzer_Analyst_7.2_Study_Guide page 11