Answer Posted / javeed_mj
An Oracle database consists of one or more logical storage
units called tablespaces, which collectivley store all of
the database's data.
Each tablespace in an ORACLE database consists of one or
more files called datafiles, which are physical structures
that conform with the operating system in which Oracle is
running.
For Example::: A simple Oracle Database have one tablespace
and one datafile
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How does the on-delete-cascade statement work?
What is the difference between primary key and unique key and foreign key in oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Explain what are the type of synonyms?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
Give the various exception types.
Why use resource manager in Oracle?
Is a rollback possible to any savepoint?
What are the four Oracle system processes that must always be up and running for the database to be useable?
How to select some columns from a table in oracle?
How do I connect to oracle?
What is oracle rownum?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What is the difference between sharding and partitioning?
What is a Garbage Collection? and what is full recursive Garbage collection?