Which statement about SQL SELECT queries is true?

Question

Options

• AThey can be used to purge log entries from the database.
• BThey must be followed immediately by a WHERE clause.
• CThey can be used to display the database schema.
• DThey are not used in macros.

• A
  4% (1)
• B
  4% (1)
• C
  82% (23)
• D
  11% (3)

Explanation

To create a query, you first need to know what is included in the database schema. The schema is the different fields, or columns, that are available, and from which you can extract information for reports. In FortiAnalyzer, you can obtain the schema for a specific log type by creating and testing the following dataset query: SELECT * FROM $log, This query can be read as: "Select everything from the logs table." For traffic logs, for example, associate the Traffic log type with this dataset in the Log Type field. This query returns everything from the Traffic log type. The column heading names indicate what is available in the database schema for the log type selected. The * symbol returns all data. Note that not all column headings are shown in the example on this slide.

No community discussion yet for this question.