What Is An Oracle Schema?

1.	What Is An Oracle Schema?
Answer» A user account and its associated DATA including tables, views, indexes, clusters, sequences,procedures, functions, triggers,packages and database links is known as Oracle SCHEMA. SYSTEM, SCOTT etc are default schema's. We can create a new Schema/User. But we can't DROP default database schema's. A user account and its associated data including tables, views, indexes, clusters, sequences,procedures, functions, triggers,packages and database links is known as Oracle schema. System, SCOTT etc are default schema's. We can create a new Schema/User. But we can't drop default database schema's.

Answer»

A user account and its associated DATA including tables, views, indexes, clusters, sequences,procedures, functions, triggers,packages and database links is known as Oracle SCHEMA. SYSTEM, SCOTT etc are default schema's. We can create a new Schema/User. But we can't DROP default database schema's.

A user account and its associated data including tables, views, indexes, clusters, sequences,procedures, functions, triggers,packages and database links is known as Oracle schema. System, SCOTT etc are default schema's. We can create a new Schema/User. But we can't drop default database schema's.

Discussion

No Comment Found

Related InterviewSolutions

How Do You Use A Pointer To A Function?
What Is Size Of Void Pointer?
Write A C Program To Find Size Of Structure Without Using Sizeof Operator?
What Is The Meaning Of Prototype Of A Function?
What Is Wild Pointer In C?
What Is Dangling Pointer In C?
Write A C Program To Swap Two Variables Without Using Third Variable ?
In C, What Is The Difference Between A Static Variable And Global Variable?
Is Using Exit() The Same As Using Return?
Why Does Pascal Matter? Is There Any Benefit To Using Pascal Functions?