SNOW-CAD Creating and customizing tables and data Practice Question
Exhibit
CREATE VIEW u_my_view AS SELECT sys_id, number, short_description FROM incident UNION SELECT sys_id, number, short_description FROM problem
Refer to the exhibit. After creating this database view, the view contains fewer records than the sum of records in incident and problem tables. What is the most likely cause?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
UNION should be UNION ALL to retain duplicate rows
The UNION operator by default removes duplicate rows. If there are overlapping records between the incident and problem tables (e.g., same sys_id, number, or short_description), UNION eliminates them, resulting in fewer records than the sum of the two tables. Using UNION ALL would retain all rows, including duplicates. Option A is incorrect because the 'active' field is not required for the view to include all records. Option C is false because database views can combine records from multiple tables. Option D is incorrect because DISTINCT is already implied by UNION and would further reduce rows, not increase them.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The view must include the 'active' field from both tables
Why it's wrong here
No requirement to include any specific field.
- ✓
UNION should be UNION ALL to retain duplicate rows
Why this is correct
UNION deduplicates rows, reducing the count if overlaps exist.
- ✗
A database view cannot combine records from incident and problem tables
Why it's wrong here
Views can combine any tables.
- ✗
The SELECT statement should include DISTINCT
Why it's wrong here
UNION already implies DISTINCT.
Go deeper
Related to this question
About these practice questions
This SNOW-CAD question is part of Courseiva's 481-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This SNOW-CAD practice question is part of Courseiva's free ServiceNow 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 SNOW-CAD exam.