Database Concepts Quiz

What is the main purpose of a data model?

• To program data

• To organize and structure data

• To create hardware

• To analyze data

Which is not a type of data model?

• Flat

• Hierarchical

• Neural

• Star Schema

Normalization reduces:

• Data redundancy

• System speed

• Storage space

• Data hierarchy

An index is a:

• Copy of a database table in sorted form

• Table of contents

• Program file

• Backup file

A clustered index organizes data by:

• Random order

• Search key field

• Alphabetical order

• Last modified date

Sparse indexes:

• Contain entries for every search key

• Use pointers for groups of records

• Duplicate records

• Sort data by multiple fields

The goal of data security is to ensure:

• Faster systems

• Privacy and protection

• Network stability

• Cost reduction

Encryption scrambles data using:

• Algorithms

• Hardware locks

• Manual coding

• Default passwords

Which is not a type of security control?

• Auditing

• Authentication

• Data redundancy

• Access control

ARIES recovery works in how many phases?

• 2

• 3

• 4

• 1