7573371
Beschreibung
Quiz von Miruna Teodora, aktualisiert more than 1 year ago
|
Erstellt von Miruna Teodora
vor fast 8 Jahre
|
|
Frage 1
Frage
These are types of indexes:
Antworten
-
trees
-
networks
-
spatial
-
distributed
-
hash
Frage 2
Frage
When choosing an indexing key:
Antworten
-
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
Frage 3
Frage
The partitioning methods offered by Oracle are:
Antworten
-
range partitions
-
hash partitions
-
list partitions
-
composite range-hash partitions
-
composite range-list partitions
Frage 4
Frage
In Oracle subpartitions can be:
Antworten
-
range
-
hash
-
list
-
index
-
cluster
Frage 5
Frage
When creating range partitions, there must be specified:
Antworten
-
the partitioning method: range
-
the partitioning method: interval
-
the partition's column
-
the partition bounds
-
the partition values
Frage 6
Frage
Whatever the partition's type, the following elements must be specified:
Antworten
-
the method
-
the intervals
-
the values
-
the partition columns
-
the number of partitions
Frage 7
Frage
When creating range-hash partitions, there must be specified:
Antworten
-
the partitioning method: hash
-
the partition's column
-
the partition bounds
-
the subpartitioning method: hash
-
the subpartitioning method: range
Frage 8
Frage
When creating has partitions, there must be specified:
Antworten
-
the partition bounds
-
the partition intervals
-
the number of partitions
-
the columns of partitions
-
the partitioning method
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.