| 1 | 13 | 14 | |||||||||||||||||||||||
| 2 | |||||||||||||||||||||||||
| 16 | |||||||||||||||||||||||||
| 3 | |||||||||||||||||||||||||
| 18 | |||||||||||||||||||||||||
| 12 | 4 | ||||||||||||||||||||||||
| 5 | |||||||||||||||||||||||||
| 6 | |||||||||||||||||||||||||
| 7 | |||||||||||||||||||||||||
| 15 | 17 | ||||||||||||||||||||||||
| 8 | |||||||||||||||||||||||||
| 9 | |||||||||||||||||||||||||
| 10 | |||||||||||||||||||||||||
| 11 |
1. A type of database that uses graph structures to store, represent, and query relationships between complex interconnected data entities.
2. Describes the number of instances of one entity that are associated with the number of instances of another entity.
3. The accuracy, consistency, and reliability of data stored in a database, typically maintained through the use of integrity constraints and validation rules.
4. A DDL query used to remove all the data from a table while keeping its structure intact.
5. The process of creating copies of data and storing them in a separate location for disaster recovery purposes or as a precaution against data loss.
6. A logical unit of work that is performed as a single, indivisible operation in a relational database.
7. A clause in SQL that is used to group rows based on one or more columns.
8. The protection of electronic databases from unauthorized access, use, disclosure, disruption, modification, or destruction.
9. A validation process to ensure that a value belongs to a specific data type.
10. A type of data validation that examines the structure and format of data to ensure it adheres to predefined rules.
11. When the same data is stored in multiple locations, leading to inconsistency and inefficiency in database management.
12. A mechanism used in the recovery process of a database to revert the effects of incomplete or aborted transactions.
13. The process of restoring a database to a previous state using the information in the transaction log.
14. Symbols used to represent parameter placeholders in a SQL statement.
15. A diagram that shows the implementation details of a database, including data types and constraints
16. Tools that allow users to build queries using graphical elements rather than text-based commands.
17. The degree to which data or information is correct, precise, and free from errors.
18. A type of data validation that verifies if the value is in the correct format or follows a specific pattern.