Free CIW 1D0-541 Exam Dumps Questions & Answers

Consider the symbols shown in the exhibit. Which of the following correctly identifies these symbols when used in an entity-relationship (ER) diagram?

• A.  1 = relationship, 2 = entity, 3 = attribute
• B.  1 = entity, 2 = relationship, 3 = attribute
• C.  1 = relationship, 2 = attribute, 3 = entity
• D.  1 = attribute, 2 = entity, 3 = relationship

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

• A.  Durability
• B.  Consistency
• C.  Atomicity
• D.  Isolation

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?

• A.  Corporate data model
• B.  Information Engineering (IE) data model
• C.  ERD model
• D.  Database requirements model

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

• A.  BUILDING(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)
• B.  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 RESIDENT
• C.  BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key BUILDING RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key RESIDENT
• D.  BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key Building_ID RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key R_ID

Consider the Project relation shown in the exhibit as well as the following SQL statement: DELETE FROM Project WHERE Cust_Name = Acme; Which of the following tables shows the Project relation after execution of this SQL statement?

• A.  B
• B.  A
• C.  D
• D.  C