ddl locks dml locks oracle internal locks oracle distributed locks orac

Types of locks in database ?

Question Posted / narasimha rao

Answer Posted / narasimha rao

ddl locks
dml locks
oracle internal locks
oracle distributed locks
oracle parallell cache management locks

Is This Answer Correct ?

10 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Which is better join or inner query?

1014

Can we use distinct and group by together?

1025

How do you identify a primary key?

1044

What are the usages of sql?

1046

What are the different ddl commands in sql?

1129

What are the different types of joins in sql?

1732

What does the argument [or replace] do?

1063

Is delete faster than truncate?

993

what is 'trigger' in sql? : Sql dba

1065

Can we use loop in sql?

956

How do I truncate a sql log file?

1053

what are the types of join and explain each? : Sql dba

1022

Why do we use joins in sql?

956

What is embedded sql with example?

1018

What is sql data?

972