Explain what are the components of Logical database structure of ORACLE database?
Submitted by: AdministratorThere 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Concepts and Architecture Job Interview Questions And Answers
Top Concepts and Architecture Questions
☺ | What is a Segment in Oracle? |
☺ | Explain can a Tablespace hold objects from different Schemes? |
☺ | Explain what is the function of Redo Log? |
☺ | What is Oracle Identity Analytics? |
☺ | Explain what is Public Database Link? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |