Basic Oracle Concepts and Programming Question:

What Is the Relation of a User Account and a Schema in Oracle?

Tweet Share WhatsApp

Answer:

User accounts and schemas have a one-to-one relation. When you create a user, you are also implicitly creating a schema for that user. A schema is a logical container for the database objects (such as tables, views, triggers, and so on) that the user creates. The schema name is the same as the user name, and can be used to unambiguously refer to objects owned by the user.

Download Oracle Database PDF Read All 430 Oracle Database Questions
Previous QuestionNext Question
What Is a User Account in Oracle?What Is a User Role in Oracle?