« previous next »

Author Question: What are some of the drawbacks of using a spreadsheet like Excel for a database? What will be an ... (Read 42 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?

Multiple sclerosis is a condition wherein the body's nervous system is weakened by an autoimmune reaction that attacks the myelin sheaths of neurons.

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?

No drugs are available to relieve parathyroid disease. Parathyroid disease is caused by a parathyroid tumor, and it needs to be removed by surgery.

Did you know?

Liver spots have nothing whatsoever to do with the liver. They are a type of freckles commonly seen in older adults who have been out in the sun without sufficient sunscreen.

Did you know?

Never take aspirin without food because it is likely to irritate your stomach. Never give aspirin to children under age 12. Overdoses of aspirin have the potential to cause deafness.

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
A gene map for chromosome 12 from the NCBI database Map Viewer A gene map for chromosome 12 from the NCBI database Map Viewer
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: Body plan of euglena Animation

For a complete list of videos, visit our video library