« previous next »

Author Question: What are some of the drawbacks of using a spreadsheet like Excel for a database? What will be an ... (Read 66 times)

Caiter2013

  • Hero Member
  • *****
  • Posts: 607
on: Jul 7, 2018
What are some of the drawbacks of using a spreadsheet like Excel for a database?
 
  What will be an ideal response?

Question 2

Which of the following are true of a clustered index?
 
  A) It physically orders the rows in a table
  B) There can only be one clustered index in a given table
  C) It is often placed on the primary Key
  D) All of the above


mbcrismon

  • Sr. Member
  • ****
  • Posts: 328
Reply #1 on: Jul 7, 2018
Answer to Question 1

Spreadsheets often store redundant data, so it is easy for data to get inconsistent. Also, while most spreadsheets have some ability to sort and select data, it is difficult to compare different pieces of data to each other.

Answer to Question 2

D


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Astigmatism is the most common vision problem. It may accompany nearsightedness or farsightedness. It is usually caused by an irregularly shaped cornea, but sometimes it is the result of an irregularly shaped lens. Either type can be corrected by eyeglasses, contact lenses, or refractive surgery.

Did you know?

Side effects from substance abuse include nausea, dehydration, reduced productivitiy, and dependence. Though these effects usually worsen over time, the constant need for the substance often overcomes rational thinking.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates's recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

Many people have small pouches in their colons that bulge outward through weak spots. Each pouch is called a diverticulum. About 10% of Americans older than age 40 years have diverticulosis, which, when the pouches become infected or inflamed, is called diverticulitis. The main cause of diverticular disease is a low-fiber diet.

Did you know?

Over time, chronic hepatitis B virus and hepatitis C virus infections can progress to advanced liver disease, liver failure, and hepatocellular carcinoma. Unlike other forms, more than 80% of hepatitis C infections become chronic and lead to liver disease. When combined with hepatitis B, hepatitis C now accounts for 75% percent of all cases of liver disease around the world. Liver failure caused by hepatitis C is now leading cause of liver transplants in the United States.

Physical assessment is one component of the nursing database Physical assessment is one component of the nursing database
Benefits and Drawbacks of Aquaculture "فوائد وعيوب تربية الأحياء" Benefits and Drawbacks of Aquaculture "فوائد وعيوب تربية الأحياء"
Basic Marketing Research: Using Microsoft Excel Data Analysis Basic Marketing Research: Using Microsoft Excel Data Analysis
Excel Interpretation Excel Interpretation
Excel hardware is introducing a new product on a new product line of capacity 800 units per ... Excel hardware is introducing a new product on a new product line of capacity 800 units per ...
A gene map for chromosome 12 from the NCBI database Map Viewer A gene map for chromosome 12 from the NCBI database Map Viewer
Video: Stomach peristalsis - Movement of Food Through the Small Intestine

For a complete list of videos, visit our video library