What is a Schema ?

Answer Posted / gmv lakshmi

A Schema is a collection of logical structures of data, or
schema objects. A schema is owned by the database user and
has the same name as that of user. Each user owns a single
schema. Schema objects include following type of objects
clusters, database links, functions, indexes, packages,
procedures, sequences, synonyms, tables, database triggers,
views.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to turn on or off recycle bin for the instance?

593


Explain temporal data types in oracle

587


Can we create database in oracle using command line ?

573


How to filter out duplications in the returning rows using oracle?

625


What is a dead lock in oracle?

579






What is flashback in Oracle?

571


How to connect to a local oracle 10g xe server?

520


how may join possible between (requisition with purchase order)

1686


How to export several tables together?

552


What is a nvl function? How can it be used?

547


candidate key is subset of super key but not vice-verse explain

1567


What is control file used for?

590


How to drop an existing table in oracle?

581


What is a proxy class?

543


What is analyze command used for?

563