Quick Answer
The answer is the `message` table. This is correct because the `message` table in iOS’s SMS.db database stores the actual text content of each SMS and iMessage in its `text` column, with one row per message and critical fields like `is_from_me`, `date`, and `text` that allow an investigator to distinguish sent from received messages and retrieve the full body. On the Computer Hacking Forensic Investigator CHFI exam, this question tests your knowledge of iOS forensic artifacts and database schema analysis—a common trap is confusing the `message` table with the `chat` or `handle` tables, which store conversation metadata and contact identifiers rather than the message content itself. To remember this, think of the `message` table as the “body” of the evidence: just as a letter’s content is the message, the `text` column holds the actual words. A quick memory tip: “Message holds the message—chat and handle are just the envelope.”
This CHFI practice question tests your understanding of mobile and malware forensics. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
An investigator extracts the SMS.db file from an iOS backup. Which table within this database would contain the actual message content for sent and received messages?
message
The message table stores the actual text and associated metadata.
attachment
Why wrong: The attachment table stores information about file attachments.
handle
Why wrong: The handle table stores contact identifiers.
chat
Why wrong: The chat table contains conversation metadata, not message content.
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
message
The `message` table in iOS's SMS.db database stores the actual text content of each SMS and iMessage in its `text` column. This is the primary table queried to retrieve the body of sent and received messages, as it contains one row per message with fields like `is_from_me`, `date`, and `text`.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
message
Why this is correct
The message table stores the actual text and associated metadata.
Related concept
Read the scenario before looking for a memorised answer.
attachment
Why it's wrong here
The attachment table stores information about file attachments.
handle
Why it's wrong here
The handle table stores contact identifiers.
chat
Why it's wrong here
The chat table contains conversation metadata, not message content.
Common exam traps
EC-Council often tests the distinction between where message content is stored versus where metadata (like attachment info or participant handles) resides, leading candidates to confuse the `chat` or `handle` tables as containing the message body.
Detailed technical explanation
The `message` table uses a `ROWID` primary key and includes critical fields such as `cache_roomnames` for group chats and `account_guid` for iMessage vs. SMS routing. In real-world investigations, analysts often join `message` with `handle` and `chat` to reconstruct full conversations, but the message body is always extracted from the `text` column of the `message` table. Note that deleted messages may remain in the table until the database is vacuumed, making this table a key source for recovery.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
A practitioner preparing for the CHFI exam encounters this exact type of scenario on the job. The correct answer here is not the most general option — it is the best answer for the specific constraint described. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Real exam questions reward reading the full scenario before eliminating options, because the constraint defines which answer fits.
What to study next
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Mobile and Malware Forensics — study guide chapter
Learn the concepts, then practise the questions
Mobile and Malware Forensics practice questions
Targeted practice on this topic area only
All CHFI questions
1,000 questions across all exam domains
Computer Hacking Forensic Investigator CHFI study guide
Full concept coverage aligned to exam objectives
CHFI practice test guide
How to use practice tests most effectively before exam day
Related practice questions
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Practise CHFI questions linked to Computer Forensics Investigation Process.
Practise CHFI questions linked to Computer Forensics Fundamentals and Process.
Practise CHFI questions linked to Storage Forensics and File System Analysis.
Practise CHFI questions linked to Incident Response and First Responder Skills.
Practise CHFI questions linked to Computer Forensics Lab.
Practise CHFI questions linked to Evidence Acquisition and Duplication.
Practise CHFI questions linked to OS and Network Forensics.
Practise CHFI questions linked to OS and File System Forensics.
Practise CHFI questions linked to Application, Email and Cloud Forensics.
Practise CHFI questions linked to Mobile and Malware Forensics.
Practise CHFI questions linked to Network and Cloud Forensics.
Practise CHFI questions linked to Database and Application Forensics.
Practice this exam
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Mobile and Malware Forensics — This question tests Mobile and Malware Forensics — Read the scenario before looking for a memorised answer..
The correct answer is: message — The `message` table in iOS's SMS.db database stores the actual text content of each SMS and iMessage in its `text` column. This is the primary table queried to retrieve the body of sent and received messages, as it contains one row per message with fields like `is_from_me`, `date`, and `text`.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jun 30, 2026
This CHFI practice question is part of Courseiva's free EC-Council certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the CHFI exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.