MDF301 Final Revision

A block of free space on a database page that consists of one or more deleted records is known as?

• Freelist Page

• Free area

• Freeblock

• Free space

When several records in a database are deleted at once they often create this type of page in a database.

• Available Page

• Open Page

• Freeblock Page

• Freelist Page

Type of file that contains configuration and settings information for iPhone apps.

The file that keeps track of frames in the WAL and acts as the WAL's index is known as the what?

• DB File

• Write Ahead Log

• SHM File

• XML File

The EPOCH timestamp typically found on Android phones is this one.

• MAC

• GPS

• Unix

• Windows

What is the timestamp EPOCH found exclusively on iDevices?

Smartphone apps make use of this encoding scheme when storing binary data within databases and configuration files.

• GSM 7-bit

• Reverse Nibble

• Reverse GSM 7-bit

• Base64

The number of entries in the WAL that trigger a commit.

Python module used to work with sqlite databases.

• database

• sqlite3

• plist

• datetime

Python module used to convert date/time stamps to human readable values.