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).
Explain the terms SQL Server and adaptive server enterprise?
Clarify briefly why dimension tables is de-normalized in the nature?
Illustrate the five SQL built-in functions.
States the term Mirror Activator Disk mirroring?
Specify the various components of the Report Net?
Write down brief note on the differentiation between dynamic cache and static cache?
Specify the various advantages of the Lookup persistent cache?
Explain the uses of stored procedure?
Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows: ¦ Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genre
Illustrates a stored procedure?
18,76,764
1928374 Asked
3,689
Active Tutors
1432095
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!