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

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

525

What is the use of index in sql?

543

Which join is like an inner join?

517

Why we use cross join?

532

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

658

What is a temporal table?

483

What is #table in sql?

511

How many scalar data types are supported in pl/sql?

512

What is the difference between delete, truncate and drop command?

540

What does where 1/2 mean in sql?

521

Can we use rowid as primary key?

535

Who is the owner of mysql database?

545

Explain the update statement in sql

554

What is the starting oracle error number?

558

What is difference between sql and oracle?

551