Multiple choice technology databases

Which two are valid locking levels that are used by transactions in oracle database? (Choose two)

  1. Object level.

  2. Row level.

  3. Block level.

  4. Schema level.

  5. Database level.
Reveal answer Fill a bubble to check yourself
A,B Correct answer
Explanation

Row-level locking is the most granular and commonly used locking mechanism in Oracle, allowing concurrent transactions to access different rows. Object-level locking applies to entire tables, views, or other schema objects and is used for DDL operations or table locks. Block-level, schema-level, and database-level locking are not standard Oracle locking granularity levels.

Keep practicing — related questions