The organization, storage, querying, and management of data. General program algorithms remain in Coding.
Test your knowledge with these top questions!
Which kind of database index helps search words inside articles and reviews?
A full-text index breaks text into searchable words, powering fast keyword search across documents.
What structure do relational databases use to store data in rows and columns?
Each table works like a spreadsheet tab, with each row holding one record and each column holding one type of detail.
In databases, what does atomicity guarantee about a transaction?
Atomicity stops half-finished work, like money leaving one bank account without arriving in another.
What is the main job of a database index?
An index stores a sorted shortcut to matching rows, so the database can skip scanning the whole table.
What does ORDER BY do to SQL query results?
ORDER BY sorts after the database finds matches, so filtering happens before the final order.
Which everyday tool works most like a database index?
Like a book index lists topics with page numbers, a database index lists values with row locations.
What is a common downside of adding too many database indexes?
Every insert or change must update each index too, so extra indexes add maintenance work on writes.
Relational databases use which language to retrieve and change data?
SQL lets users filter, sort, and update records with short readable commands such as SELECT and UPDATE.
Which SQL clause keeps only rows meeting a set condition?
WHERE narrows rows before grouping and sorting, so later steps organize only the matches.
What does COMMIT do at the end of a database transaction?
Until COMMIT runs, other users generally cannot see the new changes.