7574310
Description
Quiz by Claudia Piscociu, updated more than 1 year ago
More
Question 1
Question
These are types of indexes:
Answer
-
trees
-
networks
-
spatial
-
distributed
-
hash
Question 2
Question
When choosing an indexing key:
Answer
-
the attributes in ORDER BY clause are candidates for the key
-
the attributes in FROM clause are candidates for the key
-
the attributes in HAVING clause are candidates for the key
-
the attributes in GROUP BY clause are candidates for the key
-
the attributes in WHERE clause are candidates for the key
Question 3
Question
The partitioning methods offered by Oracle are:
Answer
-
range partitions
-
hash partitions
-
list partitions
-
composite range-hash partitions
-
composite range-list partitions
Question 4
Question
In Oracle subpartitions can be:
Answer
-
range
-
hash
-
list
-
index
-
cluster
Question 5
Question
When creating range partitions, there must be specified:
Answer
-
the partitioning method: range
-
the partitioning method: interval
-
the partition's column
-
the partition bounds
-
the partition values
Question 6
Question
Whatever the partition's type, the following elements must be specified:
Answer
-
the method
-
the intervals
-
the values
-
the partition columns
-
the number of partitions
Question 7
Question
When creating range-hash partitions, there must be specified:
Answer
-
the partitioning method: hash
-
the partition's column
-
the partition bounds
-
the subpartitioning method: hash
-
the subpartitioning method: range
Question 8
Question
When creating has partitions, there must be specified:
Answer
-
the partition bounds
-
the partition intervals
-
the number of partitions
-
the columns of partitions
-
the partitioning method
Want to create your own Quizzes for free with GoConqr? Learn more.