Infosys DB2 Interview Questions

11/08/2009 No Comment

Infosys Mainframe DB2 Interview Questions.

Mainframe professionals are invited to share the answers.

  • Explain what do you mean by IMAGECOPY in DB2?
  • When do you use the IMAGECOPY? 
  • What is the use of COPY PENDING status?
  • What is CHECK PENDING in DB2?
  • What do you mean by QUIESCE?
  • Explain about clustering index?
  • Can you tell me how many clustering indexes can be defined for a table?
  • What is the difference between primary key and unique index?
  • Explain about sqlcode -922 ?
  • What is sqlcode -811 in DB2?
  • What does the sqlcode of -818 pertain to? 
  • What do you mean by dynamic SQL in DB2?
  • When is the access path determined for dynamic SQL?
  • If you have a view which is a join of two or more tables, can this view be updated?
  • What are simple, segmented and partitioned table spaces ?
  • What do you mean by filter factor in DB2?
  • Can you tell me where is the output of EXPLAIN stored?
  • What do you need to do before you do EXPLAIN?
  • What are the 4 environments which can access DB2?
  • What is an inner join, and an outer join?
  • What is FREEPAGE and PCTFREE in TABLESPACE creation?
  • What is index cardinality in DB2? 
  • Explain what is a synonym with examples?
  • Explain the difference between SYNONYM and ALIAS in DB2?
  • What do you mean by NOT NULL WITH DEFAULT? When will you use it?
  • What do you mean by NOT NULL? When will you use it in DB2?
  • When would you prefer to use VARCHAR?
  • Explain what are the contents of a DCLGEN?
  • What are the disadvantages of using VARCHAR in DB2?
  • How can you create a table MANAGER ( EMP#, MANAGER) where MANAGER is a foreign key which references to EMP# in the same table? Give the exact DDL.
  • What do you mean by auditing?
  • How can you concatenate the FIRSTNAME and LASTNAME in DB2?
  • How can you read VSAM file?
  • What is a NULL value? What are the pros and cons of using NULLS?
  • How can increase table space in DB2?
  • Can you use MAX on a CHAR column?
  • What does WITH HOLD option do?
  • Explain what is UNION and UNION ALL in DB2?
  • What is the use of VALUE function ?
  • How can you find the maximum value in a column in DB2?
  • What do you mean by aggregate functions. Explain?
  • At what stage DB2 must be up?
  • What techniques are used to retrieve data from more than one table in a single SQL statement?
  • How do you select a row using indexes?
  • How do you eliminate duplicate values in SELECT
  • What is a synonym? How is it used in DB2?
  • What is a pre-compile?
  • How do we unload the DB2 tables using JCL?
  • How to read last record in VSAM file?
  • What do you mean by a clustered index in DB2?
Related Posts

No comments :


Aired | The content is copyrighted and may not be reproduced on other websites. | Copyright © 2009-2016 | All Rights Reserved 2016

Contact Us | About Us | Privacy Policy and Disclaimer