Discussion
Home ‣ Database ‣ Data Models into Database Designs Comments
- Question
Each entity is represented as a(n):
Options- A. tuple.
- B. table.
- C. attribute.
- D. file.
- Correct Answer
- table.
- 1. The identifier of an entity will become the ________ of the new table.
Options- A. foreign key
- B. main attribute
- C. primary key
- D. identity key Discuss
- 2. 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?
Options- A. Null status
- B. Data type
- C. Default value
- D. Data constraints Discuss
- 3. 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?
Options- A. A domain constraint
- B. A range constraint
- C. An intrarelation constraint
- D. An interrelation constraint Discuss
- 4. Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
Options- A. Null status
- B. Data type
- C. Default value
- D. Data constraints Discuss
- 5. If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
Options- A. the primary key
- B. any alternate key
- C. a surrogate key
- D. a foreign key Discuss
- 6. Which of the following situation requires the use of ID-dependent entities?
Options- A. Association relationships only
- B. Multivalued attributes only
- C. Archetype/instance relationships only
- D. All of the above use ID dependent entities Discuss
- 7. A primary key should be defined as:
Options- A. NULL.
- B. NOT NULL.
- C. Either of the above can be used.
- D. None of the above are correct. Discuss
- 8. In a 1:1 relationship, the foreign key is placed in:
Options- 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. Discuss
- 9. In a 1:N relationship, the foreign key is placed in:
Options- 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. Discuss
- 10. What SQL command can be used to add columns to a table?
Options- A. MODIFY TABLE TableName ADD COLUMN ColumnName
- B. MODIFY TABLE TableName ADD ColumnName
- C. ALTER TABLE TableName ADD COLUMN ColumnName
- D. ALTER TABLE TableName ADD ColumnName Discuss
Data Models into Database Designs problems
Search Results
Correct Answer: primary key
Correct Answer: Default value
Correct Answer: An intrarelation constraint
Correct Answer: Data type
Correct Answer: the primary key
Correct Answer: All of the above use ID dependent entities
Correct Answer: NOT NULL.
Correct Answer: either table without specifying parent and child tables.
Correct Answer: the child table.
Correct Answer: ALTER TABLE TableName ADD ColumnName
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.