Concepts and Architecture Question:
Download Job Interview Questions and Answers PDF
What are the Characteristics of Data Files in Oracle?
Answer:
A data file is created when a 'create tablespace' or 'alter tablespace' command is executed. Creating a data file of size 10MB actually allocates 10MB space on the hard disk. If a tablespace is declared to contain 100 data files, one slot per data file is reserved in the control file. There are four types of data files -- system data files, application (or user) data files, temporary data files (used by oracle to store temp data while executing complex SQL statements) and rollback data files.It is possible to resize a datafile. The command which will serve this purpose is
Download Oracle Architecture and Concepts Interview Questions And Answers
PDF
Previous Question | Next Question |
What is a Private Synonyms in Oracle? | What is high watermark in oracle? |