Which of the following will change as a result?

Examine the following table:

In the table, you deleted the record of Mark Smith.Which of the following will change as a result?

Examine the following table:

In the table, you deleted the record of Mark Smith.Which of the following will change as a result?

A.
Degree of the table

B.
Cardinality of the table

C.
Domain of the table

D.
Attribute of the table

Explanation:
In tables, the number of rows (or tuples) is calledthe cardinality. When a record (or row) of the table is deleted
(or added), the cardinality of the table changes. Answer A and D When a column of the table is changed, the
degree (or attribute is changed). The degree of a table refers
to the number of columns that a table has. The number of columns contained in a table is referred to by the
term degree of the table; if the
degree of a table is increased by 1, it means that a new column is added to the table. The degree of the table
denotes the number of columns
or attributes.
Answer C is incorrect. A Domain is a set of allowable values for one or more attributes. It is also known as the
data domain which refers to all the unique values which a data element may contain. The Domain boundary
can be defined by rules such as a the data type with an enumerated list of values. Check constraint isalso a
simple example of defining the boundary of a domain.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Lena

Lena

In tables, the number of rows (or tuples) is called the cardinality.