Interview Questions Answers in IBM AS400 AllOther, DB400, COBOL400

Questions / { cyjil }

Questions Answers Category Views Company eMail

What is the purpose of USROPN keyword?

CTS,

1 IBM AS400 AllOther 19364

What is LEVEL CHECK?

HCL, TCS,

7 IBM AS400 AllOther 55030

write a pgm to read p.f using cl pgm?

Ocwen, SLK, TCS,

2 IBM AS400 AllOther 12265

Question { IBM, 40951 }

What is the benefit of using Externally Described files
over Internally
Described?

Answer

EXTERNALLY DESCRIBED FILE CONTAINS NAME AND RECORD LENGTH..
BUT IT DOESN'T CONTAINS DDS LEVEL ENTRIES

Is This Answer Correct ?

2 Yes

4 No

Question { Accenture, 111287 }

What is the difference between a Physical File & a Logical?

Answer

A PHYSICAL FILE IS A DATABASE FILE AND IT CONTAINS DATA..
LOGICAL FILE IS AN ARRANGEMENT OF DATAS FROM ONE OR MORE
PHYSICAL FILE.. BUT IT DOESN'T CONTAINS DATA.. IT IS A VIEW
OF P.F

Is This Answer Correct ?

9 Yes

10 No

Question { 16014 }

What is SDA used for?

Answer

SCREEN DESIGN AID ARE USED FOR CREATING A DISPLAY FILE.. IT
IS ONE OF THE APPLICATION DEVELOPMENT TOOL IN AS/400..

Is This Answer Correct ?

4 Yes

0 No

Question { Ordain Solutions, 31079 }

What are Triggers?

Answer

TRIGGERS ARE SOME RESTRICTIONS IN A P.F.. TO PROTECT THE
DATAS AND PROTECT THE FILE ALSO....

Is This Answer Correct ?

4 Yes

3 No

Question { HSBC, 11735 }

what is the difference between adding keys & constraints
into a phisical file

Answer

CONSTRAINTS ARE ADDED EXTERNALLY .... BUT KEYS ARE ADDED
INTERNALLY..

Is This Answer Correct ?

6 Yes

1 No

Question { 12353 }

what is the difference between comp & comp-3?

Answer

hellow sainath,
the comp answer is wrong... the correct answer is if
comp is using first 1 to 4 digits 2 bytes 5 to 9 digits 4
bytes and 10 to 18 digits 8 bytes allocating... k...

Is This Answer Correct ?

22 Yes

0 No