CIW CIW Certification 1D0-541 Questions & Answers

• Question 21:

  Consider the Information Engineering diagram in the exhibit showing a conceptual data model of the relations BUILDING and RESIDENT. What is the next step in refining the data model?

  

  A. Create intermediate entities.

  B. Create a logical data model.

  C. Resolve many-to-many relationahips.

  D. Identify and resolve complex relationships.

  Correct Answer: B

• Question 22:

  Which process is used to prevent the current database operation from reading or writing a data item while that data item is being accessed by another operation?

  A. Lock

  B. Deadlock

  C. Timestamp

  D. Batch

  Correct Answer: A

• Question 23:

  Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return all tuples that have course codes beginning with the letter M?

  

  A. SELECT * FROM Registration WHERE Course_Code = M#;

  B. SELECT * FROM Registration WHERE Course_Code LIKE M_;

  C. SELECT * FROM Registration WHERE Course_Code LIKE M%;

  D. SELECT * FROM Registration WHERE Course_Code = M%;

  Correct Answer: C

• Question 24:

  Which of the following describes two desirable characteristics of a primary key?

  A. A primary key should be a value that may be null and may change over time.

  B. A primary key should be a value that is not null and will never change.

  C. A primary key should consist of meaningful data and a value that can be changed if needed.

  D. A primary key should not consist of meaningful data and a value that can be changed if needed.

  Correct Answer: B

• Question 25:

  Which of the following occurs in a relation when records are added or removed?

  A. The number of domains changes.

  B. The attributes in the table change.

  C. The cardinality of the relation is fixed but the degree varies.

  D. The degree of the relation is fixed but the cardinality varies.

  Correct Answer: D

• Question 26:

  The exhibit shows a table called Student Relation that tracks all information related to a students courses, professors and sites. What would be the consequence of removing all records for a student with the ID 1311?

  

  A. Only an update anomaly would occur.

  B. An insertion anomaly would occur.

  C. A deletion anomaly would occur.

  D. An update anomaly and a deletion anomaly would occur.

  Correct Answer: C

• Question 27:

  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: D

• Question 28:

  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. Information Engineering (IE) data model

  B. Corporate data model

  C. Database requirements model

  D. Entity Relation Data (ERD) model

  Correct Answer: B

• Question 29:

  Consider the following four database design activities:

  1 - Design user views.

  2 - Select a DBMS.

  3 - Apply normalization.

  4 - Determine entities.

  Which choice shows the correct ordering of these activities, from first to last, by assigned numbers?

  A. 1, 2, 3, 4

  B. 3, 4, 1, 2

  C. 4, 1, 3, 2

  D. 4, 2, 3, 1

  Correct Answer: D

• Question 30:

  Which pair of relational algebraic operations requires union compatibility?

  A. Projection and Cartesian product

  B. Selection and projection

  C. Intersection and difference

  D. Cartesian product and intersection

  Correct Answer: C