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

How do you bind variables in pl sql?

1093

How do you write a subquery?

1024

Is t sql a programming language?

1064

What is the primary use of normalization?

1002

what is the difference between char_length and length? : Sql dba

1044

What are secondary keys?

971

Do we need to create index on primary key?

929

how to load data files into tables with 'mysqlimport'? : Sql dba

1091

What is pessimistic concurrency control? : Transact sql

1086

what is subquery? : Sql dba

1132

What is mdf ldf and ndf?

999

How do you delete duplicates in sql query using rowid?

946

What is fmtonly in sql?

1082

Which type of cursor is used to execute the dml statement?

957

What port does sql server use?

1060