Free CIW 1D0-541 Exam Dumps Questions & Answers

Consider the Information Engineering diagram in the exhibit showing the relations BUILDING and RESIDENT. What is the relationship between BUILDING and RESIDENT?

A 1:1

• A.  N:1
• B.  M:N
• C.  1:N

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

• A.  1:1
• B.  1:n
• C.  m:n
• D.  m:m

Consider the relation shown in the exhibit. Which of the following SQL statements would return a relation that excludes all customers with a Satisfaction_Rate of less than or equal to 80 unless the Sales_Office is located in Atlanta?

• A.  SELECT * FROM Customers WHERE Satisfaction_Rate >= 80 AND NOT Sales Office = Atlanta
• B.  SELECT * FROM Customers WHERE Satisfaction_Rate >= 80;
• C.  SELECT * FROM Customers WHERE Satisfaction_Rate > 80 OR Sales_Office = Atlanta
• D.  SELECT * FROM Customers WHERE Satisfaction_Rate <= 80 AND Sales_Office = Atlanta

Consider the following table as well as the Dept1_Parts and Dept2_Parts relations shown in the exhibit: Which of the following relational algebraic expressions would result in the given table?

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

Using the Customer and Sales_Rep relations shown in the exhibit, you must determine a relational algebraic expression that will result in the following relation: Which of the following relational algebraic expressions would result in this relation? Using the Customer and Sales_Rep relations shown in the exhibit, you must determine a relational algebraic expression that will result in the following relation: Which of the following relational algebraic expressions would result in this relation?

• A.  Customer X Sales_Rep
• B.  Customer.Sales_Rep_No = Sales.sales_Rep_No (Customer X Sales_Rep)
• C.  (Customer X Sales_Rep) ? Sales_Rep.Sales_Rep_No = Customer.Sales_Rep_No
• D.  (Sales_Rep.Sales_Rep_No = Customer.Sales_Rep_No (Sales_Rep X Customer))