Question

inside a trigger which of the following DML statement will have both inserted and deleted tables populated
a) delete
b) insert
c)update
d)none of the above

Answer 1

The correct answer is option [d].

Answer 2

Answer:

inside a trigger none of the above DML statement will have both inserted and deleted tables populated

Explanation:

• DML stands for Data Manipulation Language, and it is used to manipulate data. It includes the most common SQL statements, such as SELECT, INSERT, UPDATE, and DELETE. The following are the major functions of this:
• The select command is used to get data from a table.
• Insert is a command that is used to add data to a table.
• Updates are used to make changes to existing data in a table.
• The delete function is used to remove records from a table.
• Each has its own set of features, and there isn't a single DML command that can execute both insert and delete operations.