> > >

MySQL MCQs

Which of the following statements is INCORRECT?

For TEXT and BLOB columns, there is no padding on insert and no bytes are stripped on select.

For indexes on BLOB and TEXT columns. you must specify an index pref‌ix length.

For indexes on CHAR and VARCHAR, a pref‌ix length is required. 0.02

BLOB and TEXT columns cannot have DEFAULT values.

Answer

Correct Answer: For indexes on CHAR and VARCHAR, a pref‌ix length is required. 0.02

Explanation:

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

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it