Lesson 5

Question 1

table structure

Answer 1

scheme for organizing rows in blocks on storage media

Question 2

heap table

Answer 2

no order is imposed on rows

optimize inset operations

Question 3

table scan

Answer 3

reads table blocks directly, without accessing an index

Question 4

index scan

Answer 4

reads index blocks sequentially

Question 5

multi-level index

Answer 5

stores column values and row pointers in a hierarchy

Question 6

tablespace

Answer 6

database object that maps one or more tables to a single file

Question 7

Physical design

Answer 7

Specifies indexes, table structures, and partitions

Affects query performance but never affects query results

Question 8

Hash index

Answer 8

index entries assigned to buckets

Question 9

Bitmap index

Answer 9

Grid of bits

Contains ones and zeros