Chapter 5: Databases
- 1. A, C. Different relational databases use different terminology. A row, record, and tuple all describe an ordered set of columns. An attribute is another term for column. A table contains rows and columns.
- 2. C. A table must contain at least one attribute or column. Primary and foreign keys are used for relating data in different tables, but they’re not required. A row can exist within a table, but a table doesn’t need a row in order to exist.
- 3. D. The SELECT statement retrieves data from a table. INSERT is used for adding data to a table. QUERY and SCAN are commands used by DynamoDB, which is a nonrelational database.
- 4. B. Online transaction processing databases are designed to handle multiple transactions per second. Online analytics processing databases are for complex queries against large data sets. A key-value store such as DynamoDB can handle multiple transactions per second, but it’s not a relational database. There’s no such...
