CIW CIW Certification 1D0-541 Questions & Answers

• Question 11:

  A large enterprise uses a two-tier database architecture and runs complex database processing on the client. Which term best describes the client in this system?

  A. Fat client

  B. Thin client

  C. Terminal client

  D. Enterprise client

  Correct Answer: A

• Question 12:

  Consider the Stu_Act and Act_Fee tables shown in the exhibit. Which relational algebraic operation would yield the Activity Relation table in the exhibit?

  

  A. Union

  B. Intersection

  C. Natural join

  D. Cartesian product

  Correct Answer: C

• Question 13:

  A relation for a construction company is shown in the exhibit. Which of the following best defines the relationship between Cust_ID and Cust_Name?

  

  A. Cust_Name is the determinant.

  B. Cust_Name is transitively dependent on Cust_ID.

  C. Cust_ID is transitively dependent on Cust_Name.

  D. Cust_Name is functionally dependent on Cust_ID.

  Correct Answer: D

• Question 14:

  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. C. D.

  Correct Answer: A

• Question 15:

  Which of the following best describes a composite key?

  A. A composite key is a primary key and foreign key that consists of the first two attributes of a relation.

  B. A composite key is a primary or foreign key defined by its parent key attributes.

  C. A composite key is a foreign key that consists of the same attributes as the primary key from a related table.

  D. A composite key is a primary or foreign key that consists of two or more attributes of a relation.

  Correct Answer: D

• Question 16:

  Consider the following relation definition: STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number HOUSING( Housing_ID: integer NOT NULL Student_Number: integer NOT NULL Building: variable length character string length 25 NOT NULL) Primary Key Housing_ID Foreign Key Student_Number References STUDENT(Student_Number) ON DELETE NO CHECK

  ON UPDATE

  Which integrity constraint is violated in this relation definition?

  A. Entity integrity

  B. Domain constraint

  C. Referential integrity

  D. Enterprise constraint

  Correct Answer: C

• Question 17:

  Which characteristic is an advantage of a database management system?

  A. Data files are owned and maintained by the users.

  B. Database administration is simplified.

  C. A standard method can be used to access the database.

  D. Data is decentralized.

  Correct Answer: C

• Question 18:

  Consider the following relation definitions: STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 ) Primary Key Student_Number HOUSING( Housing_ID: integer NOT NULL Student_Number: integer NOT NULL Building: variable length character string length 25 ) Primary Key Housing_ID Foreign Key Student_Number References STUDENT(Student_Number) ON DELETE NO ACTION ON UPDATE CASCADE

  What are the referential constraints for the relations defined in these relation definitions?

  A. There is no relationship between changes in STUDENT(Student_Number) and HOUSING (Student_Number).

  B. When STUDENT(Student_Number) is changed or deleted, this modification or deletion will automatically be reflected in HOUSING(Student_Number).

  C. Modifications to HOUSING(Student_Number) are automatically reflected in changes to STUDENT (Student_Number), but deletions are not permitted.

  D. Modifications to STUDENT(Student_Number) are automatically reflected in changes to HOUSING (Student_Number). For a deletion to occur from STUDENT(Student_Number), it must first occur in HOUSING(Student_Number).

  Correct Answer: D

• Question 19:

  Which of the following best describes the information contained in the data dictionary (or system catalog)?

  A. Metadata

  B. Data model

  C. Table data

  D. Metafile

  Correct Answer: A

• Question 20:

  Consider the following SQL statement and the Orders relation shown in the exhibit:

  

  What is the output of this SQL statement?

  

  A. B. C. D.

  Correct Answer: C