(Continued from previous part...)

166. What column differentiates the V$ views to the GV$ views and how?

The INST_ID column which indicates the instance in a RAC environment the information came from.

167. What command would you use to create a backup control file?

Alter database backup control file to trace.

168. Give two examples of referential integrity constraints.

A primary key and a foreign key.

169. What is schema?

A schema is collection of database objects of a User.

170. Describe Referential Integrity?

A rule defined on a column (or set of columns) in one table that allows the insert or update of a row only if the value for the column or set of columns (the dependent value) matches a value in a column of a related table (the referenced value). It also specifies the type of data manipulation allowed on referenced data and the action to be performed on dependent data as a result of any action on referenced data.

171. What is Hash Cluster?

A row is stored in a hash cluster based on the result of applying a hash function to the row’s cluster key value. All rows with the same hash key value are stores together on disk.

172. What is a Private Synonyms?

A Private Synonyms can be accessed only by the owner.

173. What is Database Link?

A database link is a named object that describes a “path” from one database to another.

174. What is a Tablespace?

A database is divided into Logical Storage Unit called tablespaces. A tablespace is used to grouped related logical structures together

(Continued on next part...)