Database Fundamentals — Question 85

You have a table named Product. You create a view that includes all the products from the Product table that are in the Furniture category.
You execute a statement on the Product table that deletes all the products in the Furniture category.
After you execute the statement, the result set of the view is:

Answer options

• A. Empty
• B. Deleted
• C. Unchanged
• D. Archived

Correct answer: A

Explanation

The correct answer is A because when all products in the Furniture category are deleted from the Product table, the view will reflect that change and display no records. Options B, C, and D are incorrect because they suggest that the view would still show deleted items, remain the same, or show archived items, which is not the case after the deletion.