Bitzu

FC0-U71 ยท Data and databases

Queries, reports, scalability and cloud vs local databases

Retrieving data with queries (SELECT-level reading), generating reports, scalability, and cloud vs local databases.

Key points

  • Query: asks the database for data.
  • SQL: SELECT reads columns, FROM names the table, WHERE filters rows, ORDER BY sorts.
  • SELECT only reads, it does not change data.
  • Reports: present query results in readable form.
  • Scalability: coping with growth by a bigger server (vertical) or more servers (horizontal).
  • Cloud: provider-run, scales on demand. Local: full control, your own hardware.

Source: https://www.postgresql.org/docs/current/tutorial-select.html

Practice questions

Single choice

Which SQL statement is used to read data from a table?

  1. SELECT
  2. INSERT
  3. DELETE
  4. DROP
Show answer

Answer: A. SELECT

SELECT retrieves data. INSERT adds rows, DELETE removes rows and DROP removes a whole object.

Select all that apply

Which statements about scalability are correct?

  1. Vertical scaling means giving one server more CPU, RAM or storage
  2. Horizontal scaling means adding more servers to share the load
  3. Scalability means the database never needs a backup
  4. Scaling is only possible by deleting old data
  5. Horizontal scaling means making the monitor bigger
Show answer

Answer: A. Vertical scaling means giving one server more CPU, RAM or storage, B. Horizontal scaling means adding more servers to share the load

Scale up (vertical) strengthens one machine, scale out (horizontal) adds machines. Scalability is unrelated to backups, and deleting data or bigger monitors are not scaling methods.

True or false

Running a SELECT query changes the data stored in the table.

Show answer

Answer: False

SELECT only reads data and returns a result. Changing data takes statements such as INSERT, UPDATE or DELETE.

Practice 8 questions on this topic in Bitzu

Short lessons, instant explanations and spaced review of what you get wrong. Free on iOS and Android.

Download on the App StoreGet it on Google Play

More FC0-U71 topics in this module