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

Dnite

  • Member
  • Posts: 297
Reply 3 on: Yesterday
Gracias!

« previous next »
 

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?

Fatal fungal infections may be able to resist newer antifungal drugs. Globally, fungal infections are often fatal due to the lack of access to multiple antifungals, which may be required to be utilized in combination. Single antifungals may not be enough to stop a fungal infection from causing the death of a patient.

Did you know?

Though newer “smart” infusion pumps are increasingly becoming more sophisticated, they cannot prevent all programming and administration errors. Health care professionals that use smart infusion pumps must still practice the rights of medication administration and have other professionals double-check all high-risk infusions.

Did you know?

Signs and symptoms that may signify an eye tumor include general blurred vision, bulging eye(s), double vision, a sensation of a foreign body in the eye(s), iris defects, limited ability to move the eyelid(s), limited ability to move the eye(s), pain or discomfort in or around the eyes or eyelids, red or pink eyes, white or cloud spots on the eye(s), colored spots on the eyelid(s), swelling around the eyes, swollen eyelid(s), and general vision loss.

Did you know?

Cancer has been around as long as humankind, but only in the second half of the twentieth century did the number of cancer cases explode.

Procedures for Diagnostic Tests Related to the Musculoskeletal system Procedures for Diagnostic Tests Related to the Musculoskeletal system
Procedures for Diagnostic Tests Related to the Musculoskeletal system Procedures for Diagnostic Tests Related to the Musculoskeletal system
The nervous system. The nervous system.
Using a water-based cleaning system helps reduce the hazards from using strong chemicals. Using a water-based cleaning system helps reduce the hazards from using strong chemicals.
Turn head for access to suboccipital muscles and locate TrPs. Use fingers or thumb to apply pressure ... Turn head for access to suboccipital muscles and locate TrPs. Use fingers or thumb to apply pressure ...
The Hazardous Materials Identification System is used to label containers that hold hazardous ... The Hazardous Materials Identification System is used to label containers that hold hazardous ...
Video: Hemodynamics Animation

For a complete list of videos, visit our video library