A sales team needs to see a list of customers who have placed orders in the last 30 days, along with their total order amounts. They want to run this query frequently without writing the complex join and date filter each time. What should you create to meet this need?

A new table `recent_customers` that is populated by a daily job.

A stored procedure named `recent_customers` that returns the result set.

A view named `recent_customers` that selects customer names and total order amounts from the joined `customers` and `orders` tables, filtered to the last 30 days.

An index on the `orders` table's `order_date` column.

An online ticket booking system allows users to reserve seats. The system must ensure that when a user books a seat, the seat is marked as reserved and the user's account is charged. If either operation fails, neither should take effect. Which approach best guarantees this behavior?

Execute both operations within a single transaction and COMMIT only if both succeed.

Execute the seat reservation first, then the charge, and COMMIT after each.

Execute the charge first, then the seat reservation, and ROLLBACK if the reservation fails.

Use a trigger on the seat table to perform the charge automatically.

A database has a `departments` table with columns `dept_id` and `dept_name`. The HR department wants to rename the `dept_name` column to `department_name` to be more descriptive. Which DDL command should be used?

ALTER TABLE departments RENAME COLUMN dept_name TO department_name;

DROP COLUMN dept_name FROM departments;

UPDATE departments SET dept_name = department_name;

CREATE TABLE departments (dept_id INT, department_name VARCHAR(50));

A database administrator needs to add a new row to the 'products' table with values for the 'product_id', 'name', and 'price' columns. Which DML command should be used?

UPDATE products SET name = 'Widget' WHERE product_id = 101;

ALTER TABLE products ADD ROW (101, 'Widget', 9.99);

CREATE ROW IN products (product_id, name, price) VALUES (101, 'Widget', 9.99);

INSERT INTO products (product_id, name, price) VALUES (101, 'Widget', 9.99);

CompTIADataSys+

Domain 1Objective 2

SQL Code Development DS0-001 Practice Questions (Page 3)

Part of the Database fundamentals domain, which accounts for 24% of the DS0-001 exam. CompTIA does not publish an official question count, but from its 90-minute exam (~35–60 total, ~8–14 in this domain), expect 2–4 from this objective — we provide 22 practice questions to prepare you well beyond it. (estimate)

22questions here

5free pages

6concepts

24%of the exam

Questions 11–15

11application · medium
A sales team needs to see a list of customers who have placed orders in the last 30 days, along with their total order amounts. They want to run this query frequently without writing the complex join and date filter each time. What should you create to meet this need?
Select an answer first
12application · medium
An online ticket booking system allows users to reserve seats. The system must ensure that when a user books a seat, the seat is marked as reserved and the user's account is charged. If either operation fails, neither should take effect. Which approach best guarantees this behavior?
Select an answer first
13foundation · easy
A database administrator wants to create a virtual table that shows only the 'customer_name' and 'order_total' columns from a complex join of the 'customers' and 'orders' tables. Which database object should be created?
Select an answer first
14application · easy
A database has a `departments` table with columns `dept_id` and `dept_name`. The HR department wants to rename the `dept_name` column to `department_name` to be more descriptive. Which DDL command should be used?
Select an answer first
15foundation · easy
A database administrator needs to add a new row to the 'products' table with values for the 'product_id', 'name', and 'price' columns. Which DML command should be used?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DS0-001

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by CompTIA. “DS0-001” is a trademark of its owner, used for identification only.