Distinguish between Char and VarChar data types. Include examples and tradeoffs
What will be an ideal response?
Char data type is fixed-length, so that no matter the actual length of the data entered it will always take exactly the same storage space. For example, Char(10 ) indicates that 10 characters will always be stored for each value of that column. If the actual data entered is less than the specified fixed- length, the data will be padded with blanks. VarChar data type is variable length so that only the amount of space actually needed to store the data is used. Although VarChar may be more efficient in its use of space, it is not always preferred. VarChar requires the storage of some extra data to indicate the length of the data values, plus it requires some extra processing by the DBMS to arrange the variable length data. As another example, VarChar(10 ) indicates that the maximum length of a string to be stored in that field will be 10 characters. If the actual data are shorter, then fewer than 10 characters will be stored.
You might also like to view...
A company allocates $7.50 overhead to products based on the number of direct labor hours worked. The company uses a plantwide overhead rate with direct labor hours as the allocation base. Given the amounts below, how many direct labor hours does the company expect in department 2?Estimated:Department 1Department 2Manufacturing overhead costs$74,358 $49,572 Direct labor hours 6,610DLH ?DLHMachine hours 700MH 800MH
A. 3,109 DLH B. 9,914 DLH C. 16,254 DLH D. 6,612 DLH E. 7,454 DLH
Continuous production losses are assumed to occur at the end of a process
Indicate whether the statement is true or false
The Endangered Species Act applies only to private parties
Indicate whether the statement is true or false
Hull Company reported the following income statement information for the current year: Sales$412,000? Cost of goods sold: Beginning inventory$135,000? Cost of goods purchased 275,000? Cost of goods available for sale 410,000? Ending inventory 146,000? Cost of goods sold 264,000? Gross profit$148,000? The beginning inventory balance is correct. However, the ending inventory figure was overstated by $22,000. Given this information, the correct gross profit would be:
A. $148,000. B. $170,000. C. $113,000. D. $126,000. E. $139,000.