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
Which SQL statement is used to read data from a table?
- SELECT
- INSERT
- DELETE
- DROP
Show answer
Answer: A. SELECT
SELECT retrieves data. INSERT adds rows, DELETE removes rows and DROP removes a whole object.
Which statements about scalability are correct?
- Vertical scaling means giving one server more CPU, RAM or storage
- Horizontal scaling means adding more servers to share the load
- Scalability means the database never needs a backup
- Scaling is only possible by deleting old data
- 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.
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.
