CIW 1D0-541 Online Practice Questions and Exam Preparation

CIW 1D0-541 Online Questions & Answers

• Question 21:

  Consider the relation shown in the exhibit. Which of the following SQL statements would return a relation that excludes all customers with a Satisfaction_Rate of less than or equal to 80 unless the Sales_Office is located in Atlanta?

  

  A. SELECT * FROM Customers WHERE Satisfaction_Rate > 80 OR Sales_Office = Atlanta;
  B. SELECT * FROM Customers WHERE Satisfaction_Rate
  C. SELECT * FROM Customers WHERE Satisfaction_Rate >= 80;
  D. SELECT * FROM Customers WHERE Satisfaction_Rate >= 80 AND NOT Sales_Office = Atlanta;
  A. SELECT * FROM Customers WHERE Satisfaction_Rate > 80 OR Sales_Office = Atlanta;

• Question 22:

  In which situation would the DBMS use a serial schedule to execute the transactions?

  A. Concurrent transactions read data from the same data structure.
  B. Concurrent transactions write data to different data structures.
  C. Concurrent transactions read or write the same data structure.
  D. Concurrent transactions read or write from different data structures.
  C. Concurrent transactions read or write the same data structure.

• Question 23:

  Which term describes the rejoining of relations that have been decomposed?

  A. Normalization
  B. Denormalization
  C. Referential integrity
  D. Domain constraints
  B. Denormalization

• Question 24:

  Which term describes the management of simultaneous transactions to prevent conflicts?

  A. Parallelism
  B. Serialization
  C. Database control
  D. Concurrency control
  D. Concurrency control

• Question 25:

  A theta-join can be viewed as:

  A. the intersection of two relations.
  B. a Cartesian product of two relations.
  C. a restricted Cartesian product of two relations.
  D. the Cartesian product of two union-compatible relations.
  C. a restricted Cartesian product of two relations.

• Question 26:

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

  Which term best describes one or more database operations that are executed as a single unit?

  A. Update
  B. Transaction
  C. Procedure
  D. Singleton
  B. Transaction

• Question 28:

  Consider the following relational algebraic expression as well as the Dept1_Parts and Dept2_Parts relations shown in the exhibit:

  

  Which of the following relations would result from the given relational algebraic expression?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  C. Option C

• Question 29:

  Consider the relations shown in the exhibit. Due to restructuring, the sales department has been eliminated and the employees working in that department have been dismissed. All ID information is stored as integers. Which SQL statement would be used to return a relation with all information for the employees who have been dismissed?

  

  A. SELECT * FROM Employee;
  B. SELECT ID, Last_Name FROM Employee; WHERE ID = 0004;
  C. SELECT * FROM Employee WHERE Dept_ID = 022;
  D. SELECT * FROM Employee WHERE Dept_ID = 022;
  C. SELECT * FROM Employee WHERE Dept_ID = 022;

• Question 30:

  Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?

  

  A. SELECT * FROM Customers WHERE Satisfaction_Rate = 90;
  B. SELECT * FROM Customers WHERE Satisfaction_Rate IN (80 AND 90);
  C. SELECT * FROM Customers WHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate
  D. SELECT * FROM Customers WHERE Satisfaction_Rate BETWEEN (80, 90);
  C. SELECT * FROM Customers WHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate