1. Which of the following are the disadvantages of declaring secondary indexes?

Updates may run slower because of the need to update the indexes

Selects will be forced to use full table scans

Selects with WHERE clauses will run faster

None of the other answers are correct

2. Which of the following index types is commonly used on low-cardinality fields/columns?

Hash

Geometric

Bitmap

B-Tree

4. A primary goal of partitioning is to bunch the processing as much as possible to a single partition so that most partitions are idle most of the time.

True

False

5. Program logic can never be stored in the database.

True

False

6. If you have a specific action that you want performed every time a given table is updated, you can create a trigger for that table.

True

False

7. Which of the following data models will typically include indexes and partitioning?

Conceptual

None of the other answers are correct

Logical

Physical