Characteristics of Data Files in oracle

          

Explain the characteristics of Data Files in oracle.

<<Previous  Next>>

Oracle - Explain the characteristics of Data Files in oracle - April 10, 2009 at 11:00 AM

Explain the characteristics of Data Files in oracle.

One or more data files form a logical unit of database storage called a tablespace.

The size of the data file can't be changed once it is created.

Also read
Oracle file types

A control file contains information such as location of redo log files, backup data and redo log information..........

Explain the characteristics of Data Files in oracle.

One or more data files form a logical unit of database storage called a tablespace...........

Difference between a hot backup and a cold backup

Cold Backup : In this type of backup, after the database is shut down, DBA exits the SVRMGR utility and copies the log files, data files and control files onto a backup media...........

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