Explain the relationship among Database, Tablespace and Data
file?
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 table index?
In Oracle 9i what does "i" Stands for?
how to genarate random numbers in oracle for particular row?
Does oracle charge for java?
When a form is invoked with call_form, Does oracle forms issues a save point ?
Calculate difference between 2 date / times in oracle sql?
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)
Describe Referential Integrity ?
can a table has a column that has only view data and in other columns we can change data?
What is recycle bin in Oracle?
Which database is better for os platform dependency?
How to open a cursor variable?