Can someone answer these database questions? 1 - A(n)_____ specifically reserves
ID: 3842952 • Letter: C
Question
Can someone answer these database questions?
1 - A(n)_____ specifically reserves access to the transaction that locked the object.
2 - A(n)_____ lock exists when concurrent transactions are granted read access on the basis of a common lock
3 - What is a rule that applies to the two-phase locking protocol.
4 - A(n) ____ phase in a two phase lock is when transaction releases all locks and cannot obtain any new
5 - A(n) ____ condition occurs when two or more transactions wait for ach other to unlock data.
6 - The _____ approach to scheduling concurrent transactions assigns a global unique stamp to each transaction.
7 - In the wait/die scheme:
8 - In the optimistic approach, during the____ phase, a transaction scans the database, executes the needed computations, and makes the updates to a private copy of the database values.
9 - In the optimistic approach, during the____ phase, changes are permanently applied to the database.
10 - The _____ isolation level ensures that queries return consistent results.
11 - A(n) _______ occurs when a transaction executes a query at time T1, and it runs the same query at same time T2, yielding additional rows that satisfy the query
12 - A centralized database management is subject to a problem such as _____.
13 - A disadvantage of a distributed database management system (DDBMS) is that:
14 - A distributed database is composed of several parts known as database _____.
15 - Distributed processing does not require:
16 - A database management system needs _____ to prepare the data for presentation to the end user or to an application program.
Explanation / Answer
1.Exclusive
2.Shared
3.Two transactions can't contain conflicting locks
4.Growing
5.Database deadlock
6.Time stamping
7.old transactions wait for young one to finish and release blocks.
8.Read
9.Write
10.Repeatable read
11.Phantom read
12.complexity of management and control,security,lack standards..etc
13.Growing number of remote locations
14.fragments
15.distributed data base