Became a Gold Member and access 40+ Technology Courses...
Live Help (Start Chat)
Interview Questions and Answer
Options:
a. A Cursor reads every row one by one.
b. They can be used to update a set of rows or a single specific row in a resultset
c. They can be positioned to specific rows.
d. Cursors lock row(s) while updating them.
Reveal Answer
Options:
a. A cursor cannot be used once it is deallocated
b. A cursor can be reopened any number of times after it is closed and before it is de allocated
c. The cursor is populated when FETCH attribute is used
d. All the above
Reveal Answer
Options:
a. Batch-1 gives the number of rows in the cursor
b. Batch-2 opens the cursor successfully as it was not deallocated and gives the number rows in the cursor
c. In Batch-2 the cursor cannot be opened as the cursor cur_emp13 doesnot exist
d. In Batch-2 the print @@cursor_rows ouput is 0
Reveal Answer
Options:
a. Batch-1 gives the number of rows in the cursor
b. Batch-2 opens the cursor successfully as it was not deallocated and gives the number rows in the cursor
c. In Batch-2 the cursor cannot be opened as the cursor cur_emp13 doesnot exist
d. The cursor cur_emp13 closed in session1 can be opened in another session also, as it is declared as global
Reveal Answer
Options:
a. After opening the cursor only 'job and 'empname' columns can be updated
b. After opening the cursor only 'salary' and 'fkdeptno' columns can be updated
c. After opening the cursor all the columns can be updated
d. none
Reveal Answer
Options:
a. Explicit transaction
b. Auto-commit transaction
c. Implicit transaction
Reveal Answer
Options:
a. Implicit transactions
b. Auto-commit transaction
c. Both
d. None of the two transactions
Reveal Answer
Options:
a. Static Cursors
b. Dynamic Cursors
c. Keyset Driven Cursors
d. None of the mentioned
Reveal Answer
Options:
a. Updated
b. Inserted
c. Deleted
d. All of the mentioned
Reveal Answer
Options:
a. A Cursor is opened and populated by executing the SQL statement defined by the cursor
b. After data manipulation, we should close the cursor explicitly
c. A cursor is declared by defining the SQL statement that returns a result set
d. All of the mentioned
Reveal Answer
Options:
a. FOR
b. IF..ELSE
c. WHILE
d. All of the mentioned
Reveal Answer
Bestdotnet google plus