> > >

DB2 Programming MCQs

How would you retrieve the first 5 characters of FIRSTNAME column of DB2 table EMP?

SELECT SUBSTR(1,5,FIRSTNAME) FROM EMP;

SELECT SUBSTR(FIRSTNAME,1,5) FROM EMP;

SELECT SUBSTR(1,FIRSTNAME,5) FROM EMP;

SELECT INSTR(FIRSTNAME,1,5) FROM EMP;

Answer

Correct Answer: SELECT SUBSTR(FIRSTNAME,1,5) FROM EMP;

Explanation:

Note: This Question is unanswered, help us to find answer for this one

DB2 Programming Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it