Maximum length of field name - Database

Q.  What is the maximum length of a field name?
- Published on 27 Aug 15

a. 10 characters
b. 30 characters
c. 50 characters
d. 20 characters

ANSWER: 10 characters
 

    Discussion

  • Nirja Shah   -Posted on 30 Oct 15
    - The VARCHAR2 and CHAR types support two methods of specifying lengths:

    - In bytes: VARCHAR2(10 byte)
    It will support up to 10 bytes of data, which could be as few as two characters in a multi-byte character sets.

    - In characters: VARCHAR2(10 char)
    It will support to up 10 characters of data, which could be as much as 40 bytes of information.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)