Build your database English vocabulary with this exercise. Understanding these terms will help you follow technical discussions, read documentation, and communicate in data-focused roles.
READY TO PRACTICE? LET’S GO!
Choose the correct response to complete each sentence.
1. We need to make some major changes to the structure in order to __________________ (meaning: take into account) the new data.
Correct answer: account for.
2. By implementing the technique known as "normalization", database administrators can minimize the risk of __________________ information. (meaning: having the same information appear more than once)
Correct answer: duplicating.
3. I'll need to add these two __________________ of data together.
Correct answer: sets.
4. I programmed it so that it ____________________ the data stored in the third column.
Correct answer: parses.
5. Normalizing data is an __________________ (meaning: very important) part of making a database perform optimally.
Correct answer: essential.
6. We have to __________________ (meaning: transfer) all this data to the new database.
Correct answer: move.
7. We have to pass this value to a SQL __________________.
Correct answer: statement.
8. Get ____________________ of auto-numbering for this column.
Correct answer: rid.
9. Another way of saying to "move" data is to __________________ data.
Correct answer: migrate.
10. We have to change the structure = We have to make some __________________ changes
Correct answer: structural.
—
📚 Important Words to Know API (Application Programming Interface) — a set of rules allowing different software applications to communicate and share data with each other cloud computing — the delivery of computing services including storage, servers, and software over the internet on demand agile methodology — a project management approach based on iterative development, collaboration, and flexibility to change DevOps — a set of practices combining software development and IT operations to shorten development cycles and improve reliability cybersecurity — the practice of protecting computer systems, networks, and data from digital attacks and unauthorized access bandwidth — the maximum rate of data transfer across a network, typically measured in megabits per second latency — the delay between a user's action and the corresponding response from a system or network scalability — the ability of a system or network to handle an increasing amount of work or expand its capacity firewall — a network security system that monitors and controls incoming and outgoing traffic based on defined rules encryption — the process of encoding data so that only authorized parties can read it