CIW 1D0-541 Online Practice Questions and Exam Preparation

CIW 1D0-541 Online Questions & Answers

• Question 91:

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

  

  A. No normal form
  B. Second normal form
  C. First normal form
  D. Third normal form
  D. Third normal form

• Question 92:

  The exhibit shows a relation for a companys projects. Which candidate key(s) would best serve as the primary key for this relation?

  

  A. S_Date and E_Date
  B. Proj_ID
  C. Item_Num and E_Date
  D. Proj_ID and Item_Num
  D. Proj_ID and Item_Num

• Question 93:

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

  

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

• Question 94:

  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.
  B. A primary key should be a value that is not null and will never change.

• Question 95:

  Which type of relational integrity is violated if a primary key in a database has a null value?

  A. Entity integrity
  B. Domain integrity
  C. Domain constraints
  D. Referential integrity
  A. Entity integrity

• Question 96:

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

  

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

• Question 97:

  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.
  D. A composite key is a primary or foreign key that consists of two or more attributes of a relation.

• Question 98:

  Which of the following best describes the ON DELETE CASCADE referential integrity constraint?

  A. If a parent key is deleted, any child keys referenced by the parent key are automatically deleted.
  B. If any child key references a parent key, the record containing the parent key cannot be deleted.
  C. If a parent key is deleted, all child keys are automatically set to a specified value.
  D. If a parent key is deleted, no test is made for referential integrity.
  A. If a parent key is deleted, any child keys referenced by the parent key are automatically deleted.

• Question 99:

  Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return the Registration2 relation from the Registration relation?

  

  A. SELECT Course_Code FROM Registration;
  B. SELECT * FROM Registration WHERE Registration_ID = 1003 AND Registration_ID = 1005;
  C. SELECT * FROM Registration WHERE Course_Code = 'A4343';
  D. SELECT Registration_ID, Student_ID, First_Name, Last_Name FROM Registration WHERE Course_Code = 'A4343';
  C. SELECT * FROM Registration WHERE Course_Code = 'A4343';

• Question 100:

  Consider the Recreation relation shown in the exhibit. You need to apply a SQL statement to the Recreation relation that will return the following data:

  

  Which SQL statement applied to the Recreation relation will return this data?

  A. SELECT Activity FROM Recreation;
  B. SELECT DISTINCT Activity FROM Recreation;
  C. SELECT Activity FROM Recreation WHERE NOT LIKE Activity;
  D. SELECT Activity FROM Recreation WHERE DISTINCT Activity;
  B. SELECT DISTINCT Activity FROM Recreation;