Discussion
Home ‣ Interview ‣ Technology See What Others Are Saying!
- Question
What is difference between MyISAM and InnoDB storage engines in mysql.
- Correct Answer
- 1 : InnoDB provides us row level locking while MyISAM provides us table level locking 2 : InnoDB offers foreign key constraints wheres in MyISAM does not have foreign key constraints 3 : InnoDB does not have full text search wheres MyISAM provides us full text search
- 1. The EIB field which gives the last CICS command executed is? Discuss
- 2. Specify the CICS command used to read a VSAM record starting with prefix F. Code all the relevant options? Discuss
- 3. How do you define a sort file in JCL that runs the COBOL program? Discuss
- 4. Each of the following is a sleep disorder except
Options- A. REM rebound
- B. Narcolepsy
- C. Night terrors
- D. Insomnia Discuss
- 5. How does IDMS insure data integrity? Discuss
- 6. The term 'menarche' refers to Discuss
- 7. How do you convert flat files to VSAM files? Discuss
- 8. Name some common VSAM error conditions and codes? Discuss
- 9. What are the three levels of definition for the VSAM DEFINE? Discuss
- 10. What are the processing modes available in IMS DB? Discuss
More questions
Correct Answer: EIBRCODE
Correct Answer: EXEC CICS READ DATASET('FILENAME') INTO(data-area) RIDFLD(data-area) KEYLENGTH(1) GENERIC LENGTH(WK-LEN) END-EXEC
Correct Answer: Use the SORTWK01, SORTWK02, dd names in the step Number of sort datasets depends on the volume of data being sorted, but a minimum of 3 is required
Correct Answer: REM rebound
Correct Answer: IDMS uses record locks to prevent another run-unit from updating the same record
Correct Answer: In Greek, the meaning of Menarche is Beginning Menarche is the first menstrual cycle, or first menstrual bleeding, in female humans From both social and medical perspectives, it is often considered the central event of female puberty, as it signals the possibility of fertility
Correct Answer: Use IDCAMS REPRO to load the flat file into the VSAM file
Correct Answer: End of file (10) Duplicate key (22) Record not found (23) VSAM logic error (90) Open problem (92) Space problem (93)
Correct Answer: They are DEFINE CLUSTER, DATA and INDEX
Correct Answer: Batch DL/I MPP Mode - (Message Processing Program) BMP Mode - (Batch Message Processing)
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.