This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Since Microsoft Access is a personal database, it is not subject to the modification problems that ... (Read 84 times)

Medesa

  • Hero Member
  • *****
  • Posts: 507
on: Jul 7, 2018
Since Microsoft Access is a personal database, it is not subject to the modification problems that occur in other relational databases.
 
  Indicate whether the statement is true or false

Question 2

Distinguish between Char and VarChar data types.
 
  What will be an ideal response?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

krakiolit

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

FALSE

Answer to Question 2

Char data type is fixed length, so that no matter what the actual length of the data entered is, it will always take exactly the same storage space. For example, Char(10 ) indicates that 10 characters will always be stored for each value of that column. If the actual data entered is less than the specified fixed length, the data will be padded with blanks. VarChar data type is variable length so that only the amount of space actually needed to store the data is used. Although VarChar may be more efficient in its use of space, it is not always preferred. VarChar requires the storage of some extra data to indicate the length of the data values, plus it requires some extra processing by the DBMS to arrange the variable length data.


Medesa

  • Member
  • Posts: 507
Reply 2 on: Jul 7, 2018
Excellent

mammy1697

  • Member
  • Posts: 341
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

According to the American College of Allergy, Asthma & Immunology, more than 50 million Americans have some kind of food allergy. Food allergies affect between 4 and 6% of children, and 4% of adults, according to the CDC. The most common food allergies include shellfish, peanuts, walnuts, fish, eggs, milk, and soy.

Did you know?

Blastomycosis is often misdiagnosed, resulting in tragic outcomes. It is caused by a fungus living in moist soil, in wooded areas of the United States and Canada. If inhaled, the fungus can cause mild breathing problems that may worsen and cause serious illness and even death.

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?

All adults should have their cholesterol levels checked once every 5 years. During 2009–2010, 69.4% of Americans age 20 and older reported having their cholesterol checked within the last five years.

Did you know?

Oliver Wendell Holmes is credited with introducing the words "anesthesia" and "anesthetic" into the English language in 1846.

Herniated disk. A herniated disk is a protrusion of the disk’s gelatinous center, called the nucleus Herniated disk. A herniated disk is a protrusion of the disk’s gelatinous center, called the nucleus
Common eye and vision problems Common eye and vision problems
Behavior modification has been useful in raising the amount of social responding by children with ... Behavior modification has been useful in raising the amount of social responding by children with ...
An example of a medical history sheet to list patient problems. An example of a medical history sheet to list patient problems.
Human Modification: Environmental Issues Human Modification: Environmental Issues
How to solve angle of depression problems in right triangles How to solve angle of depression problems in right triangles
Video: Interview with Person having Obsessive Compulsive Disorder

For a complete list of videos, visit our video library