| 2 | 15 | 1 | 18 | ||||||||||||||||||||||
| 19 | |||||||||||||||||||||||||
| 3 | |||||||||||||||||||||||||
| 4/14 | |||||||||||||||||||||||||
| 17 | 5 | ||||||||||||||||||||||||
| 6 | |||||||||||||||||||||||||
| 16 | 7 | ||||||||||||||||||||||||
| 8 | |||||||||||||||||||||||||
| 9 | |||||||||||||||||||||||||
| 10 | |||||||||||||||||||||||||
| 11 | |||||||||||||||||||||||||
| 12 | |||||||||||||||||||||||||
| 13 | |||||||||||||||||||||||||
1. A value calculated from data for error detection in order to verify the accuracy of the data.
2. A unit of data in a flat file database that contains all relevant information about a specific entity or object.
3. A rule that restricts the values allowed in certain columns or tables.
4. The ability to recover a database to a specific moment in time using the transaction log.
5. A point within a transaction where you can roll back a part of the transaction instead of the entire transaction.
6. A type of database that stores and provides access to data points that are related to one another.
7. A key that consists of two or more attributes that together uniquely identify a record.
8. An object or concept that can have data stored about it.
9. When the same data is stored in multiple locations, leading to inconsistency and inefficiency in database management.
10. A placeholder is a character or sequence of characters used in a SQL statement as a substitute for a parameter value.
11. The degree to which data or information is correct, precise, and free from errors.
12. Individuals who may lack specialized knowledge in programming or database languages.
13. An essential component of a relational database that organizes data into rows and columns.
14. Verification of whether a given input matches a specified pattern.
15. A statement in SQL that allows you to perform different actions based on a set of conditions.
16. The structure that defines the organization of data within a database.
17. The process of undoing all changes made within a transaction and returning the database to its previous state.
18. A process that reverses the effects of a transaction by applying the opposite changes recorded in the transaction log.
19. A concurrency control protocol where a transaction acquires all its required locks before starting execution and releases them all at the end. It enforces serializability.