Sawaal
  • Home/
  • Searching for i

 Searching for "i"

Q:

In terms of DB2 indexing, what is the root page?

Answer

The simplest DB2 index is the B-tree and the B-tree's top page is called the root page. The root page entries represent the upper range limits of the index and are referenced first in a search. 


 

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is QUIESCE?

Answer

A QUIESCE flushes all DB2 buffers on to the disk. This gives a correct snapshot of the database and should be used before and after any IMAGECOPY to maintain consistency.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

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:

Why SELECT * is not preferred in embedded SQL programs?

Answer

- If the table structure is changed ( a field is added ), the program will have to be modified.


- Program might retrieve the columns which it might not use, leading on I/O over head.


- The chance of an index only scan is lost.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is meant by index cardinality?

Answer

The number of distinct values for a column is called index cardinality. DB2's RUNSTATS utility analyzes column value redundancy to determine whether to use a tablespace or index scan to search for data.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

How will u send data from a cobol file to db2 table?

Answer

USING HOST VARIABLE we can pass data from COBOL to DB2

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is a DB2 bind?

Answer

A DB2 bind is a process that builds an access path to DB2 tables. 

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is a DB2 plan?

Answer

An application plan or package is generated by the bind to define an access path. 

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview