CIW 1D0-541 Online Practice Questions and Exam Preparation

CIW 1D0-541 Online Questions & Answers

• Question 41:

  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.
  B. Create a logical data model.

• Question 42:

  Which subset of Structured Query Language (SQL) is used to create and name database entities?

  A. Data Control Language
  B. Database Entity Language
  C. Data Definition Language
  D. Data Manipulation Language
  C. Data Definition Language

• Question 43:

  What is the highest normal form of the relation(s) shown in the exhibit?

  

  A. Third normal form
  B. Second normal form
  C. Boyce-Codd normal form
  D. First normal form
  D. First normal form

• Question 44:

  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
  B. 0002, James, Smith, 10-25-76

• Question 45:

  What is the highest normal form of the relation(s) shown in the exhibit?

  

  A. Boyce-Codd normal form
  B. First normal form
  C. Second normal form
  D. Third normal form
  C. Second normal form

• Question 46:

  Consider the table for an employee database shown in the exhibit. What is the cardinality of the table?

  

  A. 5
  B. 20
  C. 4
  D. 25
  C. 4

• Question 47:

  Consider the symbols shown in the exhibit. Which of the following correctly identifies these symbols when used in an entity-relationship (ER) diagram?

  

  A. 1 = attribute, 2 = entity, 3 = relationship
  B. 1 = entity, 2 = relationship, 3 = attribute
  C. 1 = relationship, 2 = entity, 3 = attribute
  D. 1 = relationship, 2 = attribute, 3 = entity
  C. 1 = relationship, 2 = entity, 3 = attribute

• Question 48:

  Your enterprise is creating a relation (shown in the exhibit) that tracks parts and suppliers. Which situation would occur if new supplier information were entered in the relation before any information about specific parts?

  

  A. An update anomaly and an insertion anomaly would occur.
  B. An insertion anomaly would occur.
  C. A deletion anomaly would occur.
  D. A deletion anomaly and an update anomaly would occur.
  B. An insertion anomaly would occur.

• Question 49:

  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
  A. Provides support for a data manipulation language

• Question 50:

  What is a candidate key?

  A. The primary key for an entity
  B. The key that identifies every instance of an entity
  C. Multiple primary keys that are joined together to form a composite key
  D. A key that may be used to form the primary key
  D. A key that may be used to form the primary key