Which operation can you use SQL SELECT queries for?

Question

Options

• ATo alter tables in the database
• BTo purge log entries from the database
• CTo display the database schema
• DTo insert new data into an existing table

• A
  2% (1)
• B
  2% (1)
• C
  90% (38)
• D
  5% (2)

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.