What is public database link ?
Public database link is created for the special user group PUBLIC. A public database link can be used when any user in the associated database specifies a global... Read more »
Archive for May, 2008
What is private database link ?
Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name... Read more »
Do a view contain data ?
Views do not contain or store data. Read more »
What are Schema Objects ?
Schema objects are the logical structures that directly refer to the database’s data. Schema objects include tables, views, sequences, synonyms, indexes, clusters,... Read more »
What is schema ?
A schema is collection of database objects of a user. Read more »
Explain the relationship among database, tablespace and data file ?
Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace. Read more »
What is SYSTEM tablespace and when is it created ?
Every Oracle database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the... Read more »
What are the components of logical database structure of Oracle database
There are tablespaces and database’s schema objects. Read more »
What are the components of physical database structure of Oracle database ?
Oracle database is comprised of three types of files. One or more datafiles, two are more redo log files, and one or more control files. Read more »