.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

What is "Locking" concept in DBMS?

Posted By :Abhisek Panda     Posted Date :July 27, 2010    Points :10   Category :Sql Server 
Locking is the most common type of concurrency control mechanism. In this approach, any data is retrieved by an active user for updating, must be locked or denied to other users until updating is not complete.

You can also find related Interview Question to What is "Locking" concept in DBMS?  below: 

What is DBMS?

  
It is a collection of programs that enables user to create and maintain a database. In other words it is general-purpose software that provides the users with the processes of defining, constructing and manipulating the database for various applications. (More...)

Advantages of DBMS?

  
1.Redundancy is controlled.
2.Unauthorised access is restricted.
3.Providing multiple user interfaces.
4.Enforcing integrity constraints.
5.Providing backup and recovery. (More...)

Explain the concept of Reentrancy?

  
It is a useful, memory-saving technique for multiprogrammed timesharing systems. A Reentrant Procedure is one in which multiple users can share a single copy of a program during the same period. Reentrancy has 2 key aspects: The program code cannot modify itself, and the local data for each user process must be stored separately. Thus, the permanent part is the code, and the temporary part is the pointer back to the calling program and local variables used by that program. Each execution instance is called activation. It executes the code in the permanent part, but has its own copy of local variables/parameters. The temporary part associated with each activation is the activation record. Generally, the activation record is kept on the stack.

Note: A reentrant procedure can be interrupted and called by an interrupting program, and still execute correctly on returning to the procedure. (More...)

What is concept of Boxing and Unboxing ?

  
Boxing permits any value type to be implicitly converted to type object or to any interface type implemented by value type. Boxing is a process in which object instances are created and copy values in to that instance. Unboxing is vice versa of boxing operation where the value is copied from the instance in to appropriate storage location. Below is sample code of boxing and unboxing where integer data type is converted in to object and then vice versa.
Dim x As Integer
Dim y As Object x = 10
' boxing process
y = x
' unboxing process
x = y (More...)

What is Data Model concept?

  
Data Model is a collection of conceptual tools for describing data, data relationships data semantics and constraints. (More...)

What are all the difference between dbms and rdbms?

  
1.RDBMS DBMS+Refrential Integrity

2. An RDBMS ia one that follows 12 rules of CODD.

3. DBMS Doesnot follow the normalization while RDBMS follows the normalization. This is the major difference between them

4. In RDBMS we can add the foreign keys for relating the tables (More...)

What is LOCKING?

  
LOCKING is a synchronization mechanism for enforcing limits on access to a resource in an environment where there are many threads of execution.

Two phase locking
Shared locking
Indexing lock

are some of the types in LOCKING (More...)

How many types of locking mechanism is there?

  
Locking is the most common type of concurrency control mechanism.Locking is of three types,
1> Shared Lock(S)
2> Exclusive Lock(X)
3> Dead Lock(D) (More...)

How the concept of method overriding different from method overloading?

  
When overriding occurs on a method, you can change the behavior of the method for the class you have derived. Overloading a method involves in having another method with the same name within the class. (More...)

What is the concept of strong names ?

  
Strong name is similar to GUID(It is supposed to be unique in space and time) in COM
components.Strong Name is only needed when we need to deploy assembly in GAC. Strong
Names helps GAC to differentiate between two versions. Strong names use public key cryptography
(PKC) to ensure that no one can spoof it.PKC use public key and private key concept. (More...)

What is concept of Boxing and Unboxing?

  
Boxing permits any value type to be implicitly converted to type object or to any interface type
implemented by value type. Boxing is a process in which object instances are created and copy
values in to that instance.

Unboxing is vice versa of boxing operation where the value is copied from the instance in to
appropriate storage location. (More...)

The concept of states in ASP.NET

  
State is quite an innovative concept in Web development because it eliminates the drawback of losing state data due to reloading of a Web page. By using states in a Web application, you can preserve the state of the application either at the server or client end. The state of a Web application helps you to store the runtime changes that have been made to the Web application. (More...)

What is the concept of Postback in ASP.NET.

  
A postback is a request sent from a client to server from the same page user is already working with.

ASP.NET was introduced with a mechanism to post an HTTP POST request back to the same page. It's basically posting a complete page back to server (i.e. sending all of its data) on same page. So, the whole page is refreshed. (More...)

What is concept of strong names ?

  
While using shared assemblies, in order to avoid name collisions strong names are used. Strong Names are based on private key cryptography , ie private assemblies are simply given the same name as their main file name. (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

 
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.


Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend