Explain the relationship among Database, Tablespace and Data
file?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the oracle implicit cursor?

596


Does oracle charge for java?

591


Explain the use of Merge statement in oracle 11g

598


What is the maximum number of triggers that can be applied to a single table?

560


Is a rollback possible to any savepoint?

556






What to do if dba lost the system password?

601


Why do we use coalesce function in oracle?

631


How to convert csv to table in oracle?

528


Can a formula column be obtained through a select statement ?

1845


How to calculate date and time differences in oracle?

533


What is data file?

619


What is query image?

586


master table and child table performances and comparisons in Oracle ?

1668


Explain oracle data types with examples?

577


What is transaction control statement and how many types of transaction control statement in Oracle?

565