Concepts and Architecture Question:
Download Job Interview Questions and Answers PDF
Explain what are the components of Logical database structure of ORACLE database?
Answer:
There are two types of database
1) logical database
2) physical database
logical database consist of tablespaces....and a tablespace consist of one or more segments....a segment consist of one or more extents.....an extent consist of contigious oracle data blocks.
logical database contain objects of users such as tables,indexes etc.
1) logical database
2) physical database
logical database consist of tablespaces....and a tablespace consist of one or more segments....a segment consist of one or more extents.....an extent consist of contigious oracle data blocks.
logical database contain objects of users such as tables,indexes etc.
Download Oracle Architecture and Concepts Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Tell me how to encrypt and decrypt oracle procedure? | How to identify database size when you create a database first time? |