-
-
What is meant by deadlock in database?
Transaction is unit of work done. So a database management system will have number of transactions. There may be situations when two or more transactions are put into wait state simultaneously .In this position each would be waiting for the other transaction to get released. Suppose we have two transactions one and two both executing simultaneously. In transaction numbered one we update student table...
-
-
-
Explain about TNSPING
You can also use tnsping utility on command prompt to check Oracle Net connectivity. Follow these steps to check the connection to particular SID.Open Command prompt.Write tnsping < SID for the database connectivity you want to check >If you get the message “Used TNSNAMES adapter to resolve the alias” then tnsping utility is able to resolve the service name.If you get “TNS-03505: Failed to resolve...
-