QUIZ 7

Descrição

Quiz sobre QUIZ 7, criado por Miruna Teodora em 07-02-2017.
Miruna Teodora
Quiz por Miruna Teodora, atualizado more than 1 year ago
Miruna Teodora
Criado por Miruna Teodora quase 8 anos atrás
35
0

Resumo de Recurso

Questão 1

Questão
These are types of indexes:
Responda
  • trees
  • networks
  • spatial
  • distributed
  • hash

Questão 2

Questão
When choosing an indexing key:
Responda
  • 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

Questão 3

Questão
The partitioning methods offered by Oracle are:
Responda
  • range partitions
  • hash partitions
  • list partitions
  • composite range-hash partitions
  • composite range-list partitions

Questão 4

Questão
In Oracle subpartitions can be:
Responda
  • range
  • hash
  • list
  • index
  • cluster

Questão 5

Questão
When creating range partitions, there must be specified:
Responda
  • the partitioning method: range
  • the partitioning method: interval
  • the partition's column
  • the partition bounds
  • the partition values

Questão 6

Questão
Whatever the partition's type, the following elements must be specified:
Responda
  • the method
  • the intervals
  • the values
  • the partition columns
  • the number of partitions

Questão 7

Questão
When creating range-hash partitions, there must be specified:
Responda
  • the partitioning method: hash
  • the partition's column
  • the partition bounds
  • the subpartitioning method: hash
  • the subpartitioning method: range

Questão 8

Questão
When creating has partitions, there must be specified:
Responda
  • the partition bounds
  • the partition intervals
  • the number of partitions
  • the columns of partitions
  • the partitioning method

Semelhante

2W151 Volume 1: Safety and Security - Quiz 7
Joseph Whilden J
Tipos de bases de datos
Jeffrey Bedoya
Unidad 2. Actividad 2. Tecnologías web
Ariom Ciagra
Quiz 7 (Points 50-58)
Miranda Davis
Dutch Bros
Andres Barrios
Database design Prep
Srihari Kalwala
XML
valdearg