This topic contains a solution. Click here to go to the answer

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

Medesa

  • Hero Member
  • *****
  • Posts: 507
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
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
:D TYSM


bdobbins

  • Member
  • Posts: 326
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

 

Did you know?

Earwax has antimicrobial properties that reduce the viability of bacteria and fungus in the human ear.

Did you know?

Many of the drugs used by neuroscientists are derived from toxic plants and venomous animals (such as snakes, spiders, snails, and puffer fish).

Did you know?

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Did you know?

There are 20 feet of blood vessels in each square inch of human skin.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

For a complete list of videos, visit our video library