Data Models into Database Designs An ideal primary key is short, numeric and seldom changing. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A foreign key is: a column containing the primary key of another table. used to define data types. All of these used to define null status. a column containing the primary key of another table. used to define data types. All of these used to define null status. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs When the parent entity is required and the parent has a surrogate key, update actions can be ignored. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The DBMS allows surrogate keys to be changed. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A primary key should be defined as: NULL. NOT NULL. Either of the above can be used. None of these NULL. NOT NULL. Either of the above can be used. None of these ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row? Null status Data type Data constraints Default value Null status Data type Data constraints Default value ANSWER DOWNLOAD EXAMIANS APP