Question

To perform a change to a table using the Command object named Cmd, what statement of the following correct?

[A] Cmd.ExecuteReader()
[B] Cmd.ExecuteScalar()
[C] Cmd.ExecuteQuery()
[D] Cmd.ExecuteNonQuery()
[E] Cmd.ExecuteUpdate()

Answer 1

To perform a change to a table using the Command object named Cmd, the correct statement is [D] Cmd. ExecuteNonQuery().

Step-by-step explanation:

The ExecuteNonQuery() method is used when executing SQL commands that don't return any data, such as INSERT, UPDATE, or DELETE statements. These commands modify the data in the database but do not retrieve any results. In the context of changing a table, like adding, updating, or deleting records, ExecuteNonQuery() is the appropriate method to use.

On the other hand, ExecuteReader() is used for executing queries that return a result set, ExecuteScalar() is used for retrieving a single value, and ExecuteQuery() and ExecuteUpdate() are not standard methods in ADO. NET.

Option D is the answer.