Explain what primary, secondary and unique key indexes are
What will be an ideal response?
A primary key index is automatically generated when a table is created (provided that a primary key is specified). The primary key index identifies uniquely each row of the table. Thus, there is one entry in the primary key index for each row. A unique key index is similar, except that we have to define this with a separate create index command. A secondary key is nonunique. So, for example, we might create a secondary index on state. Since many records would have the same state, this is non-unique.
You might also like to view...
Your co-worker asked you about your commitment to your work. You responded by saying not only did you have a commitment but you had a "passionate" commitment. Describe this type of commitment. In your response, include specific examples
What will be an ideal response?
Two methods are available to prepare the operating activities section of a statement of cash flows. Which of the following statements regarding these two methods is false?
a. If a company uses the indirect method, it must separately disclose the cash payments made for interest and income taxes. b. If a company uses the direct method, it must present a separate schedule which reconciles net income to net cash from operating activities. c. Advocates of the direct method believe that the indirect method reveals too much by telling readers gross amounts of cash receipts and cash payments from operations. d. The FASB prefers the direct method, while most companies use the indirect method in practice.