Question 1
The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
- View
- Function
- Index
- Stored procedure
- Trigger
Question 2
One reason to add an index is to:
- Decrease storage space.
- Increase database security.
- Improve performance of select statements.
- Improve performance of insert statements.
Question 3
You have a table that contains the following data. You break the table into the following two tables. This process is referred to as:
- defragmentation
- normalization
- fragmentation
- denormalization
Question 4
You have a table that contains the following data. Which database term is used to describe the relationship between ProductID and ProductCategory?
- Cohort
- Relationally dependent
- Deterministic
- Functionally dependent
- Compositional
Question 5
Which key uniquely identifies a row in a table?
- foreiqn
- primary
- local
- superkey