« previous next »

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

Prostaglandins were first isolated from human semen in Sweden in the 1930s. They were so named because the researcher thought that they came from the prostate gland. In fact, prostaglandins exist and are synthesized in almost every cell of the body.

Did you know?

Approximately one in three babies in the United States is now delivered by cesarean section. The number of cesarean sections in the United States has risen 46% since 1996.

Did you know?

After a vasectomy, it takes about 12 ejaculations to clear out sperm that were already beyond the blocked area.

Did you know?

Disorders that may affect pharmacodynamics include genetic mutations, malnutrition, thyrotoxicosis, myasthenia gravis, Parkinson's disease, and certain forms of insulin-resistant diabetes mellitus.

Did you know?

Immunoglobulin injections may give short-term protection against, or reduce severity of certain diseases. They help people who have an inherited problem making their own antibodies, or those who are having certain types of cancer treatments.

Sample budget spreadsheet form for first year of business. Sample budget spreadsheet form for first year of business.
Benefits and Drawbacks of Aquaculture "فوائد وعيوب تربية الأحياء" Benefits and Drawbacks of Aquaculture "فوائد وعيوب تربية الأحياء"
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
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: Acids and bases - definition

For a complete list of videos, visit our video library