CIW CIW Certifications 1D0-541 Questions & Answers

• Question 51:

  Consider the relation shown in the exhibit. Which of the following SQL statements would properly remove all tuples for New York customers?

  

  A. DELETE * FROM Customers WHERE Sales_Office = New York;

  B. DELETE FROM Customers WHERE Sales_Office = New York;

  C. DELETE * FROM Customer WHERE Sales_Office <> New York;

  D. DELETE FROM Customers WHERE Sales_Office NOT LIKE New York;

  Correct Answer: B

• Question 52:

  Your enterprise has created a database and database application. The testing phase for the project has started. Which of the following best describes white-box testing of the projects software?

  A. The database designer tests the software because he or she is able to make necessary changes to the underlying code for the software.

  B. A user who has no knowledge of the softwares underlying code tests the software.

  C. Someone other than the database designer tests the software. This person has no access to the underlying code and attempts to use the software only in ways not considered by the software designers.

  D. A person tests the software and submits suggestions to the software's underlying code. This person is someone other than the database designer, but has access to the softwares underlying code.

  Correct Answer: D

• Question 53:

  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

  Correct Answer: D

• Question 54:

  Consider the entity-relationship (ER) diagram shown in the exhibit. What do the characters at the ends of the connecting line indicate?

  

  A. Degree of a relation

  B. Cardinality of a relation

  C. Primary key of a relation

  D. Determinant of a relation

  Correct Answer: B

• Question 55:

  What is the most important service provided by a database management system?

  A. Provides support for a data manipulation language

  B. Allows users to store data in a distributed data repository

  C. Provides support for data formatting language commands

  D. Translates procedural commands into non-procedural commands

  Correct Answer: A

• Question 56:

  Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create an intersection of the two relations with the widest variety of Structured Query Language dialects?

  

  A. SELECT * FROM Dept1_Parts AND (SELECT * FROM Dept2_Parts);

  B. SELECT * FROM Dept1_Parts INTERSECTION (SELECT * FROM Dept2_Parts);

  C. SELECT * FROM Dept1_Parts WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;

  D. SELECT * FROM Dept1_Parts WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;

  Correct Answer: D

• Question 57:

  Your 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 complexity

  B. Consistency of data, adherence to standards, managed concurrency, and increased software complexity

  C. Increased data access, increased data backup and recovery, data sharing, and consistency of data

  D. Increased data security, increased data integrity, increased data independence, and decentralization of data

  Correct Answer: C

• Question 58:

  Consider the Information Engineering diagram shown in the exhibit for a building management company. Referential integrity must be maintained such that a building cannot be deleted when it has residents. Building_ID, R_ID, Room_Count and Room_Num are integer numbers, whereas Bldg_Name, Location and Res_Name are all represented by variable-length strings with a maximum of 20 characters. Which SQL statement best implements the relations shown in this diagram?

  

  A. CREATE TABLE BUILDING ( Building_ID INTEGER NOT NULL PRIMARY KEY, Bldg_Name VARCHAR (20), Location VARCHAR (20), Room_Count INTEGER ); CREATE TABLE RESIDENT ( R_ID NOT NULL PRIMARY KEY, Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL, FOREIGN KEY Building_ID REFERENCES RESIDENT (Building_ID) ON DELETE NO CHECK);

  B. CREATE TABLE BUILDING ( Building_ID INTEGER NOT NULL PRIMARY KEY, Bldg_Name VARCHAR (20), Location VARCHAR (20), Room_Count INTEGER ); CREATE TABLE RESIDENT ( R_ID NOT NULL PRIMARY KEY, Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID) ON DELETE NO CHECK ON UPDATE CASCADE);

  C. CREATE TABLE BUILDING ( Building_ID INTEGER NOT NULL PRIMARY KEY, Bldg_Name VARCHAR (20), Location VARCHAR (20), Room_Count INTEGER ); CREATE TABLE RESIDENT ( R_ID NOT NULL PRIMARY KEY, Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID) ON DELETE NO CHECK ON UPDATE CASCADE);

  D. CREATE TABLE BUILDING ( Building_ID INTEGER NOT NULL PRIMARY KEY, Bldg_Name VARCHAR (20), Location VARCHAR (20), Room_Count INTEGER ); CREATE TABLE RESIDENT ( R_ID NOT NULL PRIMARY KEY, Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID) ON DELETE NO CHECK ON UPDATE CASCADE);

  Correct Answer: C

• Question 59:

  Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?

  

  A. SELECT * FROM Customers WHERE Satisfaction_Rate <= 80 OR Satisfaction_Rate >= 90;

  B. SELECT * FROM Customers WHERE Satisfaction_Rate IN (80 AND 90);

  C. SELECT * FROM Customers WHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate <= 89;

  D. SELECT * FROM Customers WHERE Satisfaction_Rate BETWEEN (80, 90);

  Correct Answer: C

• Question 60:

  For the Employee relation shown in the exhibit, which set of column values holds the complete tuple for the employee named James Smith?

  

  A. 0002, James, Smith

  B. 0002, James, Smith, 10-25-76

  C. First_Name, James, Last_Name, Smith

  D. Emp_ID, 0002, First_Name, James, Last_Name, Smith

  Correct Answer: B