CIW 1D0-541 Online Practice Questions and Exam Preparation

CIW 1D0-541 Online Questions & Answers

• Question 101:

  Which three pieces of information did E. F. Codd describe as necessary to retrieve a data value from a relational database?

  A. Attribute, domain, and tuple
  B. Entity, relation name, and domain
  C. Table name, primary key, and entity
  D. Attribute, relation name, and primary key
  D. Attribute, relation name, and primary key

• Question 102:

  In a relational database, which term describes a single table consisting of rows and columns?

  A. Entity
  B. Matrix
  C. Relation
  D. Data dictionary
  C. Relation

• Question 103:

  A foreign key maps to a:

  A. prime key.
  B. indirect key.
  C. parent key.
  D. composite key.
  C. parent key.

• Question 104:

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

  

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

• Question 105:

  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.
  D. Cust_Name is functionally dependent on Cust_ID.

• Question 106:

  Which mechanism provides database users with controlled access to the database through the use of virtual tables?

  A. View
  B. Data dictionary
  C. Database control language
  D. Database management system
  A. View

• Question 107:

  Your database administrator has disallowed a group of users from making alterations to the Employees table in your corporate database. The users, known as Group_2, previously had full privileges with the Employees table. Which of the following SQL statements properly removes any alteration privileges from Group_2?

  A. REVOKE INSERT, UPDATE, DELETE ON Employees FROM Group_2;
  B. REVOKE UPDATE FOR Employees FROM Group_2;
  C. REVOKE INSERT, UPDATE, DELETE ON Employees TO Group_2;
  D. REVOKE UPDATE, DELETE FOR Employees FROM Group_2;
  A. REVOKE INSERT, UPDATE, DELETE ON Employees FROM Group_2;

• Question 108:

  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
  C. Referential integrity

• Question 109:

  Which of the following ACID properties requires that a transaction be executed in its entirety or not all?

  A. Durability
  B. Consistency
  C. Isolation
  D. Atomicity
  D. Atomicity

• Question 110:

  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.