what determines the kind of data that can be stored in a column of a table?
a. the default value that is assigned to the column
b. tthe data type that is assigned to the column
c. the relationship between the column and the primary value of the key
d. whether the column can contain a null value
Answer : Correct Option is Option(b) ie. the data type that is assigned to the column.
Explanation :
When a column in a table is defined, it is given a data type , that determines what kind of data it can store.
Hence,
Option(a) is Incorrect. Default value will not determine the kind of data that is assigned to the column.
Option(b) is Correct. The data type of the column will determine the kind of data that can be stored in column in table.
Option(c) is Incorrect. The relationship between the column and the primary value of the key will not determine the kind of data that a column will store in a table.
Option(d) is Incorrect. Whether column contain a null value , but it will not determine the kind of data that a column will store in a table.
Hence,
Option(b) is Correct. ie. the data type that is assigned to the column.
Get Answers For Free
Most questions answered within 1 hours.