Quiz
Chapter 7
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (8)
1These are types of indexes:
- Atrees
- Bnetworks
- Cspatial
- Ddistributed
- Ehash
2When choosing an indexing key:
- Athe attributes in ORDER BY clause are candidates for the key
- Bthe attributes in FROM clause are candidates for the key
- Cthe attributes in HAVING clause are candidates for the key
- Dthe attributes in GROUP BY clause are candidates for the key
- Ethe attributes in WHERE clause are candidates for the key
3The partitioning methods offered by Oracle are:
- Arange partitions
- Bhash partitions
- Clist partitions
- Dcomposite range-hash partitions
- Ecomposite range-list partitions
4In Oracle subpartitions can be:
- Arange
- Bhash
- Clist
- Dindex
- Ecluster
5When creating range partitions, there must be specified:
- Athe partitioning method: range
- Bthe partitioning method: interval
- Cthe partition's column
- Dthe partition bounds
- Ethe partition values
6Whatever the partition's type, the following elements must be specified:
- Athe method
- Bthe intervals
- Cthe values
- Dthe partition columns
- Ethe number of partitions
7When creating range-hash partitions, there must be specified:
- Athe partitioning method: hash
- Bthe partition's column
- Cthe partition bounds
- Dthe subpartitioning method: hash
- Ethe subpartitioning method: range
8When creating has partitions, there must be specified:
- Athe partition bounds
- Bthe partition intervals
- Cthe number of partitions
- Dthe columns of partitions
- Ethe partitioning method
Information
- Description
- Database Quiz on Chapter 7, created by Claudia Piscociu on 07/02/2017.
- Author
- Claudia Piscociu
- Language
- English
- Views
- 17
- Tags
- Rating
- No ratings yet Rate this quiz