For which Exception, if a SELECT statement attempts to retrieve data based on its conditions, this exception is raised when no rows satisfy the SELECT criteria?

Related MCQs

• The              clause allows us to select only those rows in the result relation of the           clause that satisfy a specified predicate.
• View the Exhibit and examine the data in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id UNION SELECT employee_id, department_id FROM employees WHERE department_id= 90 UNION SELECT employee_id, department_id FROM employees WHERE department_id= 10; What would be the outcome of the above SQL statement?
• In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?
• If access paths are available on all the conditions of a disjunctive selection, each index is scanned for pointers to tuples that satisfy the individual condition. This is satisfied by
• Which of the following is a structure that provides faster access to the rows of a table based on the values of one or more columns?
• In the above teaches relation ” Select * from teaches where Year = ‘2010’” displays how many rows?
• Which of the following consists of a row of column headings, together with zero or more rows of data values?
• Which algorithm uses equality comparison on a key attribute with a primary index to retrieve a single record that satisfies the corresponding equality condition.
• Which SQL keyword is used to retrieve a maximum value?
• The strategy can retrieve a single record if the equality condition is on a key; multiple records may be retrieved if the indexing field is not a key is