> > >

SQL MCQs

What is the difference between CHAR and VARCHAR data types?

CHAR takes fixed space whereas VARCHAR takes variable space.

CHAR stores data as an array of characters, whereas VARCHAR stores data as strings.

CHAR cannot contain NULL values, wheres VARCHAR can contain NULL values.

CHAR in MySQL is the same as VARCHAR in Oracle.

Answer

Correct Answer: CHAR takes fixed space whereas VARCHAR takes variable space.

Explanation:

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

SQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it