Database Administration - What are the characteristics of data files

GeekInterview.com > Interview Questions > Oracle > Database Administration

Go To First | Previous Question | Next Question

Database Administration | Question 44 of 231

What are the characteristics of data files

Total Answers and Comments: 5

Last Update: July 30, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: sri

Characterstics of Data File :
- A Data file can be associated with only one database.
- Once created, a data file cannot change is size.
- One or more data files form a logical unit of database storage called a Tablespace.

Above answer was rated as good by the following members:
koagyeman

August 04, 2005 13:53:31

sri

RE: What are the characteristics of data files

Characterstics of Data File :
- A Data file can be associated with only one database.
- Once created a data file cannot change is size.
- One or more data files form a logical unit of database storage called a Tablespace.

Is this answer useful? Yes | No

1 2

Overall Rating: -1

October 05, 2005 05:26:58

Bahurudeen

RE: What are the characteristics of data files

Datafile size can be change by using ALTER DATABASE .................RESIZE command

Is this answer useful? Yes | No

June 06, 2008 23:28:33

deepikadba

Member Since: June 2008 Contribution: 2

RE: What are the characteristics of data files

1.datafiles r used to store data
2.datafile can be resized but it can be increased in size but not shrinked

Is this answer useful? Yes | No

July 11, 2008 06:36:13

alex.v

Member Since: July 2008 Contribution: 4

RE: What are the characteristics of data files

datafiles can be resized to a lower size also but till the used space....

Is this answer useful? Yes | No

July 29, 2008 11:50:50

srinivasanram2004

Member Since: July 2008 Contribution: 7

RE: What are the characteristics of data files

Characteristics of a Data File :

- A Data file can be associated with only one tablespace.

- Once created a datafile can be increased or decreased in size with RESIZE
command. Example: ALTER database datafile '/u03/oradata/dev01/users_02.dbf'
RESIZE 150 MB ;

- Once created a datafile cannot be dropped. It can only be shrunk to an
insignificant size.

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

Ram Srinivasan

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank