CIW CIW Certification 1D0-541 Questions & Answers

• Question 41:

  Consider the Orders relation shown in the exhibit. Which of the following SQL statements would replace the value in the Sales_Rep_No column with 110 everywhere that Sales_Rep_No 108 is listed?

  

  A. UPDATE Sales_Rep_No IN Orders SET(Sales_Rep_No = 110 WHERE Sales_Rep_No = 108);

  B. UPDATE Orders SET Sales_Rep_No = 110 WHERE Sales_Rep_No = 108;

  C. UPDATE Orders SET Sales_Rep_No = 110;

  D. UPDATE Orders WHERE Sales_Rep_No = 108 SET Sales_Rep_No = 110;

  Correct Answer: B

• Question 42:

  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

  Correct Answer: B

• Question 43:

  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

  Correct Answer: A

• Question 44:

  The database manager wants to give Rubio and Doe the ability to modify the Project Relation shown in the exhibit. A temporary employee named Temp needs to access the data in the database to generate reports. Which group of SQL statements will perform this task?

  

  A. GRANT UPDATE ON Project TO Rubio, Doe; GRANT SELECT ON Project TO Temp;

  B. GRANT ALL PRIVILEGES ON Project TO Rubio, Doe; GRANT UPDATE ON Project TO Temp;

  C. GRANT SELECT ON Project WHERE Manager = 'Rubio'; GRANT SELECT ON Project WHERE Manager = 'Doe';

  D. GRANT UPDATE ON Project WHERE Manager = 'Rubio'; GRANT UPDATE ON Project WHERE Manager = 'Doe'; GRANT SELECT ON Project TO Temp;

  Correct Answer: A

• Question 45:

  Consider the following SQL statement and the Orders relation shown in the exhibit:

  

  How many records should be returned?

  A. Two records

  B. Three records

  C. Four records

  D. Five records

  Correct Answer: C

• Question 46:

  Consider the Orders relation shown in the exhibit. Which of the following SQL statements would return all complete tuples for order dates in 2002, arranged by amount from lowest to highest?

  

  A. SELECT * FROM Orders WHERE Order_Date LIKE _02 ORDER BY Amount;

  B. SELECT (Order_Date, Amount) FROM Orders WHERE Order_Date LIKE %02 ORDER BY Amount;

  C. SELECT * FROM Orders WHERE Order_Date LIKE _02 ORDER BY Order_No;

  D. SELECT * FROM Orders WHERE Order_Date LIKE %02 ORDER BY Amount;

  Correct Answer: D

• Question 47:

  Which subset of Structured Query Language (SQL) is used to limit access to a database or its data?

  A. Data Definition Language

  B. Data Control Language

  C. Data Entity Language

  D. Data Manipulation Language

  Correct Answer: B

• Question 48:

  Your enterprise is developing a database system that will contain highly sensitive data; Security of the data will take priority over database processing speed. Which database protection technique should be employed?

  A. Backups

  B. User views

  C. Encryption

  D. Integrity controls

  Correct Answer: C

• Question 49:

  Which area of database security involves maintaining access to enterprise data?

  A. Integrity

  B. Privacy

  C. Availability

  D. Confidentiality

  Correct Answer: C

• Question 50:

  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

  Correct Answer: B