> > >

DB2 Programming MCQs

How would you display the table definitions (columns, data types of columns, constraints or default values set etc) of a table in QMF?

By Desc comand

SELECT * FROM SYSIBM.SYSCOLUMNS WHERE TBNAME=table-name AND TBCREATOR=' creator-name';

SELECT * FROM SYSIBM.SYSCOLS WHERE TBNAME=table-name AND TBCREATOR='table-name';

None of above

Answer

Correct Answer: SELECT * FROM SYSIBM.SYSCOLUMNS WHERE TBNAME=table-name AND TBCREATOR=' creator-name';

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