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 |
cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
What is difference between Rename and Alias?
How do I connect to oracle?
In Oracle 10g, "g" Stands for what?
Query to retrieve record for a many to many relationship ?
What is program global area (pga) in oracle?
How to enter a new row into a table interactively?
how to use sequence and what use of sequence cache
Explain what are synonyms used for?
What is Hash Cluster ?
What are the Referential actions supported by FOREIGN KEY integrity constraint ?
What is the use of Redo Log Information ?