> > >

MySQL MCQs

Which of the following statements are correct regarding the CREATE TABLE statement?

The AUTO_lNCREMENT attribute applies only to integer and floating-point data types.

The DEFAULT attribute applies to the BLOB or TEXT types.

It If neither NULL nor NOT NULL is specified. the column is treated as though NOT NULL had been specified.

CHAR, VARCHAR, TEXT data types can include the CHARACTER SET and COLLATE attributes.

Answer

Correct Answer: CHAR, VARCHAR, TEXT data types can include the CHARACTER SET and COLLATE attributes.

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