CIW 1D0-541 Online Practice Questions and Exam Preparation

CIW 1D0-541 Online Questions & Answers

• Question 61:

  Consider the Recreation relation in the exhibit. A data operation that changes one of the tuples for Student_ID 1003 must be performed. It is necessary to change one of the activities from swimming to tennis. The Student_ID and Activity attributes make up the primary key for the Recreation relation. All related information must be altered, as well. Which SQL statement or statements would best accomplish this?

  

  A. UPDATE Recreation SET Activity, Activity_Fee ('Tennis', 100) WHERE Student_ID = 1003;
  B. UPDATE TABLE Recreation SET ACTIVITY = 'Tennis', Activity_Fee = 100 WHERE Student_ID = 1003 AND Activity = Swimming;
  C. UPDATE Recreation SET Activity = 'Tennis', Activity_Fee = 100 WHERE Student_ID = 1003 AND Activity = 'Swimming';
  D. DELETE Activity FROM Recreation WHERE Student_ID = 1003; INSERT INTO Recreation VALUES (1003, 'Tennis', 100);
  C. UPDATE Recreation SET Activity = 'Tennis', Activity_Fee = 100 WHERE Student_ID = 1003 AND Activity = 'Swimming';

• Question 62:

  The exhibit shows a table called Recreation Relation that relates a unique student identification number and a sports activity with a fee for participating in that activity. The Student_ID and Activity columns in the table are used together as a composite key. Which statement about the relation is correct?

  

  A. Activity_Fee is a determinant of Activity.
  B. Activity_Fee is partially dependent on the primary key.
  C. The table contains a transitive dependency.
  D. Activity_Fee is a determinant of Activity and Student_ID.
  B. Activity_Fee is partially dependent on the primary key.

• Question 63:

  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).
  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).

• Question 64:

  Which component in the three-tier database architecture handles the data-processing and business logic?

  A. Thin client
  B. Fat client
  C. Database server
  D. Application server
  D. Application server

• Question 65:

  Which term describes an attribute or combination of attributes that uniquely identifies a row in a relation?

  A. Entity
  B. Domain
  C. Primary key
  D. Attribute group
  C. Primary key

• Question 66:

  Consider the entity-relation (ER) diagram shown in the exhibit. When the logical database design phase is completed, which of the following is a valid DBDL description of the base relations for the ER diagram?

  

  A. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num
  B. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num Foreign Key Class_Num References STUDENT
  C. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number STU_CLASS( Student_Number: integer NOT NULL Class_Num: integer NOT NULL) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num
  D. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number STU_CLASS( Student_Number: integer NOT NULL Class_Num: integer NOT NULL) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num
  D. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number STU_CLASS( Student_Number: integer NOT NULL Class_Num: integer NOT NULL) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num

• Question 67:

  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;
  B. DELETE FROM Customers WHERE Sales_Office = New York;

• Question 68:

  What is a relational database domain?

  A. A group of attributes
  B. A set of permissible tuple values
  C. A collection of related data items
  D. A set of permissible attribute values
  D. A set of permissible attribute values

• Question 69:

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

• Question 70:

  Which type of dependency occurs when one attribute of a composite primary key is removed and the dependency still exists?

  A. 11
  B. Transitive
  C. Functional
  D. Partial functional
  D. Partial functional