1/2 | 13 | 15 | |||||||||||||||||||||||
3 | 16 | ||||||||||||||||||||||||
4 | |||||||||||||||||||||||||
5 | |||||||||||||||||||||||||
6/14 | |||||||||||||||||||||||||
12 | |||||||||||||||||||||||||
7 | |||||||||||||||||||||||||
8 | |||||||||||||||||||||||||
9 | |||||||||||||||||||||||||
10 | |||||||||||||||||||||||||
11 | |||||||||||||||||||||||||
1. A unit of work performed on a database that follows the ACID approach.
2. A file that records all the transactions and activities in a database system.
3. The storage of the same data in multiple places within a database, which can lead to inconsistency and inefficiency.
4. A technique used in distributed databases to divide the data into smaller subsets or partitions, which are then stored on different nodes in the network.
5. A sequential record of all the changes made to a database, stored in the transaction log.
6. The process of using SQL commands to modify data within a database, including operations like update, insert, and delete.
7. A professional responsible for managing and maintaining a database system.
8. A user-friendly method that enables users to select objects and manipulate them within a graphical environment for query creation.
9. The accuracy, consistency, and reliability of data stored in a database, ensuring it is valid and trustworthy.
10. A point within a transaction where you can roll back a part of the transaction instead of the entire transaction.
11. A character used to separate fields or records within a flat file database, allowing for easy parsing and retrieval of data.
12. A process that reverses the effects of a transaction by applying the opposite changes recorded in the transaction log.
13. The quality or state of being closely connected or appropriate to a specific purpose or topic.
14. The property that ensures that committed transactions survive permanent system failures.
15. A type of database that stores data as objects, which have their own properties and behaviors.
16. The process of selecting the most efficient execution plan for a query in a database management system.