Question

When DDL operations are performed, Oracle 12c will automatically place a(n) shared lock on the table.

a) Exclusive lock
b) Read lock
c) Write lock
d) No lock

Answer 1

When DDL operations are performed in Oracle 12c, a write lock is automatically placed on the table to prevent concurrent modifications.

Step-by-step explanation:

When DDL operations are performed in Oracle 12c, a write lock is automatically placed on the table. This is to prevent concurrent transactions from modifying the table while the DDL operation is in progress. A write lock ensures that only one transaction can write to the table at a time, while blocking any other transactions that attempt to write to the table.