Multiple choice technology

Which statements are true regarding tables?

  1. A table name can be of any length.

  2. A table can have any number of columns.

  3. A table and a synonym can have the same name in the same schema

  4. The same table name can be used in different schemas in the same database

Reveal answer Fill a bubble to check yourself
C,D Correct answer
Explanation

Oracle has specific limits on table structures. Table names cannot be of unlimited length (typically max 30 characters in Oracle). Tables also have a maximum column limit (typically 1000 columns). A table and a synonym CAN share the same name in the same schema because they exist in different namespaces. The same table name CAN be used in different schemas within the same database, as schemas provide name isolation.