Oracle database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.
Mohan's OracleDBA Interview Questions
OracleDBA Interview Questions
Please send your Questions & Answers or Feedback to "mohan@javabook.org"
What is data block ?
What is network database link ?
Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies a global object name in a SQL statement or object definition.
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 object name in a SQL statement or object definition.
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 in a SQL statement or in the definition of the owner's views or procedures.
What are the types of database links ?
Private database link, public database link & network database link.