This topic contains a solution. Click here to go to the answer

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

serike

  • Hero Member
  • *****
  • Posts: 542
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
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


frankwu0507

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

 

Did you know?

Amoebae are the simplest type of protozoans, and are characterized by a feeding and dividing trophozoite stage that moves by temporary extensions called pseudopodia or false feet.

Did you know?

The heart is located in the center of the chest, with part of it tipped slightly so that it taps against the left side of the chest.

Did you know?

Fewer than 10% of babies are born on their exact due dates, 50% are born within 1 week of the due date, and 90% are born within 2 weeks of the date.

Did you know?

Malaria was not eliminated in the United States until 1951. The term eliminated means that no new cases arise in a country for 3 years.

Did you know?

There are immediate benefits of chiropractic adjustments that are visible via magnetic resonance imaging (MRI). It shows that spinal manipulation therapy is effective in decreasing pain and increasing the gaps between the vertebrae, reducing pressure that leads to pain.

For a complete list of videos, visit our video library