Data trivia

Try 20 Data trivia questions one at a time, no sign-in needed. Harder questions and review of what you missed continue in the LoreUp app.

• Which approach gathers data and handles it all at once at a set time?Data
• Which SQL statement reads stored data?Data
• What do we call a vertical line in a table in a relational database?Data
• Which SQL statement puts new data into a table?Data
• What is the three-letter abbreviation for the flow of pulling data out, reshaping it, and loading it in?Data
• Which SQL feature links two tables on a shared column and reads them together?Data
• Which SQL clause bundles rows sharing a value to produce a sum or an average?Data
• Which store gathers data from many systems in one place, organized for analysis?Data
• Which data structure is built in advance on a column to speed up reads?Data
• A data warehouse is not a store for analysis but a system that handles payments in real time.Data
• Batch processing handles each record immediately, the moment the data appears.Data
• Which column is chosen in a relational database to identify one row uniquely?Data
• A primary key is the value that tells each row in a table apart from every other.Data
• In a relational database, a vertical line in a table is called a row.Data
• In SQL, SELECT is the statement used to read stored data.Data
• Data removed by SQL DELETE can always be brought back automatically.Data
• ETL means the flow of pulling data out (Extract), reshaping it (Transform), and loading it in (Load).Data
• The more indexes you build, the faster not only reads but also writes and updates always become.Data
• JOIN is the feature that links two tables on a shared column and reads them together.Data
• GROUP BY is used to bundle rows sharing a value and produce aggregates such as sums and averages.Data