Please send your Questions & Answers or Feedback to "mohan@javabook.org"

What is data block ?

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.

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.

Related Posts Plugin for WordPress, Blogger...

Flag Counter