Sawaal
  • Home/
  • Searching for Cursor

 Searching for "Cursor"

Q:

In the following question, out of the given four alternatives, select the one which best expresses the meaning of the given word.

Supercilious

 

- In the following question, out of the given four alternatives, select the one which best expresses the meaning of the given word.
Supercilious
- In the following question, out of the given four alternatives, select the one which best expresses the meaning of the given word.
Supercilious

A) Modest   B) Sociable  
C)  Arrogant   D) Rationa
 
Answer & Explanation Answer: C)  Arrogant  

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: English
Exam Prep: Bank Exams

Q:

The question below consists of a set of labelled sentences. Out of the four options given, select the most logical order of the sentences to form a coherent paragraph.

 

Although not all those who study

 

A-better thinkers and leaders

B-become philosophers, they become

C-logic or philosophy may

 

The question below consists of a set of labelled sentences. Out of the four options giv
en, select the most logical order of the sentences to form a coherent
paragraph.
Although not all those who study
A-
better thinkers and leaders
B-
become philosophers, they become
C-
logic or philosophy may

A) CAB B) BCA
C) CBA D) BAC
 
Answer & Explanation Answer: C) CBA

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: English
Exam Prep: Bank Exams

Q:

When does the SQL statement gets executed when you use cursor in the application programming?

Answer

SQL statement gets executed when we open cursor


 

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is the difference between Cursor Stability and Repeatable Read isolation levels?

Answer

CURSOR STABILITY:


- CS is a row level locking


- Acquires an exclusive lock on the row that is to be updated


- When the control is moved to the next updatable row, the lock is released


REPEATABLE READ:


- RR is a page level locking


- Acquires an exclusive lock on the entire page which is the source of row availability


- When the control is moved to the next updatable page the lock is released

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is a cursor ? Why should it be used in DB2?

Answer

Cursor is a programming device that allows the SELECT to find a set of rows but return them one at a time. Cursor should be used because the host language  can deal with only one row at a time.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

Define cursor attributes: %FOUND, %NOTFOUND, %ROWCOUNT, and %ISOPEN

Answer

- %FOUND


 This is a Boolean variable which evaluates to TRUE if the last row is successfully fetched.


 


- %NOTFOUND


 This is a Boolean variable which evaluates to TRUE if the last row is not successfully fetched. This means there are no more rows to fetch.


 


- %ROWCOUNT


 Returns the number of rows fetched by the cursor.


 


- %ISOPEN


If the cursor is open, it evaluates to TRUE else FALSE.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

What are Cursors? Explain Types of cursors in PL/SQL

Answer

Cursors help you manipulate the information retrieved by select statements. This can be done by assigning a name to the cursor.


Example:


CURSOR emp_cur 


IS 


SELECT emp_number from employee_tbl where employee_name = name_in;


Types of Cursors:


Implicit cursors- These cursors are not declared by the programmer. They are issued when the SQL statement is executed. The open, close and fetching is done by itself.


Example:


UPDATE employee SET salary = salary * 2.1;


Here, an implicit cursor is issued to identify the set of rows in the table which would be affected by the update.


 


Explicit cursors- These cursors are defined by programmer. They are used in queries that return multiple rows.


Example:


CURSOR emp_cur 


IS 


SELECT emp_number from employee_tbl where employee_name = name_in;

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

How to set the cursor to wait in JavaScript?

Answer

The cursor can set to wait in JavaScript by using the property ‘cursor’ property. The following example illustrates the usage.


window.document.body.style.cursor = "wait"; 

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology