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).
Elucidate how can we get first 100 rows from flat file in the target?
Explain what is meant by the repository and what does it consists of?
How can we do unit testing into the informatica? How to load data in the informatica?
Illustrates the cold backup in case of Oracle?
Write down the snapshot with reference to data warehouse?
Is the shortest distance between any 2 specified nodes is given by minimum spanning tree?
State the difference between OLTP and OLAP?
What is Data Manipulation Language Compiler?
States the term Mirror Activator Disk mirroring?
Explain the term Coalesce. Answer: Coalesce is also obtainable in Sybase, this function estimates the listed expressions and returns the first non-null value.
18,76,764
1934626 Asked
3,689
Active Tutors
1444190
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!