In ADO.NET, regarding ExecuteNonQuery() and ExecuteReader(), which of the following sentences are false?A ) ExecuteNonQuery() returns the number of rows affected in SQL statementB ) None of these answers are correctC ) Select operation is only executed by ExecuteReader()D ) ExecuteReader returns a DataReader objectE ) Insert, Update, Delete SQL operations are mainly executed by ExecuteNonQuery()

What does the executeQuery() method do?*1 pointExecutes the SQL query and updates the data in the databaseExecutes the SQL query and inserts data to the databaseExecutes the SQL query and returns data in a table from the databaseExecutes the SQL query and deletes the data in the database

In Java, which method is commonly used for executing SQL queries in JDBC?Question 1Answera.executeQuery()b.executeUpdate()c.execute()d.runQuery()

The SQL statement that queries or reads data from a table is ________ .SELECTREADQUERYNone of the above is correct.

Which of the following statement(s) is/are correct?  Tick all correct answer(s).  No partial marks and no negative marks.Select one or more:Functions always return boolean valuesOnce a function is executed, the control will be returned to where it was accessed fromA function is a self-contained program executing a specific taskEvery program consists of one or more functions

2. Describe the differences between the SQL UPDATE and DELETE statements. When would you use one over the other, and what precautions should be taken?