7.Which option arranges the following memory types in order of decreasing access speed (fastest to slowest): I. RAMII. CPU Registers III. Cache MemoryIV. Hard Disk Drive (A) II, III, I, IV (B) III, II, I, IV (C) II, I, III, IV (D) IV, I, III, II

10.In a multi-user database environment, complex interactions between simultaneous transactions can lead to undesirable outcomes such as "lost updates" (where one transaction's changes are overwitten by another), "dirty reads" (where a transaction reads uncommitted data from another transaction), and "inconsistent reads" (where a transaction reads different values for the same data item at different points in time). Which core aspect of database management, typically managed within the database architecture, is primarily responsible for addressing and preventing these types of anomalies? (A) Indexing, which optimizes data retrieval by creating sorted pointers to data records, thereby speeding up query execution and reducing the likelihood of data conflicts. (B) Relational Algebra, which provides a theoretical foundation for querying and manipulating data in relational databases, enabling structured data operations. (C) Concurrency Control, which employs various mechanisms to manage the interleaved execution of transactions, ensuring data integrity and transaction isolation. (D) B-trees, a tree data structure used for efficient storage and retrieval of data on disk, enabling fast lookup, insertion, and deletion operations within a database.

7.Which option arranges the following memory types in order of decreasing access speed (fastest to slowest): I. RAM
II. CPU Registers
III. Cache Memory
IV. Hard Disk Drive
(A) II, III, I, IV
(B) III, II, I, IV
(C) II, I, III, IV
(D) IV, I, III, II

相關試題

相關試卷