Which of the following are DML commands? Each correct answer represents a complete solution. (Choose all that apply.)
Which of the following are DML commands? Each correct answer represents a complete solution. (Choose all that apply.)
Data Manipulation Language (DML) commands are used to manipulate data within the database. The DELETE command is used to remove existing records, the UPDATE command is used to modify existing records, and the INSERT command is used to add new records to the database. SELECT INTO is actually a part of Data Definition Language (DDL) because it creates a new table based on the result set of a SELECT query. ALTER is also a DDL command, used to modify the structure of the database schema. SELECT is a query statement that is read-only and categorized under SQL-data statements, rather than DML.
la respuesta correcta es BCEF
In SQL, the following statements are used for database manipulation: SELECT … INTO INSERT UPDATE DELETE Each SQL DML statement is a declarative command. Answer E is incorrect. The purely read-only SELECT query statement is classed with the ‘SQL-data’ statements and hence it is considered to be outside of DML.
why not e?