QUIZ 7

Description

Quiz on QUIZ 7, created by Miruna Teodora on 07/02/2017.
Miruna Teodora
Quiz by Miruna Teodora, updated more than 1 year ago
Miruna Teodora
Created by Miruna Teodora about 7 years ago
31
0

Resource summary

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
Show full summary Hide full summary

Similar

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