Set - 7

Question 91 :

When can hash cluster used?

Answer :

Hash clusters are better choice when a table is often queried with equality queries. For such queries the specified cluster key value is hashed. The resulting hash key value points directly to the area on disk that stores the specified rows.


Question 92 :

When can hash cluster used?

Answer :

Hash clusters are better choice when a table is often queried with equality queries. For such queries the specified cluster key value is hashed. The resulting hash key value points directly to the area on disk that stores the specified rows.


Question 93 :

What are the types of database links?

Answer :

Private database link, public database link & network database link.


Question 94 :

What is private database link?

Answer :

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.


Question 95 :

What is public database link?

Answer :

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.