Sawaal
  • Home/
  • Searching for L

 Searching for "L"

Q:

What does it mean if the null indicator has -1, 0, -2?

Answer

 -1 indicates the field is null


 0 indicates the field is not null


 -2 indicates the field is truncated

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 SQLCA?

Answer

- SQLCA stands for SQL Communication Area


- SQLCA is a structure of variables which are updated after every SQL statement’s execution


- Exactly only one SQLCA need to be provided to an application that contains executable SQL statements


- SQLCA is not applicable to JAVA application


- More than one SQLCA need to be provided for FORTRAN application

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

How does DB2 use multiple table indexes?

Answer

DB2 use the multiple indexes to satisfy multiple predicates in a SELECT statement that are joined by an AND or OR.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is DBRM? What it contains? When it will be created?

Answer

- DBRM stands for Database Request Module


- The output of pre-compile process is represented as DBRM


- The SQL statements are extracted from the host language by the pre-compiler

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

Difference between Embeded SQL and Dynamic SQL?

Answer

Static (embedded) SQL:


1.In static SQL how database will be accessed is predetermined in the embedded SQL statement.


2.It is more swift and efficient.


3.SQL statements are compiled at compile time.


4.Parsing, validation, optimization, and generation of application plan are done at compile time.


5.It is generally used for situations where data is distributed uniformly.


6.EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are not used.


7. It is less flexible 


 


Dynamic (interactive) SQL:


1.In dynamic SQL, how database will be accessed is determined at run time.


2.It is less swift and efficient.


3.SQL statements are compiled at run time.


4.Parsing, validation, optimization, and generation of application plan are done at run time.


5.It is generally used for situations where data is distributed non-uniformly.


6.EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are used.


7.It is more flexible.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

How do you display last 5 records in DB2?

Answer

SELECT * FROM table_name ORDER BY column_name desc Fetch first 5 rows only;

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is sqlcode -811?

Answer

SELECT statement has resulted in retrieval of more than one row.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview