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?

Related MCQs

• Which SQL function is used to count the number of rows in a SQL query?
• Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
• Which of the following attribute of implicit cursor always evaluates to false?
• The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called
• The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called
•                  dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re- create the database.
• 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?
• Which one of the following sorts rows in SQL?
• In the PL/SQL block below, how many rows will be inserted in the messages table? DECLARE v_start_salesNUMBER := 2; v_end_sales NUMBER := 100; BEGIN FOR i IN v_start_sales..v_end_sales LOOP INSERT INTO messages(msgid) VALUES v_start_sales; END LOOP; END;
• The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called