Which of the following are integrity controls that a DBMS may support?
A. Assume a default value in a field unless a user enters a value for that field.
B. Limit the set of permissible values that a field may assume.
C. Limit the use of null values in some fields.
D. All of the above.
Answer: Option D
This Question Belongs to Database >> Physical Database Design
A. All fields are stored in one relation.
B. All fields are stored in two relations.
C. All fields are stored in three relations.
D. All fields are stored in four relations.
Selecting a data type involves which of the following?
A. Maximize storage space
B. Represent most values
C. Improve data integrity
D. All of the above.
A. VARCHAR2
B. CHAR
C. LONG
D. NUMBER
A. All fields are stored in one relation.
B. All fields are stored in two relations.
C. All fields are stored in three relations.
D. All fields are stored in four relations.
Join The Discussion