Font size
WorksheetsMDF301 Final Revision
Total questions: 30
Worksheet time: 22mins
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.
(a)
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?
(a)
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.
(a)
Python module used to work with sqlite databases.
database
sqlite3
plist
datetime
Python module used to convert date/time stamps to human readable values.
(a)
When a database adds records to a page, records are generally added from______.
The top down
The bottom up
The middle up
The middle down
Which of the following is NOT a SQLite type?
Null
BLOB
Integer
String
The SQLite database type that deals with decimal values.
Real
BLOB
Integer
Decimal
When working with databases in Python, the most common type of loop used to iterate through records in a table is:
While
for
Do While
Recursive
When a record is deleted in a database, this is modified so that the database does not "see" the record as being live.
address
target
pointer
header
This mode refers to the state when a phone is first powered on but the password has not yet been entered.
AFU
BDU
BFU
AFA
A tool used to convert timestamps to human readable dates/times.
(a)
Which of the following tools would be used to view a database in its raw state for manually analysis and data carving?
SQLite Expert Personal
DB Browser
Plist Editor Pro
HxD
Which of the following tools would be used to view an XML file for the configuration settings for an Android app?
Tempus
Notepad++
Plist Editor Pro
SQLite Expert Personal
What month does this timestamp convert to: 1734331574
(a)
What is the name of the table containing messages?
(a)
How many records are there in the chat table?
(a)
What data type is stored in the Profile field?
(a)
The marker bit in a variable length integer signals whether to continue reading bytes as part of the varint or to stop. The marker bit is located at:
The least significant bit
The most significant byte
The lowest bit
The most significant bit
Text messages are generally stored in this data type in SQLite databases.
(a)
Pi, 3.14, would be stored in this data type in a SQLite database.
(a)
The absence of data or an empty field is called what?
Empty Space
Vacant
Null
Zero
A programming language used to automate the parsing of app data during analysis.
Java
C#
Python
C++
What tool would you use to decode the string found under the Profile key?
(a)
What is the username associated with this app?
(a)
