Answer Posted / a.brahmam
mainly two types of locks
1.Row Level Locks
2.Table Level Locks
Table Level Locks Are Two Types
-------------------------------------------------
1.Share Lock
2.Exclusive Lock
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between post-database commit and post-form commit?
What are the different types of database objects?
What is connection pooling in oracle?
What is bulk load in oracle?
How to omit columns with default values in insert statement in oracle?
How index is implemented in oracle database?
How do I manually uninstall oracle client?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What is a snapshot in oracle database?
What is the use of oracle?
What is the difference between online and offline backups?
What is a Garbage Collection? and what is full recursive Garbage collection?
How to define a variable to match a table column data type?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?