Multiple choice technology delivery

Which of the following is not a schema object in oracle?

  1. Indexes

  2. Tables

  3. public synonyms

  4. triggers

  5. Packages
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Public synonyms are not owned by any specific user schema - they exist in the database namespace and are available to all users. Private synonyms (like indexes, tables, triggers, packages) are schema objects owned by specific users. The distinction is that public synonyms lack a schema prefix in their naming convention.

AI explanation

Public synonyms are not schema objects in Oracle — they aren't owned by any individual user/schema (they belong conceptually to PUBLIC and are stored in the data dictionary independent of a schema), unlike private synonyms which are schema objects. Tables, Indexes, Triggers, and Packages are all standard Oracle schema objects, owned by and residing within a specific user's schema, so they're correctly excluded from the answer.

Keep practicing — related questions