« previous next »

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

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

Did you know?

In 2010, opiate painkllers, such as morphine, OxyContin®, and Vicodin®, were tied to almost 60% of drug overdose deaths.

Did you know?

The longest a person has survived after a heart transplant is 24 years.

Did you know?

The most destructive flu epidemic of all times in recorded history occurred in 1918, with approximately 20 million deaths worldwide.

Did you know?

Patients who cannot swallow may receive nutrition via a parenteral route—usually, a catheter is inserted through the chest into a large vein going into the heart.

Physical assessment is one component of the nursing database Physical assessment is one component of the nursing database
Sample budget spreadsheet form for first year of business. Sample budget spreadsheet form for first year of business.
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: Male Reproductive System - Testosterone

For a complete list of videos, visit our video library