Date: 2009-10-14 19:55 Author: pass4line Click: 47
Pass4side provide the latest dumps CIW 1D0-541 exam download.
1. 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
Answer: D
2. 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 = ew York?WHERE Sales_Office = ?ew York?
C. DELETE *
FROM Customers
WHERE Sales_Office = ew York?WHERE Sales_Office = ?ew York?
D. DELETE
FROM Customers
WHERE Sales_Office NOT LIKE ew York? WHERE Sales_Office NOT LIKE ?ew York?
Answer: B
3. Consider the Employee relation shown in the exhibit. A database manager wants to set up a view called Emp_Dept that allows users to find employees and their department ID numbers. Which SQL statement will accomplish this?
A. CREATE VIEW Emp_Dept
AS SELECT Last_Name, First_Name, Dept_ID
FROM Employee;
B. UPDATE VIEW Emp_Dept
AS SELECT *
FROM Employee;
C. UPDATE VIEW Emp_Dept
AS SELECT Last_Name, First_Name, Dept_ID
FROM Employee;
D. CREATE VIEW Emp_Dept
AS SELECT *
FROM Employee
WHERE ID = 0001
AND ID = 0002
AND ID = 0003
AND ID = 0004;
Answer: A
4. 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 = tlanta
B. INSERT INTO Atlanta_Customers
SELECT *
FROM Customers
WHERE Sales_Office = tlanta
C. INSERT INTO Atlanta_Customers
SELECT Cust_No, Cust_Name, Satisfaction_Rate, Sales_Rep_No
FROM Customers
WHERE Sales_Office = tlanta
D. INSERT INTO Atlanta_Customers
SELECT Cust_No, Cust_Name, Sales_Office, Sales_Rep_No
FROM Customers
WHERE Sales_Office = tlanta
Answer: C
5. Which pair of relational algebraic operations requires union compatibility?
A. Union and join
B. Selection and projection
C. Intersection and difference
D. Cartesian product and intersection
Answer: C
6. Consider the following database information:
domain s_id: integer
domain grd: fixed length character string length 1
STUDENT_GRADE(
Student_Number: s_id NOT NULL
Grade: grd )
Primary Key Student_Number
During which phase of the database design process would this information be developed?
A. Logical
B. Physical
C. Conceptual
D. Implementation
Answer: A