Education platform for interview prep, online tests, tutorials, and live practice

Build skills with focused learning paths, mock tests, and interview-ready content.

WithoutBook brings subject-wise interview questions, online practice tests, tutorials, and comparison guides into one responsive learning workspace.

Search the library

Prepare Interview

SQL Interview Questions and Answers

← Previous
Next →

Question: What is difference between CHAR and VARCHAR2? What is the maximum SIZE allowed for each type?

Answer: CHAR pads blank spaces to the maximum length.
VARCHAR2 does not pad blank spaces.
For CHAR the maximum length is 255 and 2000 for VARCHAR2.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? Yes No

Most helpful rated by users:

What is SQL?
SQL*Plus
Date Functions
NVL
Character Functions