Page: 1
/ 47
Total 235 questions
The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
- A. View
- B. Function
- C. Index
- D. Stored procedure
- E. Trigger
Answer : C
One reason to add an index is to:
- A. Decrease storage space.
- B. Increase database security.
- C. Improve performance of select statements.
- D. Improve performance of insert statements.
Answer : C
You have a table that contains the following data.
You break the table into the following two tables.
This process is referred to as:
- A. defragmentation
- B. normalization
- C. fragmentation
- D. denormalization
Answer : B
You have a table that contains the following data.
Which database term is used to describe the relationship between ProductID and ProductCategory?
- A. Cohort
- B. Relationally dependent
- C. Deterministic
- D. Functionally dependent
- E. Compositional
Answer : D
31 days access 