AS-400,AS/400 Technical Interview Questions Answers: Part II

AS-400, AS/400 Technical Interview Questions.

Which are the four keywords supported by Program Status Data Structure?
Answer :
*STATUS, *PARM, *ROUTINE & *PROGRAM

Which are the String Manipulation Opcodes?
Answer :
TESTN, SCAN, CHECK, CHECKR, SUBST & CAT

DB2 is a type of Database?
Ans
:It is an Integrated RDBMS.

An access path may be in which sequence?
Answer :
It can be in Arrival & Keyed sequence

To change constant field defined on RLU screen which field level keyword should be used?
Answer :
DFT (Default)

Space & Skip are which level keywords?
Answer :
Field & Record

A Join Logical File has how many Record formats?
Answer : 1

A Multiple format Logical File is also known as?
Answer :
Union File

How does Union file maintains Record formats?
Answer :
1 Record format for each PF

Records can be Read/Update/Deleted with which file?
Answer :
Simple Logical File & Physical File.

Which type of object is used in DB2/400?
Ans
:*FILE

What is SQL?
Answer :
SQL is an interface for programming language.

File level entry for a PF can be?
Answer :
UNIQUE & FIFO

What is the command to create FRF?
Answer :
CRTPF

Join Logical File displays data from how many files?
2 or more PF’s

A Query can be displayed without saving it?
Answer :
True

Which are the Query selection criteria, which can be given in a Query?
Answer :
LIST

To add a file to the ‘File Selection’ option of a Query, the function key to be pressed is?
Answer :
F9

A query can be run in which mode?
Answer :
Batch & Interactive

What is the values SQLCOD when there is an error in fetching the records specified in the select statement?
Answer : -
ve value

A file cannot have more than 1 unique key?
Answer :
False

DLCOBJ command is mandatory for removing lock on any object?
Answer :
False

What is a Journal?
Answer :
A Journal is an object used primarily to record changes to data in a PF.

Which are the DB2 tools to protect Integrity of the database?
Answer :
Journaling & Commitment Control, Referential Integrity Embedded SQL & Object/Record Locks.
Related Posts

No comments:

 

Aired | Copyright © 2009-2014| All Rights Reserved 2014

Contact Us | About Us