Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the relationship among Database, Tablespace and Data
file?
- 4 Answers
- 12724 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chaudhry
Each databases logically divided into one or more
tablespaces One or more data files are explicitly created
for each tablespace.
| Is This Answer Correct ? | 8 Yes | 2 No |
Each data base is divided into logical units called table
spaces and each table space is again divided into segments.
Data files are created for table spaces.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nishi
database contain atleast one tablespace and tablespace must have atleast one datafile
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / riddhi
An Oracle database consists of one or more logical storage
units called tablespaces.
tablespaces is consist of one or more datafiles.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the difference between functional dependecy and multilevel dependency?
How to create a server parameter file?
What is the quickest way to fetch the data from a table?
How to write text literals in oracle?
What is raw datatype in oracle?
difference between truncate and delete ,drop?
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What do you mean by redo log file mirroring?
How to use subqueries with the in operator using oracle?
What is cluster Key ?
How to declare a local variable?
Oracle General 
