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 64 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
:D TYSM

amit

  • Member
  • Posts: 364
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

Every 10 seconds, a person in the United States goes to the emergency room complaining of head pain. About 1.2 million visits are for acute migraine attacks.

Did you know?

People with alcoholism are at a much greater risk of malnutrition than are other people and usually exhibit low levels of most vitamins (especially folic acid). This is because alcohol often takes the place of 50% of their daily intake of calories, with little nutritional value contained in it.

Did you know?

Despite claims by manufacturers, the supplement known as Ginkgo biloba was shown in a study of more than 3,000 participants to be ineffective in reducing development of dementia and Alzheimer’s disease in older people.

Did you know?

To combat osteoporosis, changes in lifestyle and diet are recommended. At-risk patients should include 1,200 to 1,500 mg of calcium daily either via dietary means or with supplements.

Did you know?

Women are two-thirds more likely than men to develop irritable bowel syndrome. This may be attributable to hormonal changes related to their menstrual cycles.

An example of a two-component regulatory system in bacteria An example of a two-component regulatory system in bacteria
Jets Created by a Black Hole in a Binary System Jets Created by a Black Hole in a Binary System
TEN RULES OF PERFORMANCE IN A REDESIGNED HEALTH CARE SYSTEM TEN RULES OF PERFORMANCE IN A REDESIGNED HEALTH CARE SYSTEM
Female Reproductive System "الجهاز التناسلي للأنثى" Female Reproductive System "الجهاز التناسلي للأنثى"
Sensory systems and Endocrine system Sensory systems and Endocrine system
The system of naming chromosome bands. Each autosome is numbered from 1 to 22. The sex chromosomes a The system of naming chromosome bands. Each autosome is numbered from 1 to 22. The sex chromosomes a
Video: Junction Types - Tight and Adherens Junctions

For a complete list of videos, visit our video library