Sql Return code -811

  1. Fetching only Zero Rows

  2. Fetching more than one row.

  3. Table not found

  4. BOTH A and B


Correct Option: B

AI Explanation

To answer this question, we need to understand the possible meanings of SQL return code -811.

SQL return code -811 typically indicates that a SELECT statement returned more than one row. Therefore, option B, "Fetching more than one row," is the correct answer.

Let's go through each option to understand why it is correct or incorrect:

A) Fetching only Zero Rows - This option is incorrect because SQL return code -811 does not indicate that zero rows were fetched. It specifically indicates that more than one row was fetched.

B) Fetching more than one row - This option is correct. SQL return code -811 indicates that a SELECT statement returned more than one row.

C) Table not found - This option is incorrect. SQL return code -811 is not related to a table not being found. It specifically indicates that multiple rows were fetched.

D) BOTH A and B - This option is incorrect. SQL return code -811 does not indicate fetching zero rows. It specifically indicates fetching more than one row.

Therefore, the correct answer is B) Fetching more than one row because SQL return code -811 indicates that a SELECT statement returned more than one row.

Find more quizzes: