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 :