Schema objects are the logical structures that directly refer to the database's data. Schema objects include tables, views, sequences, synonyms, indexes, clusters, database triggers, procedures, functions
There are two types of Synonyms Private and Public.
A Private Synonyms can be accessed only by the owner.
Public synonyms can be accessed by any user on the database.
Synonyms are used to : Mask the real name and owner of an object.Provide public access to an objectProvide location transparency for tables, views or program units of a remote database.Simplify the SQL
An Extent is a specific number of contiguous data blocks, obtained in a single allocation, and used to store a specific type of information.
Latest Answer : An extent is a logical unit of database storage space allocation made up of a number of contiguous data blocks. One or more extents in turn make up a segment. When the existing space in a segment is completely used, Oracle allocates a new extent for the ...
Data Segment, Index Segment, Rollback Segment and Temporary Segment.
Latest Answer : Data, index , rollback, undo,cluster ...
NOT NULL Constraint - Disallows Nulls in a table's column.UNIQUE Constraint - Disallows duplicate values in a column or set of columns.PRIMARY KEY Constraint - Disallows duplicate values and Nulls
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
Latest Answer : Referential integrity is a relationship between two tables, one being the 'parent' and the other being the 'child'. The 'child' table references values in the 'parent' table's primary key to ensure all data between ...
