List the Optional Flexible Architecture (OFA) of

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

423. List the Optional Flexible Architecture (OFA) of Oracle database? How can we organize the tablespaces in Oracle database to have maximum performance?

1. SYSTEM - Data dictionary tables.
2. DATA - Standard operational tables.
3. DATA2- Static tables used for standard operations
4. INDEXES - Indexes for Standard operational tables.
5. INDEXES1 - Indexes of static tables used for standard operations.
6. TOOLS - Tools table.
7. TOOLS1 - Indexes for tools table.
8. RBS - Standard Operations Rollback Segments,
9. RBS1,RBS2 - Additional/Special Rollback segments.
10. TEMP - Temporary purpose tablespace
11. TEMP_USER - Temporary tablespace for users.
12. USERS - User tablespace.

(Continued on next question...)

Other Job Interview Questions

• You have a rollback segment in a version 7.2 database that has expanded beyond optimal, how can it be restored to optimal?
• What is snapshot log?
• What is trigger associated with the timer?
• What are Most Common types of Complex master-detail relationships?
• What are the built-ins used for processing rows?
• What is an Extent?
• Compare and contrast TRUNCATE and DELETE for a table.
• Online & Offline TS
• What are the basic element of Base configuration of an oracle Database?
• What is a cluster Key?
• More...