QUIZ 7

Beschreibung

Quiz am QUIZ 7, erstellt von Miruna Teodora am 07/02/2017.
Miruna Teodora
Quiz von Miruna Teodora, aktualisiert more than 1 year ago
Miruna Teodora
Erstellt von Miruna Teodora vor mehr als 7 Jahre
31
0

Zusammenfassung der Ressource

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
Zusammenfassung anzeigen Zusammenfassung ausblenden

ähnlicher Inhalt

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
Database design Prep
Srihari Kalwala
XML
valdearg
Quiz 7 (Points 50-58)
Miranda Davis