1. Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values? A. A domain constraint B. A range constraint C. An intrarelation constraint D. An interrelation constraint Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
2. In a 1:N relationship, the foreign key is placed in: A. either table without specifying parent and child tables. B. the parent table. C. the child table. D. either the parent table or the child table. Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option C No explanation is given for this question Let's Discuss on Board
3. Which of the following column properties specifies whether or not cells in a column must contain a data value? A. Null status B. Data type C. Default value D. Data constraints Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
4. A primary key should be defined as: A. NULL. B. NOT NULL. C. Either of the above can be used. D. None of the above are correct. Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
5. Which of the following column properties would be used to specify that cells in a column must contain a monetary value? A. Null status B. Data type C. Default value D. Data constraints Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
6. Which of the following situation requires the use of ID-dependent entities? A. Association relationships only B. Multivalued attributes only C. Archetype/instance relationships only D. All of the above use ID dependent entities Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option D No explanation is given for this question Let's Discuss on Board
7. A foreign key is: A. a column containing the primary key of another table. B. used to define data types. C. used to define null status. D. all of the above are above correct. Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
8. Which of the following columns is(are) are required in a table? A. A foreign key B. An alternate key C. A primary key D. A surrogate key Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option C No explanation is given for this question Let's Discuss on Board
9. In a 1:1 relationship, the foreign key is placed in: A. either table without specifying parent and child tables. B. the parent table. C. the child table. D. either the parent table or the child table. Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
10. Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000? A. Null status B. Data type C. Default value D. Data constraints Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option C No explanation is given for this question Let's Discuss on Board
