Explain the relationship among Database, Tablespace and Data
file?
- 4 Answers
- 10894 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 |
How to create a new oracle data file?
How to omit columns with default values in insert statement in oracle?
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
why pl sql doesn't support retrieving multiple records
How to get maxsal , minsal, ename department wise in single query
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
Explain integrity constraints?
What are the types of partitions in oracle?
what is analyze command ? what kind of statistics does it generate?
Explain a private synonyms?
How to change user password in oracle?
What happens to the data files if a tablespace is dropped?
Oracle General 
