RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Tuning Basics
External Environment
Performance Tuning
«Prev
Next»
Performance Tuning
Optimizer and Query
Create Stat Table
DBMS_STATS Package
Materialized Views
Index Materialized View
Oracle Handling Invalidation
Index Enhancements
Index Types Review
Create Descending index
Oracle Descending Index
Oracle bitmapped Index
Create Reverse Index
Reverse Index Creation
Creating Statistics
Compute Statistics
Understanding Domain Indexing
Rebuilding Defragmenting indexes
Function Based indexing
Creating Function-based-index
Index Category Conclusion
Index Organized Tables
Bridge PrimaryKeys
index Organized Table
Advanced Queuing
What is Advanced Queuing
Advanced Queuing Diagram
Data Dictionary Views
Advanced Queuing Data
PL/SQL Applications for Queuing
Developing Advanced Queuing Apps
Developing PL/SQL Apps for Enqueuing
Developing Appslications-dequeuing
PL/SQL Propagation Functionality
Run Queuing Apps
Steps to Run Queuing Apps
Advanced Queuing Conclusion
Managing LOB
Converting long to LOB
Index-organized Tables - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Which of the following types of applications are typically appropriate for index-organized tables?
Please select all the correct answers.
A.
OLTP applications
B.
E-commerce applications
C.
Information retrieval applications
D.
OLAP applications
2.
Which of the following keywords are associated with an index-organized table?
Please select all the correct answers.
A.
ORGANIZATION
B.
ORGANIZATION INDEX
C.
MOVE
D.
CREATE INDEX_ORGANIZED TABLE
3.
Which of the following features are allowed in standard tables but not in index-organized tables?
Please select all the correct answers.
A.
Partitioning
B.
Storage in clusters
C.
Secondary indexes
D.
Bitmapped indexes