2.3) Which one is not one of the definitions of a NULL value? a) The attribute does not apply to this tuple (i.e. Not Applicable → NA) b) The data type is not suitable for the entry data c) The attribute value for this tuple is unknown d) The attribute value for this tuple will be determined later e) The value is known but absent 2.4) Which below statement is not true for indexes? a) Each table may contain at most one clustered index b) Each table may contain none to many non-clustered index c) Actual data is kept in the leaf of non-clustered index d) Indexes are used to store data and allow efficient data retrieval e) Non-clustered indexes increase data retrieval performance but decreases data modification performance 2.5) Which below is not one of the isolation levels in transaction processing? a) Consistent read b) Read uncommitted c) Read committed d) Repeatable read e) Serializable
2.3) Which one is not one of the definitions of a NULL value?
a) The attribute does not apply to this tuple (i.e. Not Applicable → NA)
b) The data type is not suitable for the entry data
c) The attribute value for this tuple is unknown
d) The attribute value for this tuple will be determined later
e) The value is known but absent
2.4) Which below statement is not true for indexes?
a) Each table may contain at most one clustered index
b) Each table may contain none to many non-clustered index
c) Actual data is kept in the leaf of non-clustered index
d) Indexes are used to store data and allow efficient data retrieval
e) Non-clustered indexes increase data retrieval performance but decreases data modification performance
2.5) Which below is not one of the isolation levels in transaction processing?
a) Consistent read b) Read uncommitted c) Read committed d) Repeatable read e) Serializable
Step by step
Solved in 3 steps