RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Tuning Basics
External Environment
Data Structures
«Prev
Next»
Performance Tuning
Data Blocks
Database Block Size
Optimizing Space Usage
Segment Header Internals
PCtfree Optimal Performance
PCtused Optimal Performance
Monitoring Tuning Indexes
Table High Water Marks
High Water Mark
Water Mark Active
DB Engine Conclusion
Data Structures
Object Oriented Database
Abstract Data Types
Data Dictionary
Oracle Data Dictionary
Sending DBA Alert Output
Partitioned Tuning
DBA Tab Partitions View
Partitioned Index Maintenance
Data Base Objects
DBA Partition Views
Index Techniques
Bitmap Indexes
Speeding Queries
DW Star Schema
Star Query Process
Star Transformation Queries
Requirements for Star Trans
Star Transformation Process
Using Concatenated Indexes
Function Based Indexes
Bitmapped Indexes
Oracle Database Tuning
Oracle Web Applications
Web Request Broker
Oracle Tuning - Glossary
Object Data Constructs - Quiz
Select the best answer or answers for each question.
1.
What Oracle data construct allows related data items to be grouped together?
Please select all the correct answers.
A.
OIDs
B.
ADTs
C.
Nested tables
D.
VARRAYs in tables
2.
Which were listed as Oracle constructs that would help Oracle performance? (Choose all that apply)
Please select all the correct answers.
A.
Data columns of the data type OID
B.
Nested tables
C.
Tables with VARRAY data types
D.
Tables with MAXEXTENTS UNLIMITED
3.
What time consuming operation do the Oracle object constructs help to avoid?
Please select the best answer.
A.
Expensive index range scans
B.
Expensive fetches by ROWIDs
C.
Expensive SQL table JOINs
D.
Expensive full-table scans