Cursor that reflects the changes made to the database table even after the result set is returned

Related MCQs

• 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?
• Consider a hash table of size seven, with starting index zero, and a hash function (3x + 4)mod7. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Note that ‘_’ denotes an empty location in the table.
• Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.
• Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
• Which join refers to join records from the write table that have no matching key in the left table are include in the result set:
• If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the ____ property is violated and the database is no longer consistent.
• What does a COMMIT statement do to a CURSOR?
• Which of the following is a cursor operation?
• Which of the following attribute of implicit cursor always evaluates to false?
• ____ ensures that once transaction changes are done, they cannot be undone or lost, even in the event of a system failure.