What is a schema?

          

What is a schema?

<<Previous  Next>>

Oracle - What is a schema? - Feb 07, 2010 at 14:20 PM by Shuchi Gauri

What is a schema?

A schema is a collection of database objects. Schema objects are logical structures created by users to contain data. Schema objects include structures like tables, views, and indexes.

Oracle - What is a schema? - April 10, 2009 at 11:00 AM

What is a schema?  

Schema represents structure of the database. Database has two main types of schemas partitioned.

Physical schema: Describes the database design at the physical level.
Logical Schema: Describes the database design at the logical level.

Logical Schema is important from a programmer’s point of view since it is used extensively during software development.

Oracle - What is a schema? - June 18, 2009 at 17:00 PM

The set of objects owned by user account is called the schema.

Also read

Explain how to list all indexes in your schema.

The list of all indexes in a schema can be obtained through the USER_INDEXES view with a SELECT statement:...........

What are Schema Objects?

Schema objects are the logical database structure that represents database's data. Schema objects include tables, views, sequences, synonyms, indexes, clusters, database............

What is an Archiver?

Archiving is the process of removing of old data and unused data from the main databases. This process keeps databases smaller, more manageable and thus acquires..............

<<Previous  Next>>



Write your comment - Share Knowledge and Experience


 

 
Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring