A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)
Latest Answer : View is a Virtual Table. It likes like a table. View provide additional level tabel security and providing selected columns only and it accessing different tables no need to joins of different tables. Views also stores data like (Materialized Views) ...
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 ...
Yes.
A synonym is an alias for a table, view, sequence or program unit.
Latest Answer : ya synonym is used to rename or to create alias for the data base object .. ...
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.
Latest Answer : Hash Clusters cluster table data in a manner similar to normal, index clusters. To find or store a row in a hash cluster, Oracle applies a hash function to the row's cluster key value. The resulting hash value corresponds to a data block in the cluster.All ...
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. ...
