What are the various locking levels available ?
PAGE, TABLE, TABLESPACE
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Explain MySQL locks. 07.01.09
Table-level locks allow the user to lock the entire table, page-level locks allow locking of certain portions of the tables (those portions are referred to as t...What is Data warehosuing Hierarchy? 20.09.08
Hierarchies Hierarchies are logical structures that use ordered levels as a means of organizing data. A hierarchy can be used to define data aggregation. For e...What is meant by locking ? 26.07.08
Locking is a process that is used to ensure data integrity. It also prevents concurrent users from accessing inconsistent data. The data (row) is locked until...What is meant by locking ? 26.07.08
Locking is a process that is used to ensure data integrity. It also prevents concurrent users from accessing inconsistent data. The data (row) is locked until...What is RAID and what are different types of RAID configurations? 09.05.08
RAID stands for Redundant Array of Inexpensive Disks, used to provide fault tolerance to database servers. There are six RAID levels 0 through 5 offering differ...Name the four different cursor and locking types in ADO and describe them briefly ? 18.04.07
CURSORS:: The cursor types are listed from least to most resource intensive. Forward Only - Fastest, can only move forward in recordset Static - Can move to...What is Concurrency Testing? 27.02.07
Multi-user testing geared towards determining the effects of accessing the same application code, module or database records. Identifies and measures the level...Why are there five tracing levels in System.Diagnostics.TraceSwitcher? 18.02.07
The tracing dumps can be quite verbose. For applications that are constantly running you run the risk of overloading the machine and the hard drive. Five le...Why are there five tracing levels in System.Diagnostics.TraceSwitcher? 26.03.06
The tracing dumps can be quite verbose and for some applications that are constantly running you run the risk of overloading the machine and the hard drive ther...Why are there five tracing levels in System.Diagnostics.TraceSwitcher? 14.03.06
The tracing dumps can be quite verbose. For applications that are constantly running you run the risk of overloading the machine and the hard drive. Five le...