RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Tuning Basics
External Environment
Large Objects
«Prev
Next»
Performance Tuning
Optimizer and Query
Oracle Optimizer Functions
Optimizer Characteristics
Using Stored Outlines
DBMS_STATS Package
Statistics Package
Monitoring DB Operations
Examine Stats
Materialized Views
What are materialized Views
Materialized View Syntax
Summary Data Joins
Index Materialized View
Oracle Handling Invalidation
Query Rewriting Conditions
Explain Plan Command
Managing MV
MV Conclusion
Index Enhancements
Index Types Review
Create Descending index
Oracle bitmapped Index
Create Reverse Index
Creating Statistics
Understanding Domain Indexing
Rebuilding Defragmenting indexes
Function Based indexing
Creating Function-based-index
Index Category Conclusion
Index Organized Tables
index Organized Table
Create IOT Ttable
Bridge Primary Keys
Rebuild Index
Create Secondary Indexes
IOT vs. Regular Tables
IOT Table Conclusion
Advanced Queuing
What is Advanced Queuing
Data Dictionary Views
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
Advanced Queuing Conclusion
Managing LOB
Converting long to LOB
LOB Storage - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
You want to give your Oracle database users access to a set of bitmapped image files that are already used in some word processing documents through your Oracle database. Which kind of data type would require the least administrative work on your part to get started?
Please select the best answer.
A.
BLOB
B.
CLOB
C.
NCLOB
D.
BFILE
2.
You want to store the Japanese translations of text used in online help files in a LOB data type. The online help is divided into smallish portionsno more than 2,000 Japanese characters each. Which data type should you choose?
Please select the best answer.
A.
BLOB in-line
B.
CLOB in-line
C.
CLOB out of line
D.
NCLOB in-line
3.
You want to store the chapters of a book you are writing in English in an Oracle database. Which data type should you choose?
Please select the best answer.
A.
CLOB in-line
B.
CLOB out of line
C.
NCLOB in-line
D.
NCLOB out of line
Correct answers:
Your Score: 0
Submit
Quiz Explanation