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).
Describe the process that takes place to execute a stored routine.
Provide a brief introduction of the term ‘junk dimension’?
Describe the difference between a regular sub query and a correlated sub query?
Explain what are new in the BO 5.1?
Explain the term precision in Data Structures? Answer: Precision considers as to the accuracy of the decimal portion of a value. It is the number of digits permitted
Explain does PL/SQL carry overloading?
Write down a short note on the Global Temporary tables (GTT).
Briefly describe the term ‘BOMain.Key’?
Differentiates Tuple-oriented relational calculus and domain-oriented relational calculus?
What are some of the demerits related with conventional file processing systems?
18,76,764
1934678 Asked
3,689
Active Tutors
1423712
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!