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
Views do not contain or store data.
Latest Answer :  Hi,  It depends on the type of view it is. if it is a normal view than it does not contains the data. and if it is materialsed view than it contains the data. Thanks sanjay pramanik ...
Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table.Hide data complexity.Simplify commands for the user.Present the data in a different
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
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
The data dictionary of an ORACLE database is a set of tables and views that are used as a read-only reference about the database.It stores information about both the logical and physical structure of the
Latest Answer : Data Dictionary is a read-only set of tables that provides information about the database. in order to avoid the I/O cost, these data dictionary views are used ...
A materialized view is a replica of a target master from a singlepoint in time. The concept was first introduced with Oracle7 termed asSNAPSHOT. In Oracle release 7.1.6 snapshots were enhanced to enableDMLs
Latest Answer : Both are mirror copy of tables but in that main difference is in snapshot we cannot edit the data. in the case of materialized view we can edit the data. ...
