1D0-541: CIW Database Design Specialist | Practice Test / Quiz / MCQs

Home > Certified Internet Web Professional > Quizzes > 1D0-541: CIW Database Design Specialist

1D0-541: CIW Database Design Specialist

Fast practice, instant feedback. Timer auto-submits when time’s up.

Avg score: 55% • Most missed: “Your enterprise is involved in planning a database project. The exhibit shows th…”

1D0-541: CIW Database Design Specialist

Time left 00:00

1. The exhibit shows a relation for a company projects. Which candidate key(s) would best serve as the primary key for this relation?

S_Date and E_Dateltem_Num and E_DateProj_ID and Item_NumProjJD

2. The exhibit shows a table called Housing Relation that relates a unique student identification number with a dormitory building and a room fee for that building. Each building charges only one fee and a student can live in only one building. The key for the Housing Relation is Student_ID. This table is in which normal form?

1NF, 2NF, 3NF and BCNF 1NF, 2NF and 3NF1NF and 2NF1NF

3. The exhibit shows a table called Activity Relation that relates a unique student identification number with a sports activity and a fee for participating in that activity. A student can participate in only one activity. The key for the relation is Student_ID. What consequence would occur if the tuple for Student_ID 1001 were removed?

Both an insertion anomaly and a deletion anomaly would occur.A deletion anomaly would occur.An insertion anomaly would occur.An update anomaly would occur.

4. Which characteristic is an advantage of a database management system?

A standard method can be used to access the database.Data files are owned and maintained by the users.Data is decentralized.Database administration is simplified.

5. Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?

A recursive relationshipA many-to-many relationshipA one-to-many relationshipA one-to-one relationship

6. NULL) Primary Key Class_Num Consider the Information Engineering diagram shown in the exhibit. Which DBDL definition best describes this diagram?

BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key Building_ID RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key R_IDBUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key Building_ID RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key R_ID Foreign Key Building_ID references BUILDING(Building_ID)BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key BUILDING Foreign Key BUILDING(Building_ID) references RESIDENT(Building_ID) RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key RESIDENTBUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key BUILDING RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key RESIDENT

7. Which of the following describes two desirable characteristics of a primary key?

A primary key should be a value that is not null and will never change.A primary key should consist of meaningful data and a value that can be changed if needed.A primary key should be a value that may be null and may change over time.A primary key should not consist of meaningful data and a value that can be changed if needed.

8. Which term best defines a database system in which data records are stored in one or more files with no structured relationship?

Distributed databaseFlat-file databaseRelational databaseObject-oriented database

9. Consider the Recreation relation shown in the exhibit. You need to apply a SQL statement to the Recreation relation that will return the following data: Which SQL statement applied to the Recreation relation will return this data?

SELECT Activity FROM Recreation WHERE NOT LIKE Activity;SELECT Activity FROM Recreation;SELECT Activity FROM Recreation WHERE DISTINCT Activity;SELECT DISTINCT Activity FROM Recreation;

10. Which term describes an attribute or combination of attributes that uniquely identifies a row in a relation?

Attribute groupDomainPrimary keyEntity

11. Which of the following occurs in a relation when records are added or removed?

The degree of the relation is fixed but the cardinality varies. The number of domains changes.The attributes in the domain change.The cardinality of the relation is fixed but the degree varies.

12. Which of the following ACID properties requires that a transaction be executed in its entirety or not all?

AtomicityConsistencyDurabilityIsolation

13. Which relational algebraic operation is used to select specific columns (attributes) from a relation?

IntersectionProjectionDifferenceUnion

14. Which three pieces of information did E.F. Codd describe as necessary to retrieve a data value from a relational database?

Attribute, domain, and tupleTable name, primary key, and entityEntity, relation name, and domainAttribute, relation name, and primary key

15. What is a virtual table?

A virtual table is a relation stored in the database; it is used when multiple users access the same relation in a database.A virtual table is a relation that consists of primary and foreign keys for a particular set of relations in a database.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.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.

16. A theta-join can be viewed as:

a Cartesian product of two relations.the Cartesian product of two union-compatible relations.a restricted Cartesian product of two relations.the intersection of two relations.

17. Which of the following is a characteristic of the three-tier database architecture?

A thick client is used to perform business application logic functions locally. The application logic is centralized on a dedicated server.Database application logic and database functionality are integrated and reside on a common server.A Web browser is used as the application server.

18. Consider the Orders relation shown in the exhibit. Which of the following SQL statements would replace the value in the Sales_Rep_No column with 110 everywhere that Sales_Rep_No 108 is listed?

UPDATE Sales_Rep_No IN Orders SET(Sales_Rep_No = 110 WHERE Sales_Rep_No = 108);UPDATE Orders WHERE Sales_Rep_No = 108 SET Sales_Rep_No = 110; UPDATE Orders SET Sales_Rep_No = 110 WHERE Sales_Rep_No = 108;UPDATE Orders SET Sales_Rep_No = 110;

19. The exhibit shows a table called Recreation Relation that relates a unique student identification number and a sports activity with a fee for participating in that activity. The Student_ID and Activity columns in the table are used together as a composite key. Which statement about the relation is correct?

Activity_Fee is a determinant of Activity.Activity_Fee is partially dependent on the key.The table contains a transitive dependency.Activity_Fee is a determinant of Activity and Student_ID.

20. With regard to databases, what is normalization?

The process of duplicating data to reduce the number of tablesThe process of reducing the cardinality of a relationThe process of organizing and refining relationsThe process of limiting data stored in a table to a specific range of values

21. What is the highest normal form of the relation(s) shown in the exhibit?

Second normal formFirst normal formThird normal formNo normal form

22. Consider the Information Engineering diagram in the exhibit showing a conceptual data model of the relations BUILDING and RESIDENT. What is the next step in refining the data model?

Create a logical data model.Resolve many-to-many relationships.Identify and resolve complex relationships.Create intermediate entities.

23. Your enterprise is involved in planning a database project. The exhibit shows the result of one phase of the database design life cycle. Which term best describes the diagram shown in the exhibit?

Database requirements modelERD modelInformation Engineering (IE) data modelCorporate data model

24. Which concurrency control method should be used only when conflicts between transactions rarely occur?

Time stampsLockingSerializationOptimistic

25. Which area of database security involves maintaining access to enterprise data?

ConfidentialityTheftAvailabilityPrivacy

Welcome to Fatskills

Join 4M+ learners. Unlock unlimited quizzes, wrong-answer tracking, flashcards + reminders, study guides, and 1-on-1 challenges.

Create a free account Sign in

900+ exams • Millions of questions • No spam

❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈 Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.

About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.

25 Questions

❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |

Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.

25 Questions

❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know? Privacy | Terms |

Without work one finishes nothing. - Ralph Waldo Emerson© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.

About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |

Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com