Technical Interview Questions
When the database is created in Oracle database system, it automatically generate a SYSTEM named SYSTEM tablespace. The SYSTEM tablespace contains data dictionary tables for the entire database. In Oracle, the SYSTEM tablespace is a special tablespace that is automatically created when a new database is created. It is used to store the data dictionary, … Read more
A database contains Logical Storage Unit called tablespaces. A tablespace is a set of related logical structures. Actually a tablespace groups related logical structures together. In Oracle, a tablespace is a logical storage container that is used to organize and manage the physical storage of data within a database. It is a collection of one … Read more
Components of logical database structure. Tablespaces Database’s schema objects In Oracle database, the logical database structure consists of the following components: Table: Tables are the basic unit of data storage in Oracle. They store data in rows and columns. View: A view is a virtual table that is based on the result of a SELECT … Read more
Components of physical database structure are given below. One or more data files. Two or more redo log files. One or more control files. The physical database structure of an Oracle database consists of the following components: Datafiles: These are the actual physical files on disk where the data is stored. An Oracle database is … Read more