Table Structures
This table structure imposes no order on rows.
What is a heap table?
A database performs this type of scan when a SELECT statement's hit ratio is low and an indexed column value appears in the WHERE clause.
What is an index scan?
This SQL keyword saves the completed transaction results to the database.
What is "commit"?
With this type of database, customers rely on the database provider to run and administer the database system.
What is a cloud database?
This storage media is higher capacity than RAM but lower capacity than magnetic disk.
What is flash memory or SSD?
A sorted table's sort column is usually created from this column.
What is a table's primary key?
What is a sparse index?
It's the "I" in ACID, which means that a transaction is processed without interference from other transactions.
What is "Isolated"?
This type of database offers fast query execution when compared to databases that utilize disk and flash storage media.
What is an in-memory database?
InnoDB always creates secondary indexes for this type of table column.
What is a foreign key?
This happens when a new row is inserted into a sorted table's full block.
What is "the block splits in two"?
A binary search on a sorted index with 15 blocks requires reading at most this many blocks.
What is four?
In this transaction conflict, one transaction reads data that has been updated by a second, uncommitted transaction.
What is a "dirty read"?
This type of database consists of data extracted from operational databases and restructured to support analytic queries.
What is a data warehouse?
This record type from a recovery log indicates that all data in main memory has been saved on storage media, before any transactions have completed.
What is a checkpoint record?
If a hash table's hash function is Flight Number mod 10, this bucket will contain the most rows. The Flight Numbers are 109, 202, 355, 459, 608, and 620.
What is bucket 9?
The number of index blocks read when searching for an indexed value in a dense, multi-level index with 2 levels, 5 entries per index block, and 23 total entries on the bottom level.
What is two?
This type of schedule generates the same result as the equivalent serial schedule.
What is a "serializable schedule"?
SQLite is an example of this database type.
What is an embedded database or in-process database?
This partition type uses keywords VALUES LESS THAN to assign rows to a horizontal partition.
What is a range partition?
The table cluster structure interleaves these in the same storage area.
What are rows of two or more tables?
This type of index is always secondary, with table block pointers replaced with primary key values.
What is a logical index?
In rigorous two-phase locking, a transaction holds these until the transaction commits or rolls back.
What are shared and exclusive locks?
This type of database is a collection of two or more participating databases underneath a coordinating software layer.
What is a federated database?
Assigning multiple tables to one tablespace can improve performance in this circumstance.
What are small tables that are commonly accessed in the same query?