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 232 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
Wow, this really help

mammy1697

  • Member
  • Posts: 341
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

Pink eye is a term that refers to conjunctivitis, which is inflammation of the thin, clear membrane (conjunctiva) over the white part of the eye (sclera). It may be triggered by a virus, bacteria, or foreign body in the eye. Antibiotic eye drops alleviate bacterial conjunctivitis, and antihistamine allergy pills or eye drops help control allergic conjunctivitis symptoms.

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

Did you know?

Nitroglycerin is used to alleviate various heart-related conditions, and it is also the chief component of dynamite (but mixed in a solid clay base to stabilize it).

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

Did you know?

Most women experience menopause in their 50s. However, in 1994, an Italian woman gave birth to a baby boy when she was 61 years old.

The conduction system of the heart; traces the path of the electrical impulse that stimulates the he The conduction system of the heart; traces the path of the electrical impulse that stimulates the he
digestive system digestive system
A typical lubrication system, showing the oil pan, oil pump, oil filter, and oil passages. A typical lubrication system, showing the oil pan, oil pump, oil filter, and oil passages.
The major structures of the limbic system: amygdala, hippocampus, cingulate cortex, fornix, septum, ... The major structures of the limbic system: amygdala, hippocampus, cingulate cortex, fornix, septum, ...
The major human endocrine glands and their central nervous system control centers The major human endocrine glands and their central nervous system control centers
Conduction system of the heart Conduction system of the heart
Video: Interview with Person having Obsessive Compulsive Disorder

For a complete list of videos, visit our video library