When would you prefer to use VARCHAR ?
When a column which contains long text, e.g. remarks, notes, may have in most cases less than 50% of the maximum length.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What position do you prefer on a team working on a project? 02.12.08
Be honest. If you are comfortable in different roles, point that out....How do you load data from XML file to a ORACLE table? 22.11.08
This is from XML to sqlserver exce sp_xml_preparedocument @inthandle int output,@xmldocument select * from openxml(@inthandle,'/root/customer',2) with (custo...What position do you prefer on a team working on a project? 15.11.08
Be honest. If you are comfortable in different roles, point that out....If you had enough money to retire right now, would you? 15.11.08
Answer yes if you would. But since you need to work, this is the type of work you prefer. Do not say yes if you do not mean it....What is the difference between CHAR and VARCHAR data types? 06.11.08
CHAR is a fixed length data type. CHAR(n) will take n characters of storage even if you enter less than n characters to that column. For example, "Hello!" w...How To Create a Table? 06.11.08
If you want to create a table, you can run the CREATE TABLE statement as shown in the following sample script: Remember that mysql_query() returns TR...If you had enough money to retire right now, would you? 05.11.08
Answer yes if you would. But since you need to work, this is the type of work you prefer. Do not say yes if you do not mean it....What are the disadvantages of using VARCHAR ? 21.03.08
Can lead to high space utilization if most of the values are close to maximum. Positioning of VARCHAR column has to be done carefully as it has performance imp...Give the COBOL definition of a VARCHAR field ? 12.03.08
A VARCHAR column REMARKS would be defined as follows: 10 REMARKS. 49 REMARKS-LEN PIC S9(4) USAGE COMP. 49 REMARKS-TEXT PIC X(1920)....What are data types? 09.03.08
They are attributes of columns, literals, and host variables. The data types are SMALLINT, INTEGER, FLOAT, DECIMAL, CHAR, VARCHAR, DATE and TIME....