why varchar takes 2 extra bytes?

Answer Posted / kallol

The two bytes are for the number of bytes for the binary
length of the field

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

576


What are the various indexes in teradata?

569


What is bteq utility in teradata?

573


Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

652


Why are oltp database designs not generally a good idea for a data warehouse?

599






How teradata makes sure that there are no duplicate rows being inserted when its a set table?

561


What are the various indexes in teradata? How to use them? Why are they preferred?

594


What do you mean by caching in teradata?

609


What is spool space?

605


Explain teradata utilities?

570


What is the purpose of joins in teradata?

546


Highlight the differences between Primary Key and Primary Index.

620


Write a program to show the parser component used in teradata?

552


What is meant by a dispatcher?

570


Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

592