SQL and Datasets

Question 1

Dataset

Answer 1

A SQL SELECT query. Specific data polled from the database that populates a chart.

Question 2

Two Tables in SQL Database

Answer 2

User Tables, which contain information that is in the database
System Tables, which contain the database description

Question 3

The only statement used for FAZ Reports

Answer 3

SELECT (because it is read only)

Question 4

FAZ Functions: email

Answer 4

email_domain and email_user.
Domain retrieves anything after the @ symbol. User retrieves anything the comes before the @ symbol

Question 5

FAZ Functions: time

Answer 5

from_dtime and from_itime
dtime returns the device timestamp without the time zone, while itime returns the Faz’s timestamp without the time zone.