Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / m.m
Tablespace:
A database storage unit that groups related logical
structures together.
logical structures:
Logical structures of an Oracle database include table
spaces, schema objects, data blocks, extents, and segments.
Because the physical and logical structures are separate,
the physical storage of data can be managed without
affecting the access to logical storage structures.
physical structures:
Physical database structures of an Oracle database include
data files, redo log files, and control files.
data block:
Smallest logical unit of data storage in an Oracle
database. Also called logical blocks, Oracle blocks, or
pages. One data block corresponds to a specific number of
bytes of physical database space on disk.( a common block
size is 8k)
extent:
Second level of logical database storage. An extent is a
specific number of contiguous data blocks allocated for
storing a specific type of information.
segment:
Third level of logical database storage. A segment is a set
of extents, each of which has been allocated for a specific
data structure, and all of which are stored in the same
tablespace.
Datafile:
A physical operating system file on disk that was created
by Oracle and contains data structures such as tables and
indexes. A datafile can only belong to one database.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a database and a relational database?
What do you think about pl/sql?
What is constant in pl sql?
What are the events on which a database trigger can be based?
How does stored procedure reduce network traffic?
How do you know if a relationship is 2nf?
Does sql*plus have a pl/sql engine?
What are aggregate and scalar functions?
What are sql queries used for?
what is a constraint? : Sql dba
What is pl/sql table? Why it is used?
List different type of expressions with the example.
How do I count rows in sql?
what is a database transaction? : Sql dba
How do I create a memory optimized filegroup?
