Free CIW 1D0-541 Exam Dumps Questions & Answers

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.  ERD model
• C.  Database requirements model
• D.  Information Engineering (IE) data model

Consider the following relational algebraic expression: Which of the following SQL statements is equivalent to this relational algebraic expression?

• A.  SELECT * FROM Customers, Employees WHERE Customers.Sales_Rep_No = Employees.Sales_Rep_No;
• B.  SELECTCust_No, Cust_Name, Emp_Name, Emp_Loc FROM Customers, Employees WHERE Employees.Sales_Rep_No = Customers.Sales_Rep_No;
• C.  SELECT * FROM Customers, Employees WHERE Sales_Rep_No = Cust_No;
• D.  SELECTCust_No, Cust_Name, Emp_Name, Emp_Loc FROM Customers, Employees WHERE Customers.Sales_Rep_No = Employees.Sales_Rep_No;

Which security technique limits access by unauthorized users to parts of an enterprise database?

• A.  Views
• B.  Concurrency
• C.  Locking
• D.  Integrity controls

You enterprise must decide whether to use a database management system. Which of the following lists four advantages of using a DBMS?

• A.  Management of data redundancy, increased data integrity, increased data dependence, and increased application program flexibility.
• B.  Increased data access, increased data backup and recovery, data sharing, and consistency of data.
• C.  Increased datasecriry, increased data integrity, increased data independence, and decreased data separation.
• D.  Consistency of data, adherence to standards, managed concurrency, and increased software complexity.

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