What is a Schema ?

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

Showing Answers 1 - 2 of 2 Answers

sithusithu

  • Jan 9th, 2006
 

Three type of schema.....

 

Star schema

A single fact table with N number of Dimension

 

Snowflake schema

Any dimensions with extended dimensions are know as snowflake schema

 

Multiple Star (galaxy)

If the schema has more than one fact table then the schema is said to be Multiple star

 

Cheers,

Sithu

  Was this answer useful?  Yes

A schema is a collection of components and database objects under the control of a given database user. Each Oracle Portal application maps to an Oracle database schema. The schema stores the components owned by the application. In addition, the schema can store the database objects on which the components are based.

You can map an application to schemas currently in the Oracle database where Oracle Portal is installed. When you create the schema, you must select the Application Schema check box to designate that applications can be built in the schema.

Sriniv@s..

  • Jun 20th, 2012
 

Schema is a set of objects own by a Particular user..

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions