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 |
State all possible different index configurations a table can possibly have?
what is reindexing?
Can you have more than one content canvas view attached with a window ?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Are truncate and delete commands same? If so why?
which language is used to develop the oracle........?
How to recover a dropped table in oracle?
What is use of oracle?
Which environment variables are absolutely critical in order to run the OUI?
What is the difference between post-database commit and post-form commit?
What is the oracle implicit cursor?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?