RelationalDBDesign
SiteMap
Database Analysis
Database Design
Extended DB Features
Oracle SQL Extensions
Clustering Tables
«Prev
Next»
Extended Features
Partitioned Tables
Oracle Partitioning Explained
Partitioning Advantages
Table Range Partitioning
Index Partitioned Table
Local Index Partition
Global Index Partition
Modifying Partition Features
Dropping Oracle Partitions
Splitting Merging Partitions
Clustering Tables
Clustered Tables Advantages
Creating Oracle Cluster
Size Cluster Properly
Creating Cluster Key
Oracle Hash Cluster
Creating Hash Cluster
Deleting Hash Cluster
Clustering Conclusion
Index Organized
Index Organized Tables
Advantages Disadvantages IOT
Creating Table Index
Allocate Overflow Space
Deleting Altering IOT
Reorganize IOT
IOT Conclusion
Auditing Features
Auditing Oracle Entities
Enable Audit Feature
Audit SQL Statement
Access Audit Trail
Oracle System Privileges
Auditing Database Objects
Purge Audit Trail
Language Support
National Character Set
Using Profiles
Product Profile
Profile Table
Limit Command Access
Security Scheme
SQL WildCards
SQL Wildcard Characters
Removing Restriction
Target Profile
SqlPlus Utility
Creating Cluster Key - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Which of the following steps is not necessary to create a working cluster?
Please select the best answer.
A.
Create the cluster
B.
Create the tables that will be in the cluster
C.
Create the cluster index
D.
Create a foreign key constraint between the tables in the cluster
2.
If you drop a cluster index, what is the effect on accessing the data in the cluster?
Please select the best answer.
A.
Data access for the cluster will be slower
B.
Data access for the cluster will be faster
C.
Data access for the cluster will not be possible
D.
Data access for the cluster will not be affected
3.
Which types of data might be appropriate for use in a cluster?
Please select all the correct answers.
A.
All data is appropriate for a cluster
B.
Tables with a master-detail relationship
C.
Tables where the cluster key is frequently updated
D.
Data usually retrieved by selecting a value from a cluster key