5 collocation exercises on database operation verbs.
0 / 5 completed
1 / 5
The application will ___ the orders table to fetch all pending shipments.
To query a table means to retrieve data from it using a query language. Query is the precise database verb. Ask, search up, and look in are informal or non-technical. Developers "query the table for matching rows," so query a table is the correct collocation.
2 / 5
To speed up the slow lookup, the DBA will ___ an index on the email column.
To create an index means to add a database index to accelerate queries. Create is the standard term, behind SQL's CREATE INDEX. Make up and build out are informal, and set up is too general. DBAs "create an index to speed up lookups," so create an index is the correct collocation.
3 / 5
During design, the team will ___ the schema to reduce data redundancy across tables.
To normalise the schema means to structure tables to minimise redundancy and dependency. Normalise is the precise database-design term, behind "third normal form." Tidy, clean up, and straighten are informal and lack the technical meaning. Designers "normalise the schema to 3NF," so normalise the schema is the correct collocation.
4 / 5
As the table grew beyond a billion rows, the team decided to ___ the database across multiple nodes.
To shard a database means to horizontally partition data across multiple nodes for scale. Shard is the precise term, behind "sharding key" and "horizontal sharding." Split up, cut, and divide out are informal. Engineers "shard the database by customer ID," so shard the database is the correct collocation.
5 / 5
To apply the schema change safely, the team will ___ a migration in the deployment pipeline.
To run a migration means to execute a versioned schema change script. Run is the standard term, behind "database migration" and tools like Flyway/Liquibase. Do, play, and fire off are informal. Engineers "run the migration as part of the deploy," so run a migration is the correct collocation.