7573371
Descripción
Test por Miruna Teodora, actualizado hace más de 1 año
|
Creado por Miruna Teodora
hace más de 7 años
|
|
Pregunta 1
Pregunta
These are types of indexes:
Respuesta
-
trees
-
networks
-
spatial
-
distributed
-
hash
Pregunta 2
Pregunta
When choosing an indexing key:
Respuesta
-
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
Pregunta 3
Pregunta
The partitioning methods offered by Oracle are:
Respuesta
-
range partitions
-
hash partitions
-
list partitions
-
composite range-hash partitions
-
composite range-list partitions
Pregunta 4
Pregunta
In Oracle subpartitions can be:
Respuesta
-
range
-
hash
-
list
-
index
-
cluster
Pregunta 5
Pregunta
When creating range partitions, there must be specified:
Respuesta
-
the partitioning method: range
-
the partitioning method: interval
-
the partition's column
-
the partition bounds
-
the partition values
Pregunta 6
Pregunta
Whatever the partition's type, the following elements must be specified:
Respuesta
-
the method
-
the intervals
-
the values
-
the partition columns
-
the number of partitions
Pregunta 7
Pregunta
When creating range-hash partitions, there must be specified:
Respuesta
-
the partitioning method: hash
-
the partition's column
-
the partition bounds
-
the subpartitioning method: hash
-
the subpartitioning method: range
Pregunta 8
Pregunta
When creating has partitions, there must be specified:
Respuesta
-
the partition bounds
-
the partition intervals
-
the number of partitions
-
the columns of partitions
-
the partitioning method
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.