IT Questions and Answers :)

Tuesday, September 25, 2018

In sql, which of the following is applicable to the CHAR datatype?

In sql, which of the following is applicable to the CHAR datatype?

  • CHAR stores alphanumeric characters of fixed size
  • Stores alphanumeric characters of variable length
  • to create scripts containing infinite characters
  • Type as many characters as you want 

 
In sql, which of the following is applicable to the CHAR datatype?

EXPLANATION

The only difference between CHAR and VARCHAR2 is that CHAR stores fixed-length alphanumeric characters, between 1 and 2000 bytes or characters. If you are stored in the JUNIOR surname in a CHAR (50) column, a column will contain a JUNIOR string + 44 whitespaces that are automatically added to the total column volume.

SOURCE

http://www.fabioprado.net/2011/08/qual-tipo-de-dado-devo-usar-char.html

Share:

Popular Posts