Database Fundamentals — Question 80

You are developing a SQL query.
Which two SQL constructs represent data manipulation language (DML) statements? Choose two.

Answer options

• A. SELECT EmployeeName FROM Employee WHERE EmployeeName = 'Jack Smith';
• B. INSERT INTO Employee VALUES ('Jack Smith')
• C. ALTER TABLE Employee ADD EmployeeName Varchar;
• D. CREATE ROW IN Employee WHERE EmployeeName = 'Jack Smith';

Correct answer: A, B

Explanation

The correct answers, A and B, are DML statements as they are used to query and manipulate data. Option C is a data definition language (DDL) statement that modifies the database schema, and option D is not a valid SQL statement in standard SQL syntax.