 Related Questions ORACLE database is comprised of three types of files. One or more Data files, two are more Redo Log files, and one or more Control files. Latest Answer : The components of a Physical Structure of a Database are as Follows:1.Control Files2.Redolog Files3.Data Files. ... Every ORACLE database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database. Latest Answer : Every Oracle Database contains a tablespace called system tablespace.This tablespace gets created at the time of database creation and it holds data dictionary information for the entire database. ... Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace. Latest Answer : Databases, tablespaces, and datafiles are closely related, but they have important differences:1) An Oracle database consists of at least two logical storage units called tablespaces, which collectively store all of the database's data. You must have ... 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 A table is the basic unit of data storage in an ORACLE database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns. Latest Answer : Table is data base object which stores the data in the logical representatiom in form of rows n coluns which is existing in two dimension form... and is stored in the databse. ... 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 ... 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 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 .. ... An Index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
