How can you execute DML statements (i.e. insert, delete, update) in the database?
-
O (a) By making use of the InsertStatement, DeleteStatement or UpdateStatement classes
-
O (b) By invoking the execute(...) or executeUpdate(...) method of a normal Statement object
-
O (c) By invoking the executeInsert(...), executeDelete(...) or executeUpdate(...) methods of
-
O (d) By making use of the execute(...) statement of the DataModificationStatement object
To execute DML statements (i.e. insert, delete, update) in the database, the user needs to know the methods or classes available to achieve this.
Option A is incorrect because there are no predefined classes in Java named InsertStatement, DeleteStatement or UpdateStatement for executing DML statements in a database.
Option B is correct. You can execute DML statements by invoking the execute() or executeUpdate() method of a normal Statement object. The execute() method is used for executing any type of SQL statement and can return a boolean value indicating whether the query returns a ResultSet or not. The executeUpdate() method is used for executing insert, delete, and update statements and returns an integer value representing the number of rows affected by the query.
Option C is incorrect because there are no predefined methods named executeInsert(), executeDelete() or executeUpdate() for executing DML statements in Java.
Option D is incorrect because there is no class named DataModificationStatement in Java.
Therefore, the correct answer is:
The Answer is: B