Data Models into Database Designs Which of the following columns is(are) are required in a table? A surrogate key An alternate key A primary key A foreign key A surrogate key An alternate key A primary key A foreign key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A foreign key is used to implement relationships between tables. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs When the parent entity is required, a new child row can always be inserted. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table? An interrelation constraint An intrarelation constraint A range constraint A domain constraint An interrelation constraint An intrarelation constraint A range constraint A domain constraint ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which is not true about surrogate keys? They are fixed. They have meaning to the user. They are numeric. They are short. They are fixed. They have meaning to the user. They are numeric. They are short. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following column properties specifies whether or not cells in a column must contain a data value? Data type Data constraints Default value Null status Data type Data constraints Default value Null status ANSWER DOWNLOAD EXAMIANS APP