CIW 1D0-541 Online Practice Questions and Exam Preparation

CIW 1D0-541 Online Questions & Answers

• Question 121:

  Consider the relations shown in the exhibit. Which of the following SQL statements would enter data from the Customers relation into the Atlanta_Customers relation?

  

  A. INSERT INTO Atlanta_Customers VALUES( SELECT * FROM Customer s WHERE Sales_Office = Atlanta);
  B. INSERT INTO Atlanta_Customers SELECT * FROM Customers WHERE Sales_Office = Atlanta;
  C. INSERT INTO Atlanta_Customers SELECT Cust_No, Cust_Name, Satisfaction_Rate, Sales_Rep_No FROM Customers WHERE Sales_Office = Atlanta;
  D. INSERT INTO Atlanta_Customers SELECT Cust_No, Cust_Name, Sales_Office, Sales_Rep_No FROM Customers WHERE Sales_Office = Atlanta;
  C. INSERT INTO Atlanta_Customers SELECT Cust_No, Cust_Name, Satisfaction_Rate, Sales_Rep_No FROM Customers WHERE Sales_Office = Atlanta;

• Question 122:

  Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create a set difference of the two relations with the widest variety of Structured Query Language dialects?

  

  A. SELECT * FROM Dept1_Parts EXCEPT (SELECT Part_ID FROM Dept2_Parts);
  B. SELECT * FROM Dept1_Parts MINUS (SELECT Part_ID FROM Dept2_Parts);
  C. SELECT * FROM Dept1_Parts DIFFERENCE (SELECT Part_ID FROM Dept2_Parts);
  D. SELECT * FROM Dept1_Parts DIFFERENCE (SELECT Part_ID FROM Dept2_Parts);
  D. SELECT * FROM Dept1_Parts DIFFERENCE (SELECT Part_ID FROM Dept2_Parts);

• Question 123:

  Which process is used to prevent the current database operation from reading or writing a data item while that data item is being accessed by another operation?

  A. Lock
  B. Deadlock
  C. Timestamp
  D. Batch
  A. Lock

• Question 124:

  Consider the Stu_Act and Act_Fee tables shown in the exhibit. Which relational algebraic operation would yield the Activity Relation table in the exhibit?

  

  A. Union
  B. Intersection
  C. Natural join
  D. Cartesian product
  C. Natural join

• Question 125:

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

  A. Integrity
  B. Privacy
  C. Availability
  D. Confidentiality
  C. Availability

• Question 126:

  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;
  A. GRANT UPDATE ON Project TO Rubio, Doe; GRANT SELECT ON Project TO Temp;

• Question 127:

  Consider the entity-relationship (ER) diagram shown in the exhibit. What do the characters at the ends of the connecting line indicate?

  

  A. Degree of a relation
  B. Cardinality of a relation
  C. Primary key of a relation
  D. Determinant of a relation
  B. Cardinality of a relation

• Question 128:

  Which pair of relational algebraic operations requires union compatibility?

  A. Projection and Cartesian product
  B. Selection and projection
  C. Intersection and difference
  D. Cartesian product and intersection
  C. Intersection and difference