What are the tradeoffs when choosing fixed vs. variable length character types?

What will be an ideal response?


Fixed character types use very little processor time. They can just be written to disk without any additional calculation. They are, however, potentially wasteful of disk space, since the database writes the same number of characters to disk no matter how many are actually used by the value contained in the column. Variable character types, on the other hand, use more processing time, since the computer must determine the length of the characters used for each data entry. However, variable character types use disk space more effectively because they never write more characters to disk than are actually used.

Business

You might also like to view...

Cottonwood, Inc. produces two different products (Standard and Luxury) using two different activities: Machining, which uses machine hours as an activity driver, and Inspection, which uses number of batches as an activity driver. The cost of Machining is $500,000, while the cost of Inspection is $30,000. Standard uses 30% of total machine hours and 70% of total batches. What is the total activity cost assigned to Standard?

A. $22,500 B. $171,000 C. $125,000 D. $359,000

Business

The price at which a share of stock is bought or sold is known as par value.

Answer the following statement true (T) or false (F)

Business

In an advertisement for Planters peanuts and trail mix, a peanut wearing a monocle and a top hat and called Mr. Peanut represents the product quality. Mr. Peanut appears in all of the advertisements for Planters. This is an example of how a company can use a _____ executional style.

A. product symbol B. lifestyle C. spokesperson D. fantasy E. scientific evidence

Business

To implement and enforce federal environmental mandates, Congress authorized and empowered the EPA

a. True b. False Indicate whether the statement is true or false

Business