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 108 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


Missbam101

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

 

Did you know?

Nearly all drugs pass into human breast milk. How often a drug is taken influences the amount of drug that will pass into the milk. Medications taken 30 to 60 minutes before breastfeeding are likely to be at peak blood levels when the baby is nursing.

Did you know?

Approximately 70% of expectant mothers report experiencing some symptoms of morning sickness during the first trimester of pregnancy.

Did you know?

Stroke kills people from all ethnic backgrounds, but the people at highest risk for fatal strokes are: black men, black women, Asian men, white men, and white women.

Did you know?

Vital signs (blood pressure, temperature, pulse rate, respiration rate) should be taken before any drug administration. Patients should be informed not to use tobacco or caffeine at least 30 minutes before their appointment.

Did you know?

The U.S. Pharmacopeia Medication Errors Reporting Program states that approximately 50% of all medication errors involve insulin.

For a complete list of videos, visit our video library