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).
Write down the differentiation between Informatica8.0 and 7.0?
Write down the purpose of Fact-less Fact Table?
Give a brief differentiation between metadata and data dictionary?
What do you understand by the term foreign key in DBMS, and why is it employed for?
Can you explain how to install an SSIS package?
Explain what is meant by the term universe stage?
Illustrates the term Table Partitioning in detail? Answer: If you wish for to decrease page contention you do not require multiple devices. You should use multiple d
Write a short note on the difference between embedded and dynamic SQL?
Explain some of the reasons which someone familiar with Microsoft Access will desire to learn VBA?
Specify the user profiles within the Supervisor?
18,76,764
1930845 Asked
3,689
Active Tutors
1426964
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!