Multiple choice technology testing

Database unit tests can be created for

  1. All DDL statements

  2. All DML statements

  3. SPs, functions and triggers

  4. DDL & DML
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Database unit tests in VSTT are designed to test programmable database objects like Stored Procedures (SPs), functions, and triggers because these contain business logic that can be validated through testing. DDL statements (CREATE, ALTER, DROP) define database structure and are typically tested through integration or schema tests, while DML statements (INSERT, UPDATE, DELETE) are data operations that are better tested at a higher level.

Keep practicing — related questions