A data analyst needs to retrieve all columns from the 'employees' table for employees in the 'Sales' department. Which DML command should be used?

SHOW * FROM employees WHERE department = 'Sales';

FETCH * FROM employees WHERE department = 'Sales';

READ * FROM employees WHERE department = 'Sales';

SELECT * FROM employees WHERE department = 'Sales';

A data analyst needs to remove a deprecated `old_sales` table from the database. The table is no longer referenced by any views or stored procedures. Which DDL command should be used to permanently remove the table and its data?

ALTER TABLE old_sales DROP COLUMN *;

CompTIADataSys+

Domain 1Objective 2

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

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 16–20

16foundation · easy
A database administrator needs to execute a stored procedure named 'UpdateInventory' that updates product stock levels. Which SQL statement should be used?
Select an answer first
17foundation · easy
A developer needs to create a reusable SQL routine that calculates the total sales for a given product and returns the result. Which database object should be created?
Select an answer first
18foundation · easy
A data analyst needs to retrieve all columns from the 'employees' table for employees in the 'Sales' department. Which DML command should be used?
Select an answer first
19foundation · easy
After successfully completing a series of DML statements that update customer orders, a database administrator wants to make the changes permanent and visible to other users. Which TCL command should be executed?
Select an answer first
20application · easy
A data analyst needs to remove a deprecated `old_sales` table from the database. The table is no longer referenced by any views or stored procedures. Which DDL command should be used to permanently remove the table and its data?
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.

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

Questions 16–20

A database administrator needs to execute a stored procedure named 'UpdateInventory' that updates product stock levels. Which SQL statement should be used?

A developer needs to create a reusable SQL routine that calculates the total sales for a given product and returns the result. Which database object should be created?

A data analyst needs to retrieve all columns from the 'employees' table for employees in the 'Sales' department. Which DML command should be used?

After successfully completing a series of DML statements that update customer orders, a database administrator wants to make the changes permanent and visible to other users. Which TCL command should be executed?

A data analyst needs to remove a deprecated `old_sales` table from the database. The table is no longer referenced by any views or stored procedures. Which DDL command should be used to permanently remove the table and its data?

Keep studying — Database fundamentals