Components of logical database structure of database


Components of logical database structure

<<Previous  Next>>

Oracle - Components of logical database structure of Oracle database - Feb 18, 2010 at 11:00 AM by Rajmeet Ghai

Components of logical database structure of Oracle database  

Database's schema objects. 

Tablespace: A tablespeace is a logical unit of storage of a database on which the datafile resides. It is not visible in the system, hence logical. Each table, index etc is associated with a tablespace. There are three different types of tablespaces:-

  • Permanent
  • Temporary
  • Undo

Database Schema objects: Schema objects consist of database triggers, operators, sequences, indexes, and stored procedures etc that together comprise a schema. A schema is a logical structure of data and such schema objects. Schema objects are stored logically in a tablespace of the database. Data for these objects is present in a data file.

Also read
Oracle architecture

Describe Oracle architecture in brief, What is the function of SMON?, Explain different types of segment, Explain SGA memory structures..............

Oracle auditing

Session auditing, Statement auditing, Privilege auditing, Object auditing.............

Oracle backup

Describe the Oracle backup, i.e. archive log mode, cold and hot backups, incremental backups.............

Oracle processes

User process – User process is used in invocation of application software, Data writing process - A database writer process is used to write buffer content into a datafile. They are specifically used to write “dirty block” to data files from the buffer................

<<Previous  Next>>

Write your comment - Share Knowledge and Experience


Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring