Multiple choice technology databases

Oracle server generates a name by using which format

  1. sys_cn

  2. ora_cn

  3. tab_cn

  4. col_cn

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

When a constraint is created in Oracle without explicitly naming it, Oracle automatically generates a system constraint name in the format SYS_Cn where n is an incremental number. For example: SYS_C1234, SYS_C5678. This distinguishes system-generated names from user-defined constraint names.