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

Author Question: Microsoft Access is a personal database system, and a personal database system is characterized by ... (Read 231 times)

serike

  • Hero Member
  • *****
  • Posts: 542
on: Jul 7, 2018
Microsoft Access is a personal database system, and a personal database system is characterized by ________.
 
  A) the DBMS removing the metadata from the database
  B) the DBMS product taking the role of the DBMS and the database application generator
  C) the DBMS not supporting indexes
  D) the DBMS product being limited to a maximum of ten tables in any given database

Question 2

Distinguish between Char and VarChar data types. Include examples and tradeoffs.
 
  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

Ahnyah

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

B

Answer to Question 2

Char data type is fixed-length, so that no matter the actual length of the data entered 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. As another example, VarChar(10 ) indicates that the maximum length of a string to be stored in that field will be 10 characters. If the actual data are shorter, then fewer than 10 characters will be stored.


serike

  • Member
  • Posts: 542
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review

ghepp

  • Member
  • Posts: 361
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Asthma is the most common chronic childhood disease in the world. Most children who develop asthma have symptoms before they are 5 years old.

Did you know?

Blood in the urine can be a sign of a kidney stone, glomerulonephritis, or other kidney problems.

Did you know?

Autoimmune diseases occur when the immune system destroys its own healthy tissues. When this occurs, white blood cells cannot distinguish between pathogens and normal cells.

Did you know?

Although not all of the following muscle groups are commonly used, intramuscular injections may be given into the abdominals, biceps, calves, deltoids, gluteals, laterals, pectorals, quadriceps, trapezoids, and triceps.

Did you know?

IgA antibodies protect body surfaces exposed to outside foreign substances. IgG antibodies are found in all body fluids. IgM antibodies are the first type of antibody made in response to an infection. IgE antibody levels are often high in people with allergies. IgD antibodies are found in tissues lining the abdomen and chest.

Sagittal section of upper respiratory system illustrating the internal anatomy of the nasal cavity, Sagittal section of upper respiratory system illustrating the internal anatomy of the nasal cavity,
Major glands of the human endocrine system Major glands of the human endocrine system
Stressing that education reproduces a country’s social class system, conflict theorists point out ... Stressing that education reproduces a country’s social class system, conflict theorists point out ...
Degenerative Diseases of the Central Nervous System Degenerative Diseases of the Central Nervous System
How to solve a linear system by the substitution method How to solve a linear system by the substitution method
The Central Nervous System Includes the Brain and Spinal Cord The Central Nervous System Includes the Brain and Spinal Cord
Video: Effect of blood chemistry - stimuli, hyperventilation response and hypoventilation response

For a complete list of videos, visit our video library