Part-6

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.

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.

What is a Private Synonyms? -

A Private Synonyms can be accessed only by the owner.

What is Database Link? -

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

What is a Tablespace? -

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

What is Rollback Segment? -

A Database contains one or more Rollback Segments to temporarily store “undo” information.