Discussion
Home ‣ Database ‣ Data Modeling with ER Model Comments
- Question
In which of the following is a single-entity instance of one type of related to a single-entity instance of another type?
Options- A. One-to-One Relationship
- B. One-to-Many Relationship
- C. Many-to-Many Relationship
- D. Composite Relationship
- Correct Answer
- One-to-One Relationship
- 1. In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.
Options- A. parent
- B. child
- C. instance
- D. subtype Discuss
- 2. Which of the following refers to something that can be identified in the users' work environment, something that the users want to track?
Options- A. Entity
- B. Attribute
- C. Identifier
- D. Relationship Discuss
- 3. Which of the following indicates the minimum number of entities that must be involved in a relationship?
Options- A. Minimum cardinality
- B. Maximum cardinality
- C. ERD
- D. Greater Entity Count (GEC) Discuss
- 4. Entities can be associated with one another in which of the following?
Options- A. Entities
- B. Attributes
- C. Identifiers
- D. Relationships Discuss
- 5. Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?
Options- A. Supertype entity
- B. Subtype entity
- C. Archetype entity
- D. Instance entity Discuss
- 6. Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?
Options- A. Weak entity
- B. Strong entity
- C. ID-dependent entity
- D. ID-independent entity Discuss
- 7. What is not an advantage of stored procedures?
Options- A. Greater security
- B. SQL can be optimized
- C. Code sharing
- D. Increased network traffic Discuss
- 8. The SQL statement to create a view is:
Options- A. CREATE VIEW.
- B. MAKE VIEW.
- C. SELECT VIEW.
- D. INSERT VIEW. Discuss
- 9. The DROP TABLE statement:
Options- A. deletes the table structure only.
- B. deletes the table structure along with the table data.
- C. works whether or not referential integrity constraints would be violated.
- D. is not an SQL statement. Discuss
- 10. A ________ is a program that performs some common action on database data and that is stored in the database.
Options- A. trigger
- B. stored procedure
- C. pseudofile
- D. None of the above is correct. Discuss
Data Modeling with ER Model problems
Search Results
Correct Answer: child
Correct Answer: Entity
Correct Answer: Minimum cardinality
Correct Answer: Relationships
Correct Answer: Subtype entity
Correct Answer: ID-dependent entity
Correct Answer: Increased network traffic
Correct Answer: CREATE VIEW.
Correct Answer: deletes the table structure along with the table data.
Correct Answer: stored procedure
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.