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

What is dense_rank in sql?

1045

What is record data type?

981

What are the two different parts of the pl/sql packages?

1141

what are the advantages of using stored procedures? : Sql dba

1157

Which is better join or inner query?

1128

Is sql a programming?

1028

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1206

explain access control lists. : Sql dba

1050

Can I create table without primary key?

1044

Which constraints we can use while creating database in sql?

1121

How do you optimize a stored procedure in sql?

1019

Explain the working of primary key?

1155

how do you know the version of your mysql server? : Sql dba

1048

How do rank () and dense_rank () differ?

1109

What do you mean by “trigger” in sql?

1130