What do you understand by the term locking in DBMS
What do you understand by the term locking in DBMS?
Expert
Locking is denying others the ability to update a record till someone completes the releases or update the record. Locking can happen on many different levels in a database. It can happen at the database, record, table, or field level. A lock can be shared (or another can read the record while an update is in progress) or exclusive (or no one can read the record while an update is in progress).
Why recursive relationships are not good? How do you solve them?
Cloud Computing – A computing capability that provides an abstraction between the computing resource and its underlying technical architecture (e.g., servers, storage, networks), allowing convenient, on-demand network access to a shared pool of
Describe the some drawbacks of a standard language like SQL?
How can you save the Business Objects document that may be accessed by all the users in the workgroup mode?
Write down the level of Granularity of a fact table?
Specify different types of transformations available in the Informatica?
Elucidate how many kinds of dimensions are accessible in the Informatica?
List out the regions in which data structures are applied widely?
Illustrate in brief some of the products of the Sybase?
Describe briefly the difference between a shared lock and an exclusive lock?
18,76,764
1953129 Asked
3,689
Active Tutors
1445909
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!