Question 81 :
What is a Synonym ?
A synonym is an alias for a table, view, sequence or program unit.
Question 82 :
What is a Sequence ?
A sequence generates a serial list of unique numbers for numerical columns of a database's tables.
Question 83 :
What is a Segment ?
A segment is a set of extents allocated for a certain logical structure.
Question 84 :
What is schema?
A schema is collection of database objects of a User.
Question 85 :
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.