Question

Select all statements that correctly describe the ramifications of important features supported by modern DBMS.

a.

The ability for a database to grow large helps guarantee the integrity and consistency of data in the database.

b.

The support of data types helps prevent storage of inappropriate data, for example, support of a DATE data type that requires dates and excludes character strings or numbers.

c.

The ability to run on different types of hardware such as PCs and Sun Microsystems servers help guarantee the integrity and consistency of data in the database.

d.

The support of security constraints helps prevent unauthorized modification of data.

Answer 1

"Option b and Option d" is the correct option for this question.

Explanation:

In the database, datatype belongs to the information storage medium, which can hold a specific type of value. There are several data types, which is used in database like integer, character, series, floating-point and array numbers, and the rules, that give levels of security to information are known as a security constraints. It may be either developed as rules on integrity, mathematical formalism rules or schematic rules, and other choices were wrong which can be described as follows:

• In option a, The asserts, which is in any exchange in a database, should only modify the information, that is effected in acceptable ways is called consistency, that's why it is wrong.
• In option c, The validity and accuracy of the data in the database can not be ensured, that's why it is wrong.