CIW 1D0-541 - CIW v5 Database Design Specialist Exam

Question #1 (Topic: Single Topic)
With regard to databases, what is normalization?
A. The process of reducing the cardinality of a relation B. The process of organizing and refining relations C. The process of duplicating data to reduce the number of tables D. The process of limiting data stored in a table to a specific range of values
Answer: B
Question #2 (Topic: Single Topic)
Which three pieces of information did E.F. Codd describe as necessary to retrieve a data value from a relational database?
A. Attribute, domain, and tuple B. Entity, relation name, and domain C. Table name, primary key, and entity D. Attribute, relation name, and primary key
Answer: D
Question #3 (Topic: Single Topic)
What is a virtual table?
A. A virtual table is a relation created as the result of data manipulation; it exists only in computer memory, and is not a permanent part of the database. B. A virtual table is a relation stored in the database; it is used when multiple users access the same relation in a database. C. A virtual table is a relation derived from the database data dictionary; it contains metadata about a base relation. A virtual table is a relation derived from the database? data dictionary; it contains metadata about a base relation. D. A virtual table is a relation that consists of primary and foreign keys for a particular set of relations in a database.
Answer: A
Question #4 (Topic: Single Topic)
Your enterprise has reached the conceptual design phase for a database project. What is the desired goal at the end of this design phase?
A. A set of normalized relations B. A reviewed entity-relationship (ER) model C. An entity-relationship (ER) model with no redundant data D. A set of denormalized relations
Answer: B
Question #5 (Topic: Single Topic)
In which phase of database design do you identify entities, attribute domains, and relationships?
A. Logical B. Physical C. Application D. Conceptual
Answer: D
Download Exam
Page: 1 / 25
Total 124 questions