« previous next »

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

Only one in 10 cancer deaths is caused by the primary tumor. The vast majority of cancer mortality is caused by cells breaking away from the main tumor and metastasizing to other parts of the body, such as the brain, bones, or liver.

Did you know?

Critical care patients are twice as likely to receive the wrong medication. Of these errors, 20% are life-threatening, and 42% require additional life-sustaining treatments.

Did you know?

Amoebae are the simplest type of protozoans, and are characterized by a feeding and dividing trophozoite stage that moves by temporary extensions called pseudopodia or false feet.

Did you know?

More than nineteen million Americans carry the factor V gene that causes blood clots, pulmonary embolism, and heart disease.

Did you know?

Egg cells are about the size of a grain of sand. They are formed inside of a female's ovaries before she is even born.

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 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: Stomach peristalsis - Movement of Food Through the Small Intestine

For a complete list of videos, visit our video library