Explain the relationship among Database, Tablespace and Data
file?
- 4 Answers
- 11544 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 find out second largest value in the table
what is the use of composite key constraint?
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
Explain an index?
How to use "while" statements in oracle?
How you find out version of installed workflow?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What are the advantages of oracle?
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
17. Display the order number and average item cost for each order.
How to use "out" parameter properly?
How to manage transaction isolation level?
Oracle General 
