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).
What do you understand by the term deadlock in DBMS? How can it be avoided? How can it be solved once it happens?
In JDBC driver which coding pattern is use? Describe briefly?
State the term Sybase 365.
Explain what are the roles performed by the SQL?
Write a short note on the difference between embedded and dynamic SQL?
State the term Open switch business continuity software?
Define the way of passing of variables to a SQL routine.
Define the term merge stage?
Describe in brief some of the criticism regarding Sybase IQ?
Specify different types of transformations available in the Informatica?
18,76,764
1957902 Asked
3,689
Active Tutors
1434474
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!