MainFrame Interview Questions
Questions Answers Views Company eMail

What is cursor in dbms?

595

Which command is used to remove all rows from a table?

554

What is a cursor in programming?

599

What is the difference between drop table and delete table?

558

What is the difference between using bind () and rebind () methods of naming class?

798

What is the difference between plan and package in db2?

581

How to create backup table in db2?

648

How to check sequence on a table in db2?

602

What is declare cursor?

617

How do I connect my db2 database to ibm?

605

What is explain plan in db2?

592

Can we update view in db2?

562

What is null indicator in cobol db2?

589

How to connect to db2 database from windows command line?

565

How do I add a column in db2?

597


Un-Answered Questions { MainFrame }

Which is faster delete or truncate?

681


Explain how many work file we can code in jcl?

576


What is the difference between pct and fct?

659


What is program status data structure(psds) in as400?

613


What is the use of qsam?

442






Explain what you understand by passing by value.

706


What are the contents of a dclmgen?

630


What is speed parameters in define cluster command?

507


what is a non-join logical file?

986


Explain associator in adabas?

489


explain the use of dftwrt display keyword?

1143


What is the maximum No of rows per page?

631


Explain correlated sub-queries.

589


Explain the device independent method to indicate where a record is stored?

483


what are the statements that are not valid to be included in an include statement?

778