what are different types of locks?

Answer Posted / bibhuti bhusan patra

implicit locks & explicit locks
implicit locks are maintained by oracle internally.
&explicit locks are performed by user manualy.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is truncate oracle?

535


Explain oracle’s system global area (sga).

629


How to check your oracle database 10g xe installation?

581


State all possible different index configurations a table can possibly have?

572


What is the relation of a user account and a schema?

617






How to see free space of each tablespace?

596


How to call a stored function in oracle?

574


How to insert a new row into a table in oracle?

593


How will you write a query to get a 5th rank student from a table student_report?

1381


What is hot backup and logical backup?

612


How do I spool to a csv formatted file using sqlplus?

550


What is execute immediate in oracle?

549


when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1477


Difference between cartesian join and cross join?

545


Explain how you would restore a database using RMAN to Point in Time?

1641